| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Francisco Reyes <lists(at)stringsutils(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, 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-19 11:22:01 |
| Message-ID: | 20080719112201.GA30331@svana.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Jul 18, 2008 at 04:48:26PM -0400, Francisco Reyes wrote:
> 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 ...
>
> What is the overhead for each AfterTriggerEvent?
Can you make them not deferred? Then you don't need the memory either.
Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you for flying nlogn airlines.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Francisco Reyes | 2008-07-19 13:12:00 | Re: Reducing memory usage of insert into select operations? [Solved] |
| Previous Message | Simon Riggs | 2008-07-19 09:02:32 | Re: Backup/Restore of single table in multi TB database |