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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
