Re: Postgres eats up memory when using cursors

Peter Eisentraut <peter_e(at)gmx(dot)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