Re: Reducing memory usage of insert into select operations?

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.