Re: Postgres eats up memory when using cursors - Mailing list pgsql-general

From Denis Perchine
Subject Re: Postgres eats up memory when using cursors
Date
Msg-id 01030201123309.00608@dyp.perchine.com
Whole thread Raw
In response to Re: Postgres eats up memory when using cursors  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
> >> 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@perchine.com
HomePage: http://www.perchine.com/dyp/
FidoNet: 2:5000/120.5
----------------------------------

pgsql-general by date:

Previous
From: "Peter T. Brown"
Date:
Subject: restore from base
Next
From: "Paulo Parola"
Date:
Subject: libpq.so.2.1 needed by php-pgsql-4.0.1pl2-9