Re: Setting Shared-Buffers

On Fri, Jul 10, 2009 at 08:49:40AM -0500, Kevin Grittner wrote:

> > So, what's a good value to set to effective_cache_size with 10 Gb
> > RAM?
>
> It depends on how many other things you have on the system which are
> using RAM, but probably something around 9GB would be appropriate.
> Maybe even 9.5GB.

I've seen PostgreSQL perform a lot worse after setting
effective_cache_size to 2 GB on a 8 GB dedicated database system. The
planner started ignoring indices and doing sequential scans. Lowering
effective_cache_size to 512 MB solved that.

Tino.

--
"What we nourish flourishes." - "Was wir nähren erblüht."

www.lichtkreis-chemnitz.de
www.craniosacralzentrum.de