]> git.openstreetmap.org Git - chef.git/commitdiff
Tune autovaccum for promscale
authorTom Hughes <tom@compton.nu>
Thu, 19 May 2022 20:37:39 +0000 (21:37 +0100)
committerTom Hughes <tom@compton.nu>
Thu, 19 May 2022 20:37:39 +0000 (21:37 +0100)
roles/prometheus.rb

index 84a176615d349db7dca2e10b2680cb8cc6b10c3a..e6a5f667b0875c5de3b3f1e3b9e39159fe61598f 100644 (file)
@@ -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"
       }