Postgres Pro
Downloads
Home   >   mailing lists

Re: Reducing memory usage of insert into select operations? - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: Reducing memory usage of insert into select operations?
Date
Msg-id 20080719112201.GA30331@svana.org
Whole thread Raw
In response to Re: Reducing memory usage of insert into select operations?  ("Francisco Reyes" <lists@stringsutils.com>)
Responses Re: Reducing memory usage of insert into select operations? [Solved]
List pgsql-general
Tree view 
On Fri, Jul 18, 2008 at 04:48:26PM -0400, Francisco Reyes wrote:
> 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 ...
>
> 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@svana.org>   http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you for flying nlogn airlines.
Attachment

pgsql-general by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Backup/Restore of single table in multi TB database
Next
From: Francisco Reyes
Date:
Subject: Re: Reducing memory usage of insert into select operations? [Solved]