tweak poldi's postgres settings
authorSarah Hoffmann <lonvia@denofr.de>
Thu, 16 Jul 2015 10:25:12 +0000 (12:25 +0200)
committerSarah Hoffmann <lonvia@denofr.de>
Thu, 16 Jul 2015 10:25:12 +0000 (12:25 +0200)
roles/poldi.rb

index c0ffaaddf6bfb098464079034d63d3f1ae7ac463..1c180ab8aaea30229bb556963ebf10d5d4d55321 100644 (file)
@@ -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"
       }
     }