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

From Tom Lane
Subject Re: Why would this use 600Meg of VM?
Date
Msg-id 9913.993359163@sss.pgh.pa.us
Whole thread Raw
In response to Why would this use 600Meg of VM?  (Larry Rosenman <ler@lerctr.org>)
Responses Re: Why would this use 600Meg of VM?  (Philip Warner <pjw@rhyme.com.au>)
List pgsql-hackers
Larry Rosenman <ler@lerctr.org> writes:
> Can one of you knowledgeable people tell me why current CVS as of 
> a week ago would have the backend running this query grow to 
> 600 meg+?

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.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Dave Cramer"
Date:
Subject: RE: Instrumenting and Logging in JDBC
Next
From: Philip Warner
Date:
Subject: Re: Why would this use 600Meg of VM?