reduce shared_buffers for poldi
authorSarah Hoffmann <lonvia@denofr.de>
Sat, 20 Dec 2014 20:34:39 +0000 (21:34 +0100)
committerSarah Hoffmann <lonvia@denofr.de>
Sat, 20 Dec 2014 20:34:39 +0000 (21:34 +0100)
roles/poldi.rb

index 6fae55939b2ffecec9ef7092c323cf7bc4d694e5..6b0b0100fdafc5a018cbca2a0e1d53cfdfe4299d 100644 (file)
@@ -54,9 +54,9 @@ default_attributes(
     :versions => [ "9.3" ],
     :settings => {
       :defaults => {
-        :shared_buffers => "24GB",
+        :shared_buffers => "10GB",
         :work_mem => "160MB",
-        :maintenance_work_mem => "10GB",
+        :maintenance_work_mem => "16GB",
         :random_page_cost => "1.5",
         :effective_cache_size => "48GB",
         :fsync => "off"