Reduce random_page_cost for postgres instances on SSD
authorTom Hughes <tom@compton.nu>
Thu, 7 Dec 2017 12:06:11 +0000 (12:06 +0000)
committerTom Hughes <tom@compton.nu>
Thu, 7 Dec 2017 12:06:11 +0000 (12:06 +0000)
roles/eddie.rb
roles/karm.rb
roles/tile.rb

index 7996659..8e9c7c1 100644 (file)
@@ -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"
       }
     }
   },
index e200ce7..8f091af 100644 (file)
@@ -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"
       }
     }
   },
index fe08c49..686de9e 100644 (file)
@@ -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"
       }
     }