On 12:03 pm 07/18/08 Martijn van Oosterhout <[EMAIL PROTECTED]> wrote:
> Perhaps you can try reducing the shared_buffers, to see if that helps > more? Will try. > 8MB is quite small for workmem. More shared_buffers is not > necessarily better. Ok, but from everything I had read shared_buffers of 1/4 seemed like a starting point. Will try reducing it to 2GB. > Also, how much swap are you running? Started out with 12GB (same as memory) and last night I added 24GB more. I had 2 instances of inserts going so each exausted about 18GB of ram! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general