X-Git-Url: https://git.openstreetmap.org./chef.git/blobdiff_plain/3f62b20fd0888cca97803c720846e2b5d3fd4330..6fc0e26a301113ee8a92bf928b764e873fb03a4e:/roles/yevaud.rb

diff --git a/roles/yevaud.rb b/roles/yevaud.rb
index ebcd86ad1..362ddb12f 100644
--- a/roles/yevaud.rb
+++ b/roles/yevaud.rb
@@ -72,12 +72,12 @@ default_attributes(
     }
   },
   :postgresql => {
-    :versions => ["9.1"],
+    :versions => ["9.4"],
     :settings => {
       :defaults => {
-        :shared_buffers => "3GB",
+        :shared_buffers => "8GB",
         :maintenance_work_mem => "7144MB",
-        :effective_cache_size => "8GB"
+        :effective_cache_size => "16GB"
       }
     }
   },
@@ -85,12 +85,22 @@ default_attributes(
     :postgres => {
       :comment => "Increase shared memory for postgres",
       :parameters => {
-        "kernel.shmmax" => 4 * 1024 * 1024 * 1024,
-        "kernel.shmall" => 4 * 1024 * 1024 * 1024 / 4096
+        "kernel.shmmax" => 9 * 1024 * 1024 * 1024,
+        "kernel.shmall" => 9 * 1024 * 1024 * 1024 / 4096
+      }
+    },
+    :cpu_tune => {
+      :comment => "Tune kern sched migration cost",
+      :parameters => {
+        "kernel.sched_autogroup_enabled" => 0,
+        "kernel.sched_migration_cost_ns" => 25000000
       }
     }
   },
   :tile => {
+    :database => {
+      :cluster => "9.4/main"
+    },
     :node_file => "/store/database/nodes",
     :styles => {
       :default => {