Re: Why would this use 600Meg of VM?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Why would this use 600Meg of VM?
Дата
Msg-id 9913.993359163@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Why would this use 600Meg of VM?  (Larry Rosenman <ler@lerctr.org>)
Ответы Re: Why would this use 600Meg of VM?  (Philip Warner <pjw@rhyme.com.au>)
Список 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 по дате отправления:

Предыдущее
От: "Dave Cramer"
Дата:
Сообщение: RE: Instrumenting and Logging in JDBC
Следующее
От: Philip Warner
Дата:
Сообщение: Re: Why would this use 600Meg of VM?