On Wed, 20 May 2009, Kobby Dapaah wrote:
shared_buffers = 2048MB effective_cache_size = 5400MB
You should consider seriously increasing effective_cache_size. You might also double or quadruple shared_buffers from 2GB, but going much higher may not buy you much--most people seem to find diminishing returns increasing that beyond the 10GB range.
bgwriter_delay = 10ms bgwriter_lru_maxpages = 0
I found that bg_writer_delay doesn't really work so well when set to this small. It doesn't actually matter right now though, because you're turning the background writer off by setting brwriter_lru_maxpages=0. Just wanted to point this out because if you increase that later it may pop up as a concern, small values for the delay make it more likely you'll need to increase the multiplier to a higher value for background writing to work well.
Robert's message already mentions the other things you should consider, particularly work_mem.
-- * Greg Smith gsmith@xxxxxxxxxxxxx http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
