I wrote: > work_mem = 32MB Hmmm... With 100 connections and 2 GB RAM, that is probably on the high side, at least if you sometimes use a lot of those connections at the same time to run queries which might use sorts or hashes. It's probably safer to go down to 16MB or even back to where you had it. Sorry I missed that before. -Kevin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
