]> git.openstreetmap.org Git - chef.git/blobdiff - roles/poldi.rb
Increase cpu_tuple_cost on database servers
[chef.git] / roles / poldi.rb
index 77b905b360c050568e141efaeb67619a102d6d89..5f73b6239b07472e55c1663fed221d44bfc494c5 100644 (file)
@@ -50,11 +50,11 @@ default_attributes(
   :postgresql => {
     :settings => {
       :defaults => {
-        :shared_buffers => "9GB",
+        :shared_buffers => "24GB",
         :work_mem => "160MB",
-        :maintenance_work_mem => "9GB",
+        :maintenance_work_mem => "10GB",
         :random_page_cost => "1.5",
-        :effective_cache_size => "24GB"
+        :effective_cache_size => "48GB"
       }
     }
   }