Re: plpgsql function seems to be leaking memory

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: plpgsql function seems to be leaking memory
Дата
Msg-id 16759.1214319370@sss.pgh.pa.us
обсуждение исходный текст
Ответ на plpgsql function seems to be leaking memory  (Marc Cousin <mcousin@sigma.fr>)
Ответы Re: plpgsql function seems to be leaking memory  (Marc Cousin <mcousin@sigma.fr>)
Re: plpgsql function seems to be leaking memory  (Guillaume Lelarge <guillaume@lelarge.info>)
Список pgsql-admin
Marc Cousin <mcousin@sigma.fr> writes:
> I'm having a problem with plpgsql functions leaking memory.

Your example shows absolutely no memory leak here, in either 8.3.3
or CVS HEAD.

> I see the postgresql process growing from 8MB to about 400 MB during this
> run...

What do you have shared_buffers set to?  I think you might be getting
fooled by top's treatment of shared memory (ie, it starts to count
shared pages after the process touches them for the first time).

            regards, tom lane

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

Предыдущее
От: "C K"
Дата:
Сообщение: Functions
Следующее
От: Marc Cousin
Дата:
Сообщение: Re: plpgsql function seems to be leaking memory