From: Tom Hughes <tom@compton.nu>
Date: Thu, 19 May 2022 20:37:39 +0000 (+0100)
Subject: Tune autovaccum for promscale
X-Git-Url: https://git.openstreetmap.org./chef.git/commitdiff_plain/aec91e5d36f0eddffa7eb48c26f8804a922a84b3?hp=8ba2e5010812ff169ada588834ef5606d166d526

Tune autovaccum for promscale
---

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"
       }