Allow vacuum_scale_factor and analyze_scale_factor to be configured
authorTom Hughes <tom@compton.nu>
Tue, 20 Feb 2018 16:05:25 +0000 (16:05 +0000)
committerTom Hughes <tom@compton.nu>
Tue, 20 Feb 2018 16:05:25 +0000 (16:05 +0000)
cookbooks/postgresql/attributes/default.rb
cookbooks/postgresql/templates/default/postgresql.conf.erb

index 5829b9fe31650c1b5de52389320cb77d1bf4e43d..dce61724fdf3ee97979813a2e3f26a9b1a8a44ed 100644 (file)
@@ -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] = []
index 926ecef82565e267b087e1a35b611364acb2d2ac..565d18031edfb1924488ce66c617a7eec27ee933 100644 (file)
@@ -127,6 +127,8 @@ track_activity_query_size = <%= @settings[:track_activity_query_size] || @defaul
 #------------------------------------------------------------------------------
 
 autovacuum_max_workers = <%= @settings[:autovacuum_max_workers] || @defaults[:autovacuum_max_workers] %>
+autovacuum_vacuum_scale_factor =<%= @settings[:autovacuum_vacuum_scale_factor] || @defaults[:autovacuum_vacuum_scale_factor] %>
+autovacuum_analyze_scale_factor =<%= @settings[:autovacuum_analyze_scale_factor] || @defaults[:autovacuum_analyze_scale_factor] %>
 
 #------------------------------------------------------------------------------
 # CLIENT CONNECTION DEFAULTS