X-Git-Url: https://git.openstreetmap.org/chef.git/blobdiff_plain/f7dd6716f0f63c8f74b2a14efe19672a0853c6c2..c389f176ac7a568bedaa7bdd690438b72ecf35bf:/cookbooks/postgresql/attributes/default.rb diff --git a/cookbooks/postgresql/attributes/default.rb b/cookbooks/postgresql/attributes/default.rb index 553efa302..419b44de8 100644 --- a/cookbooks/postgresql/attributes/default.rb +++ b/cookbooks/postgresql/attributes/default.rb @@ -19,7 +19,6 @@ default[:postgresql][:settings][:defaults][:synchronous_commit] = "on" default[:postgresql][:settings][:defaults][:wal_buffers] = "-1" default[:postgresql][:settings][:defaults][:wal_writer_delay] = "200ms" default[:postgresql][:settings][:defaults][:commit_delay] = "0" -default[:postgresql][:settings][:defaults][:checkpoint_segments] = "3" default[:postgresql][:settings][:defaults][:checkpoint_timeout] = "5min" default[:postgresql][:settings][:defaults][:max_wal_size] = "1GB" default[:postgresql][:settings][:defaults][:min_wal_size] = "80MB" @@ -41,11 +40,11 @@ default[:postgresql][:settings][:defaults][:autovacuum_max_workers] = "3" default[:postgresql][:settings][:defaults][:autovacuum_naptime] = "1min" default[:postgresql][:settings][:defaults][:autovacuum_vacuum_scale_factor] = "0.2" default[:postgresql][:settings][:defaults][:autovacuum_analyze_scale_factor] = "0.1" +default[:postgresql][:settings][:defaults][:autovacuum_freeze_max_age] = "200000000" +default[:postgresql][:settings][:defaults][:autovacuum_multixact_freeze_max_age] = "400000000" default[:postgresql][:settings][:defaults][:shared_preload_libraries] = [] default[:postgresql][:settings][:defaults][:max_locks_per_transaction] = "64" default[:postgresql][:settings][:defaults][:user_name_maps] = {} default[:postgresql][:settings][:defaults][:early_authentication_rules] = [] default[:postgresql][:settings][:defaults][:late_authentication_rules] = [] default[:postgresql][:settings][:defaults][:standby_mode] = "off" - -default[:apt][:sources] = node[:apt][:sources] | ["postgresql"]