X-Git-Url: https://git.openstreetmap.org./chef.git/blobdiff_plain/c276a3a197cfe8a2e606c0b0eb606f5afeaae132..22f20357a5fa17247d573014e417fab9f47d8ffc:/cookbooks/postgresql/attributes/default.rb?ds=sidebyside

diff --git a/cookbooks/postgresql/attributes/default.rb b/cookbooks/postgresql/attributes/default.rb
index 5829b9fe3..dce61724f 100644
--- a/cookbooks/postgresql/attributes/default.rb
+++ b/cookbooks/postgresql/attributes/default.rb
@@ -29,6 +29,8 @@ default[:postgresql][:settings][:defaults][:effective_cache_size] = "128MB"
 default[:postgresql][:settings][:defaults][:log_min_duration_statement] = "-1"
 default[:postgresql][:settings][:defaults][:track_activity_query_size] = "1024"
 default[:postgresql][:settings][:defaults][:autovacuum_max_workers] = "3"
+default[:postgresql][:settings][:defaults][:autovacuum_vacuum_scale_factor] = "0.2"
+default[:postgresql][:settings][:defaults][:autovacuum_analyze_scale_factor] = "0.1"
 default[:postgresql][:settings][:defaults][:user_name_maps] = {}
 default[:postgresql][:settings][:defaults][:early_authentication_rules] = []
 default[:postgresql][:settings][:defaults][:late_authentication_rules] = []