Re: Postgres eats up memory when using cursors

> >> This doesn't seem to actually be related to Denis' problem, but a
> >> leak is a leak ...
> >
> > Is this is the same leak? I mean I do not use psql in any mean...
>
> It isn't.
>
> I'm now suspecting that your problem must be related to doing inserts
> while a cursor is held open. Are the inserts done by the same backend,
> or a different one?

By different ones. This backend just do fetches.

> Could you experiment and see if you can devise a complete example? I'm
> kinda busy right now looking at WAL...

Inserts are the only operations done besides fetching. This is a complete
example. There are no other actions are taken on this table. Only inserts
made by other backend, and fetches trough only on cursor. I mean that this is
the only backend doing fetches.

--
Sincerely Yours,
Denis Perchine

----------------------------------
E-Mail: dyp(at)perchine(dot)com
HomePage: http://www.perchine.com/dyp/
FidoNet: 2:5000/120.5
----------------------------------