From 27e33fa61307e73ca2b81bc16ac09699878970ce Mon Sep 17 00:00:00 2001 From: Tom Hughes Date: Tue, 20 Feb 2018 16:05:25 +0000 Subject: [PATCH] Allow vacuum_scale_factor and analyze_scale_factor to be configured --- cookbooks/postgresql/attributes/default.rb | 2 ++ cookbooks/postgresql/templates/default/postgresql.conf.erb | 2 ++ 2 files changed, 4 insertions(+) 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] = [] diff --git a/cookbooks/postgresql/templates/default/postgresql.conf.erb b/cookbooks/postgresql/templates/default/postgresql.conf.erb index 926ecef82..565d18031 100644 --- a/cookbooks/postgresql/templates/default/postgresql.conf.erb +++ b/cookbooks/postgresql/templates/default/postgresql.conf.erb @@ -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 -- 2.43.2