From 6fc0e26a301113ee8a92bf928b764e873fb03a4e Mon Sep 17 00:00:00 2001 From: Tom Hughes Date: Wed, 29 Apr 2015 00:26:45 +0100 Subject: [PATCH] Increase postgresql memory limits on yevaud --- roles/yevaud.rb | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/roles/yevaud.rb b/roles/yevaud.rb index fd8457ec5..362ddb12f 100644 --- a/roles/yevaud.rb +++ b/roles/yevaud.rb @@ -75,9 +75,9 @@ default_attributes( :versions => ["9.4"], :settings => { :defaults => { - :shared_buffers => "3GB", + :shared_buffers => "8GB", :maintenance_work_mem => "7144MB", - :effective_cache_size => "8GB" + :effective_cache_size => "16GB" } } }, @@ -85,8 +85,8 @@ default_attributes( :postgres => { :comment => "Increase shared memory for postgres", :parameters => { - "kernel.shmmax" => 4 * 1024 * 1024 * 1024, - "kernel.shmall" => 4 * 1024 * 1024 * 1024 / 4096 + "kernel.shmmax" => 9 * 1024 * 1024 * 1024, + "kernel.shmall" => 9 * 1024 * 1024 * 1024 / 4096 } }, :cpu_tune => { -- 2.43.2