Dave Page wrote:
On Fri, Dec 11, 2009 at 9:02 AM, Massa, Harald Armin <c...@ghum.de> wrote:
I got MUCH better results by drastically lowering shared_buffers on
Windows. Drastically = 8MB.
Wow - really? Greg and I did some rough pgbench experiments last year
and were finding the on a 4GB machine, running XP Pro, 512MB seemed to
be optimal, but it was only marginally better than 128 or 256MB. Going
lower than that made a noticable difference, and going higher we saw
performance dropping off again as well.
Dave is talking about Greg Stark here, lest anyone credit me for
something I wasn't involved in. I just updated the shared_buffers
section of "Tuning Your PostgreSQL Server" to reflect Dave's comments
and to generally clean up the Windows suggestions here. I recall seeing
some comments in the past that suggested earlier systems started to fall
off at closer to 64MB rather than 128MB, tweaked the wording there
accordingly. 8MB working out best is really unexpected though; I'd like
to know what you were doing where *that* was the optimal setting.
--
Greg Smith 2ndQuadrant Baltimore, MD
PostgreSQL Training, Services and Support
g...@2ndquadrant.com www.2ndQuadrant.com
