On Fri, Dec 11, 2009 at 9:02 AM, Massa, Harald Armin <chef@xxxxxxx> wrote: >> # - Memory - >> shared_buffers = 512MB >> work_mem = 256MB > this settings would be good for PostgreSQL on Unix and Unixlike systems. > > 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 Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
