On 12:03 pm 07/18/08 Martijn van Oosterhout <kleptog@xxxxxxxxx> 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!
