Reduce random_page_cost for postgres instances on SSD

diff --git a/roles/eddie.rb b/roles/eddie.rb
index 79966590854c4b93f4ef312c33202dc3f76c6685..8e9c7c1a87e7f744c761e4210a5fe18d2af4cc52 100644 (file)
--- 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",
         :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 e200ce7cbac23edb65c3144135857b34f6350aeb..8f091af2fc26058c13449ccb8ace0c3a6c251a7a 100644 (file)
--- 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",
         :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 fe08c49a8646912413394bb4ecf5cafefb16c3c5..686de9e3900648978c56ed92c11d0c7bcac5ce07 100644 (file)
--- a/roles/tile.rb
+++ b/roles/tile.rb
@@ -42,6 +42,7 @@ default_attributes(
         :commit_delay => "10000",
         :checkpoint_segments => "60",
         :max_wal_size => "2880MB",
         :commit_delay => "10000",
         :checkpoint_segments => "60",
         :max_wal_size => "2880MB",

+        :random_page_cost => "1.1",

         :track_activity_query_size => "16384"
       }
     }
         :track_activity_query_size => "16384"
       }
     }