X-Git-Url: https://git.openstreetmap.org./chef.git/blobdiff_plain/b7e5b92b0db9f821a318e2b28c1254fe234c0e15..c5c4c635e033924703553f8ec8e6b1eace189310:/cookbooks/postgresql/attributes/default.rb diff --git a/cookbooks/postgresql/attributes/default.rb b/cookbooks/postgresql/attributes/default.rb index 88942aa6f..878407aec 100644 --- a/cookbooks/postgresql/attributes/default.rb +++ b/cookbooks/postgresql/attributes/default.rb @@ -26,8 +26,10 @@ default[:postgresql][:settings][:defaults][:min_wal_size] = "80MB" default[:postgresql][:settings][:defaults][:archive_mode] = "off" default[:postgresql][:settings][:defaults][:max_wal_senders] = "10" default[:postgresql][:settings][:defaults][:max_replication_slots] = "10" +default[:postgresql][:settings][:defaults][:wal_keep_size] = "0" default[:postgresql][:settings][:defaults][:hot_standby] = "on" default[:postgresql][:settings][:defaults][:hot_standby_feedback] = "off" +default[:postgresql][:settings][:defaults][:seq_page_cost] = "1.0" default[:postgresql][:settings][:defaults][:random_page_cost] = "4.0" default[:postgresql][:settings][:defaults][:cpu_tuple_cost] = "0.01" default[:postgresql][:settings][:defaults][:effective_cache_size] = "4GB"