Re: [GENERAL] Memory Errors...

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [GENERAL] Memory Errors...
Дата
Msg-id 26631.1032452336@sss.pgh.pa.us
обсуждение исходный текст
Ответы Re: [GENERAL] Memory Errors...  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: [GENERAL] Memory Errors...  ("Nigel J. Andrews" <nandrews@investsystems.co.uk>)
Список pgsql-hackers
"Ian Harding" <ianh@tpchd.org> writes:
> It is pltcl [not plpgsql]

Ah.  I don't think we've done much of any work on plugging leaks in
pltcl :-(.

> It hurts when I do this:

> drop function memleak();
> create function memleak() returns int as '
> for {set counter 1} {$counter < 100000} {incr counter} {
>         set sql "select ''foo''"
>         spi_exec "$sql"
> }
> ' language 'pltcl';
> select memleak();

Yeah, I see very quick memory exhaustion also :-(.  Looks like the
spi_exec call is the culprit, but I'm not sure exactly why ...
anyone have time to look at this?
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [GENERAL] killing process question
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Proposal for resolving casting issues