Move promscale tuning to role and tune WAL sizes

[chef.git] / roles / prometheus.rb

diff --git a/roles/prometheus.rb b/roles/prometheus.rb
index 1b97fdb72306015dea887af9ad078e34d4dc91bf..0016c6c0fef33d6018252652d750daa56f471d36 100644 (file)
--- a/roles/prometheus.rb
+++ b/roles/prometheus.rb
@@ -1,6 +1,33 @@
 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",
+        :autovacuum_max_workers => "10",
+        :autovacuum_naptime => "10",
+        :max_locks_per_transaction => "512"
+      }
+    }
+  }
+)
+
 run_list(
   "recipe[prometheus::server]"
 )