X-Git-Url: https://git.openstreetmap.org./chef.git/blobdiff_plain/70574222913bd96fdbcbdc1443fa6b367b876814..699e157e3d708f38064eea9072aa210fe5ccac30:/cookbooks/postgresql/templates/default/postgresql.conf.erb?ds=sidebyside diff --git a/cookbooks/postgresql/templates/default/postgresql.conf.erb b/cookbooks/postgresql/templates/default/postgresql.conf.erb index 6b38d55d6..d75c2f427 100644 --- a/cookbooks/postgresql/templates/default/postgresql.conf.erb +++ b/cookbooks/postgresql/templates/default/postgresql.conf.erb @@ -138,15 +138,19 @@ log_line_prefix = '%t ' # - Query/Index Statistics Collector - track_activity_query_size = <%= @settings[:track_activity_query_size] || @defaults[:track_activity_query_size] %> +stats_temp_directory = '/run/postgresql/<%= @version %>-main.pg_stat_tmp' #------------------------------------------------------------------------------ # AUTOVACUUM PARAMETERS #------------------------------------------------------------------------------ +log_autovacuum_min_duration = <%= @settings[:log_autovacuum_min_duration] || @defaults[:log_autovacuum_min_duration] %> autovacuum_max_workers = <%= @settings[:autovacuum_max_workers] || @defaults[:autovacuum_max_workers] %> autovacuum_naptime = <%= @settings[:autovacuum_naptime] || @defaults[:autovacuum_naptime] %> 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] %> +autovacuum_freeze_max_age = <%= @settings[:autovacuum_freeze_max_age] || @defaults[:autovacuum_freeze_max_age] %> +autovacuum_multixact_freeze_max_age = <%= @settings[:autovacuum_multixact_freeze_max_age] || @defaults[:autovacuum_multixact_freeze_max_age] %> #------------------------------------------------------------------------------ # CLIENT CONNECTION DEFAULTS