From: Sarah Hoffmann <lonvia@denofr.de>
Date: Thu, 16 Jul 2015 10:25:12 +0000 (+0200)
Subject: tweak poldi's postgres settings
X-Git-Url: https://git.openstreetmap.org/chef.git/commitdiff_plain/eceff52f5c6f0d1e50fa1e9cc98878a6a883c6ed?ds=sidebyside

tweak poldi's postgres settings
---

diff --git a/roles/poldi.rb b/roles/poldi.rb
index c0ffaaddf..1c180ab8a 100644
--- a/roles/poldi.rb
+++ b/roles/poldi.rb
@@ -63,7 +63,7 @@ default_attributes(
         :work_mem => "160MB",
         :maintenance_work_mem => "10GB",
         :random_page_cost => "1.5",
-        :effective_cache_size => "70GB",
+        :effective_cache_size => "40GB",
         :fsync => "on"
       }
     }