Re: Postgres eats up memory when using cursors

Поиск
Список
Период
Сортировка
От Denis Perchine
Тема Re: Postgres eats up memory when using cursors
Дата
Msg-id 01030201123309.00608@dyp.perchine.com
обсуждение исходный текст
Ответ на Re: Postgres eats up memory when using cursors  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: "Peter T. Brown"
Дата:
Сообщение: restore from base
Следующее
От: "Paulo Parola"
Дата:
Сообщение: libpq.so.2.1 needed by php-pgsql-4.0.1pl2-9