From aec91e5d36f0eddffa7eb48c26f8804a922a84b3 Mon Sep 17 00:00:00 2001 From: Tom Hughes Date: Thu, 19 May 2022 21:37:39 +0100 Subject: [PATCH 1/1] Tune autovaccum for promscale --- roles/prometheus.rb | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/roles/prometheus.rb b/roles/prometheus.rb index 84a176615..e6a5f667b 100644 --- a/roles/prometheus.rb +++ b/roles/prometheus.rb @@ -21,8 +21,8 @@ default_attributes( :effective_cache_size => "144GB", :default_statistics_target => "500", :log_autovacuum_min_duration => "0", - :autovacuum_max_workers => "10", - :autovacuum_naptime => "10", + :autovacuum_max_workers => "56", + :autovacuum_naptime => "1", :autovacuum_multixact_freeze_max_age => "200000000", :max_locks_per_transaction => "512" } -- 2.45.2