Re: Why would this use 600Meg of VM?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Larry Rosenman <ler(at)lerctr(dot)org>
Cc: PostgreSQL Hackers List <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Why would this use 600Meg of VM?
Date: 2001-06-24 05:06:03
Message-ID: 9913.993359163@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Larry Rosenman <ler(at)lerctr(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Philip Warner 2001-06-24 05:45:52 Re: Why would this use 600Meg of VM?
Previous Message Philip Warner 2001-06-24 03:47:58 Re: Setuid functions