Re: Postgres eats up memory when using cursors

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Postgres eats up memory when using cursors
Дата
Msg-id 21844.983471542@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Postgres eats up memory when using cursors  (Peter Eisentraut <peter_e@gmx.net>)
Ответы Re: Postgres eats up memory when using cursors
Список pgsql-general
Peter Eisentraut <peter_e@gmx.net> writes:
> Tom Lane writes:
>> Repeating these like mad, psql grows about 1Kb/sec on my machine.
>> This occurs with current sources but NOT with 7.0.2 psql.  Peter,
>> any thoughts about that?

> Well, here's a memory leak:

Good catch.  I confirm this stops the leak in my test.

> This leaks (columns + 1) per query, 4 bytes in your case.  But is has been
> there in 7.0 as well.

Ooops, my bad --- repeating my test shows process growth in 7.0 as well.
I had missed it the first time because I'd previously done a plain
"select *", which ballooned the process footprint of psql.  So the
leakage was happening within previously-grabbed memory and wasn't
obvious in "top".

This doesn't seem to actually be related to Denis' problem, but a
leak is a leak ...

            regards, tom lane

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

Предыдущее
От: Scott Holmes
Дата:
Сообщение: Users in pg_shadow
Следующее
От: Denis Perchine
Дата:
Сообщение: Re: Postgres eats up memory when using cursors