Re: Out-of-Memory with ROWTYPE assignment in PL/pgSQL FOR loop

Поиск
Список
Период
Сортировка
От Bill Rugolsky Jr.
Тема Re: Out-of-Memory with ROWTYPE assignment in PL/pgSQL FOR loop
Дата
Msg-id 20050621013323.GA13781@ti64.telemetry-investments.com
обсуждение исходный текст
Ответ на Re: Out-of-Memory with ROWTYPE assignment in PL/pgSQL FOR loop  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
On Mon, Jun 20, 2005 at 06:54:20PM -0400, Tom Lane wrote:
> "Bill Rugolsky Jr." <brugolsky@telemetry-investments.com> writes:
> > The PL/pgSQL FOR loop in the function consume_memory() defined below
> > will consume VM on each iteration until the process hits its ulimit.
> > The problem occurs with variables of ROWTYPE; there is no unbounded
> > allocation when using simple types such as integer or varchar.
>
> Yeah, looks like I introduced a memory leak with the 8.0 changes for
> better support of rowtype variables :-(.  Here's the patch.

Thank you for the quick reply; much appreciated!
Applied and tested against CVS head; that plugged the leak.

    -Bill

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Out-of-Memory with ROWTYPE assignment in PL/pgSQL FOR loop
Следующее
От: "Robson Elias Reuter"
Дата:
Сообщение: BUG #1724: Problemas com acentos