X-Git-Url: https://git.openstreetmap.org./chef.git/blobdiff_plain/dc7216b15b33567990e864c855d928ac9e73ad07..f1cfd16d358496bafb94dfc8c40585fdc6567963:/cookbooks/postgresql/attributes/default.rb diff --git a/cookbooks/postgresql/attributes/default.rb b/cookbooks/postgresql/attributes/default.rb index cc8c9a59e..770c0dbea 100644 --- a/cookbooks/postgresql/attributes/default.rb +++ b/cookbooks/postgresql/attributes/default.rb @@ -36,10 +36,13 @@ default[:postgresql][:settings][:defaults][:default_statistics_target] = "100" default[:postgresql][:settings][:defaults][:jit] = "on" default[:postgresql][:settings][:defaults][:log_min_duration_statement] = "-1" default[:postgresql][:settings][:defaults][:track_activity_query_size] = "1024" +default[:postgresql][:settings][:defaults][:log_autovacuum_min_duration] = "-1" 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] = {}