Re: Why would this use 600Meg of VM? - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Why would this use 600Meg of VM?
Date
Msg-id 200106242108.f5OL8BY29055@candle.pha.pa.us
Whole thread Raw
In response to Re: Why would this use 600Meg of VM?  (Philip Warner <pjw@rhyme.com.au>)
List pgsql-hackers
> At 01:06 24/06/01 -0400, Tom Lane wrote:
> >
> >The answer: the query has nothing to do with it.  However, the
> >deferred triggers you have on the target relation have a lot to do
> >with it.  It's all deferred-trigger-event storage.
> 
> Would it be worth using a local (system) temporary table for this sort of
> thing?

Jan intially wanted to store large FK events in a file when they got too
big but never completed it.

The TODO list has:
* Add deferred trigger queue file (Jan)

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [PATCH] by request: base64 for bytea
Next
From: Bruce Momjian
Date:
Subject: Re: [COMMITTERS] pgsql/src/bin/initdb initdb.sh