On 3:55 pm 07/18/08 Tom Lane <tgl@sss.pgh.pa.us> 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.