From 41bdac8f1d96696cd28642ef0247a07ed59cfae8 Mon Sep 17 00:00:00 2001 From: Tom Hughes Date: Tue, 2 Mar 2021 18:53:14 +0000 Subject: [PATCH 1/1] Reduce maximum multixact age for promscale --- cookbooks/postgresql/attributes/default.rb | 2 ++ cookbooks/postgresql/templates/default/postgresql.conf.erb | 2 ++ roles/prometheus.rb | 1 + 3 files changed, 5 insertions(+) diff --git a/cookbooks/postgresql/attributes/default.rb b/cookbooks/postgresql/attributes/default.rb index 553efa302..770c0dbea 100644 --- a/cookbooks/postgresql/attributes/default.rb +++ b/cookbooks/postgresql/attributes/default.rb @@ -41,6 +41,8 @@ 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] = {} diff --git a/cookbooks/postgresql/templates/default/postgresql.conf.erb b/cookbooks/postgresql/templates/default/postgresql.conf.erb index 09b026db3..d75c2f427 100644 --- a/cookbooks/postgresql/templates/default/postgresql.conf.erb +++ b/cookbooks/postgresql/templates/default/postgresql.conf.erb @@ -149,6 +149,8 @@ autovacuum_max_workers = <%= @settings[:autovacuum_max_workers] || @defaults[:au 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 diff --git a/roles/prometheus.rb b/roles/prometheus.rb index e66da0fd9..84a176615 100644 --- a/roles/prometheus.rb +++ b/roles/prometheus.rb @@ -23,6 +23,7 @@ default_attributes( :log_autovacuum_min_duration => "0", :autovacuum_max_workers => "10", :autovacuum_naptime => "10", + :autovacuum_multixact_freeze_max_age => "200000000", :max_locks_per_transaction => "512" } } -- 2.43.2