Reference: http://postgresql.1045698.n5.nabble.com/Simple-join-doesn-t-use-index-td5738689.html

This is a pretty common gotcha: user sets shared_buffers but misses
the esoteric but important effective_cache_size.  ISTM
effective_cache_size should always be >= shared buffers -- this is a
soft configuration error that could be reported as a warning and
perhaps overridden on the fly.

merlin

Responses

• Re: proposal: Set effective_cache_size to greater of .conf value, shared_buffers at 2013-01-08 14:53:29 from Claudio Freire

pgsql-hackers by date

Next:	From: Claudio Freire	Date: 2013-01-08 14:51:06
	Subject: Re: Improve compression speeds in pg_lzcompress.c
Previous:	From: Andres Freund	Date: 2013-01-08 14:31:14
	Subject: Re: Extra XLOG in Checkpoint for StandbySnapshot