X-Git-Url: https://git.openstreetmap.org./chef.git/blobdiff_plain/67dc08878168564a60eca6f4372155ff20720e8d..6abf28ac8a3c059c4f58a71d4c42f0c146320a87:/roles/prometheus.rb

diff --git a/roles/prometheus.rb b/roles/prometheus.rb
index 1b97fdb72..e6a5f667b 100644
--- a/roles/prometheus.rb
+++ b/roles/prometheus.rb
@@ -1,6 +1,35 @@
 name "prometheus"
 description "Role applied to all prometheus servers"
 
+default_attributes(
+  :postgresql => {
+    :settings => {
+      :defaults => {
+        :max_connections => "500",
+        :shared_buffers => "48GB",
+        :work_mem => "8MB",
+        :maintenance_work_mem => "2GB",
+        :effective_io_concurrency => "200",
+        :max_worker_processes => "67",
+        :max_parallel_workers_per_gather => "28",
+        :max_parallel_workers => "56",
+        :wal_buffers => "16MB",
+        :max_wal_size => "32GB",
+        :min_wal_size => "4GB",
+        :checkpoint_completion_target => "0.9",
+        :random_page_cost => "1.1",
+        :effective_cache_size => "144GB",
+        :default_statistics_target => "500",
+        :log_autovacuum_min_duration => "0",
+        :autovacuum_max_workers => "56",
+        :autovacuum_naptime => "1",
+        :autovacuum_multixact_freeze_max_age => "200000000",
+        :max_locks_per_transaction => "512"
+      }
+    }
+  }
+)
+
 run_list(
   "recipe[prometheus::server]"
 )