Reduce maximum multixact age for promscale

[chef.git] / roles / prometheus.rb

diff --git a/roles/prometheus.rb b/roles/prometheus.rb
index 0016c6c0fef33d6018252652d750daa56f471d36..84a176615d349db7dca2e10b2680cb8cc6b10c3a 100644 (file)
--- a/roles/prometheus.rb
+++ b/roles/prometheus.rb
@@ -20,8 +20,10 @@ default_attributes(
         :random_page_cost => "1.1",
         :effective_cache_size => "144GB",
         :default_statistics_target => "500",
         :random_page_cost => "1.1",
         :effective_cache_size => "144GB",
         :default_statistics_target => "500",

+        :log_autovacuum_min_duration => "0",

         :autovacuum_max_workers => "10",
         :autovacuum_naptime => "10",
         :autovacuum_max_workers => "10",
         :autovacuum_naptime => "10",

+        :autovacuum_multixact_freeze_max_age => "200000000",

         :max_locks_per_transaction => "512"
       }
     }
         :max_locks_per_transaction => "512"
       }
     }