Re: [8.0.0] out of memory on large UPDATE

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [8.0.0] out of memory on large UPDATE
Дата
Msg-id 12802.1123813378@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [8.0.0] out of memory on large UPDATE  ("Marc G. Fournier" <scrappy@postgresql.org>)
Ответы Re: [8.0.0] out of memory on large UPDATE  ("Marc G. Fournier" <scrappy@postgresql.org>)
Список pgsql-bugs
"Marc G. Fournier" <scrappy@postgresql.org> writes:
> 'k, does this help any?

> TopMemoryContext: 40960 total in 4 blocks; 8632 free (10 chunks); 32328 used
> SPI Plan: 3072 total in 2 blocks; 1728 free (0 chunks); 1344 used
> TopTransactionContext: 534765568 total in 74 blocks; 2144 free (68 chunks); 534763424 used

Yeah, the leak is clearly in TopTransactionContext.  That doesn't let
the trigger code off the hook though, because the pending-triggers list
is kept there.  Are you *sure* there are no AFTER triggers here?
(Don't forget foreign-key checking triggers.)

            regards, tom lane

В списке pgsql-bugs по дате отправления:

Предыдущее
От: "Marc G. Fournier"
Дата:
Сообщение: Re: [8.0.0] out of memory on large UPDATE
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: Cascading updates run seperately