tweak poldi's postgres settings

diff --git a/roles/poldi.rb b/roles/poldi.rb
index c0ffaaddf6bfb098464079034d63d3f1ae7ac463..1c180ab8aaea30229bb556963ebf10d5d4d55321 100644 (file)
--- 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",
         :work_mem => "160MB",
         :maintenance_work_mem => "10GB",
         :random_page_cost => "1.5",

-        :effective_cache_size => "70GB",
+        :effective_cache_size => "40GB",

         :fsync => "on"
       }
     }
         :fsync => "on"
       }
     }