Re: Reducing memory usage of insert into select operations?

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:48:26
Message-ID: 85719b70d883fe18de02893557d24495@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 ...

What is the overhead for each AfterTriggerEvent?

I guess I can write a program to process so many rows at a time, if I know
how much overhead each AfterTriggerEvent uses. I know 15 million at a time
worked fine, so I could do 5 or 10 million at a time.

When does the memory usage for those AfterTriggerEvents gets released? At
commit?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-07-18 20:55:12 Re: Reducing memory usage of insert into select operations?
Previous Message user 2008-07-18 20:45:14 Calling Python functions with parameters