Hi, On 10 October 2012 19:11, Julien Cigar <jcigar@xxxxxxxxx> 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.ivanic@xxxxxxxxx) (http://www.linkedin.com/in/ondrejivanic) -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
