>> 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.
Yes, really, I am astonished too. Necessary information: it is a very low concurrency workload, and system is as low as 1GB. Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 no fx, no carrier pigeon - %s is too gigantic of an industry to bend to the whims of reality -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
