| From: | "Francisco Reyes" <lists(at)stringsutils(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | <alvherre(at)commandprompt(dot)com>, <dev(at)archonet(dot)com>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Reducing memory usage of insert into select operations? |
| Date: | 2008-07-18 20:16:42 |
| Message-ID: | d0f1c83146388a4b52201c5ac5b439b0@stringsutils.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 3:55 pm 07/18/08 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Raymond O'Donnell | 2008-07-18 20:38:05 | Re: Writing a user defined function |
| Previous Message | Tom Lane | 2008-07-18 19:55:58 | Re: Reducing memory usage of insert into select operations? |