On 3:55 pm 07/18/08 Tom Lane <[EMAIL PROTECTED]> wrote: > > AfterTriggerEvents: 10553909248 total in 1268 blocks; 20432 free (6 > > chunks); 10553888816 used > > Well, that's definitely your problem ...
So I need to remove the foreign constraints? > > HashBatchContext: 415227952 total in 59 blocks; 6589744 > > free (5 chunks); 408638208 used > > although these numbers seem way outta line too. What did you say you > had work_mem set to? Initially on the first crash it was 256MB. I believe at the time of the crash I got the dump for it was down to 64MB or 8MB. I kept trying lower values. Also tried reducing shared_buffers as someone suggested. I will bump my shared_buffers back to 3GB and work_mem back to 64MB. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general