Reduce random_page_cost for postgres instances on SSD

[chef.git] / roles / karm.rb

diff --git a/roles/karm.rb b/roles/karm.rb
index 21a497a6742454af3e20cd7c7048f2733e576473..8f091af2fc26058c13449ccb8ace0c3a6c251a7a 100644 (file)
--- a/roles/karm.rb
+++ b/roles/karm.rb
@@ -6,7 +6,7 @@ default_attributes(
     :sources => ["postgresql"]
   },
   :db => {
-    :cluster => "9.1/main"
+    :cluster => "9.5/main"
   },
   :networking => {
     :interfaces => {
@@ -26,10 +26,10 @@ default_attributes(
         :work_mem => "64MB",
         :maintenance_work_mem => "1GB",
         :effective_cache_size => "180GB",
-        :effective_io_concurrency => "256"
+        :effective_io_concurrency => "256",
+        :random_page_cost => "1.1"
       }
-    },
-    :versions => ["9.1"]
+    }
   },
   :sysctl => {
     :postgres => {
@@ -50,7 +50,8 @@ default_attributes(
         "block/nvme3n1/queue/nomerges" => "1",
         "block/nvme4n1/queue/nomerges" => "1",
         "block/nvme5n1/queue/nomerges" => "1",
-        "block/nvme6n1/queue/nomerges" => "1"
+        "block/nvme6n1/queue/nomerges" => "1",
+        "block/nvme7n1/queue/nomerges" => "1"
       }
     }
   }