From: Tom Hughes <tom@compton.nu>
Date: Thu, 7 Dec 2017 12:06:11 +0000 (+0000)
Subject: Reduce random_page_cost for postgres instances on SSD
X-Git-Url: https://git.openstreetmap.org/chef.git/commitdiff_plain/d54beb537973507b9b63e1636fb9216f3dd0c11a

Reduce random_page_cost for postgres instances on SSD
---

diff --git a/roles/eddie.rb b/roles/eddie.rb
index 799665908..8e9c7c1a8 100644
--- a/roles/eddie.rb
+++ b/roles/eddie.rb
@@ -25,7 +25,8 @@ 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"
       }
     }
   },
diff --git a/roles/karm.rb b/roles/karm.rb
index e200ce7cb..8f091af2f 100644
--- a/roles/karm.rb
+++ b/roles/karm.rb
@@ -26,7 +26,8 @@ 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"
       }
     }
   },
diff --git a/roles/tile.rb b/roles/tile.rb
index fe08c49a8..686de9e39 100644
--- a/roles/tile.rb
+++ b/roles/tile.rb
@@ -42,6 +42,7 @@ default_attributes(
         :commit_delay => "10000",
         :checkpoint_segments => "60",
         :max_wal_size => "2880MB",
+        :random_page_cost => "1.1",
         :track_activity_query_size => "16384"
       }
     }