> # - 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. please try it. (there is no clear understanding WHY shared buffers on Windows most often behave totally different then on unix) 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
