Hi,
On 10 October 2012 19:11, Julien Cigar <jcigar(at)ulb(dot)ac(dot)be> wrote:
>> shared_buffers = 10GB
>
>
> Generally going over 4GB for shared_buffers doesn't help.. some of the
> overhead of bgwriter and checkpoints is more or less linear in the size of
> shared_buffers ..
Nothing is black or white; It's all shades of Grey :) It depends on
workload. In my case external consultants recommended 8GB and I was
able to increase it up to 10GB. This was mostly read-only workload.
>From my experience large buffer cache acts as handbrake for
write-heavy workloads.
--
Ondrej Ivanic
(ondrej(dot)ivanic(at)gmail(dot)com)
(http://www.linkedin.com/in/ondrejivanic)