X-Git-Url: https://git.openstreetmap.org./chef.git/blobdiff_plain/c9f9e7c106d1bdc14ef5a5b97712d25ec0ad9e6a..c5c4c635e033924703553f8ec8e6b1eace189310:/cookbooks/postgresql/attributes/default.rb?ds=sidebyside diff --git a/cookbooks/postgresql/attributes/default.rb b/cookbooks/postgresql/attributes/default.rb index 54a224345..878407aec 100644 --- a/cookbooks/postgresql/attributes/default.rb +++ b/cookbooks/postgresql/attributes/default.rb @@ -1,6 +1,6 @@ default[:postgresql][:versions] = [] default[:postgresql][:clusters] = {} -default[:postgresql][:monitor_tables] = true +default[:postgresql][:monitor_database] = "postgres" default[:postgresql][:settings][:defaults][:port] = "5432" default[:postgresql][:settings][:defaults][:max_connections] = "100" default[:postgresql][:settings][:defaults][:ssl] = "true" @@ -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"