From d54beb537973507b9b63e1636fb9216f3dd0c11a Mon Sep 17 00:00:00 2001 From: Tom Hughes Date: Thu, 7 Dec 2017 12:06:11 +0000 Subject: [PATCH] Reduce random_page_cost for postgres instances on SSD --- roles/eddie.rb | 3 ++- roles/karm.rb | 3 ++- roles/tile.rb | 1 + 3 files changed, 5 insertions(+), 2 deletions(-) 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" } } -- 2.39.5