Tune autovaccum for promscale

diff --git a/roles/prometheus.rb b/roles/prometheus.rb
index 84a176615d349db7dca2e10b2680cb8cc6b10c3a..e6a5f667b0875c5de3b3f1e3b9e39159fe61598f 100644 (file)
--- 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",
         :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"
       }
         :autovacuum_multixact_freeze_max_age => "200000000",
         :max_locks_per_transaction => "512"
       }