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 d9e604a52cf0b45f47c45e8662a5e5857d52132b..8f091af2fc26058c13449ccb8ace0c3a6c251a7a 100644 (file)
--- a/roles/karm.rb
+++ b/roles/karm.rb
@@ -25,10 +25,11 @@ default_attributes(
         :shared_buffers => "64GB",
         :work_mem => "64MB",
         :maintenance_work_mem => "1GB",
-        :effective_cache_size => "180GB"
+        :effective_cache_size => "180GB",
+        :effective_io_concurrency => "256",
+        :random_page_cost => "1.1"
       }
-    },
-    :versions => ["9.5"]
+    }
   },
   :sysctl => {
     :postgres => {
@@ -48,7 +49,9 @@ default_attributes(
         "block/nvme2n1/queue/nomerges" => "1",
         "block/nvme3n1/queue/nomerges" => "1",
         "block/nvme4n1/queue/nomerges" => "1",
-        "block/nvme5n1/queue/nomerges" => "1"
+        "block/nvme5n1/queue/nomerges" => "1",
+        "block/nvme6n1/queue/nomerges" => "1",
+        "block/nvme7n1/queue/nomerges" => "1"
       }
     }
   }
@@ -56,5 +59,6 @@ default_attributes(
 
 run_list(
   "role[ic]",
-  "role[db-master]"
+  "role[db-master]",
+  "role[db-backup]"
 )