Re: Postgres eats up memory when using cursors

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Postgres eats up memory when using cursors
Дата
Msg-id 22051.983473625@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Postgres eats up memory when using cursors  (Denis Perchine <dyp@perchine.com>)
Ответы Re: Postgres eats up memory when using cursors
Список pgsql-general
Denis Perchine <dyp@perchine.com> writes:
>> 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?  Could you experiment and see if you can devise a
complete example?  I'm kinda busy right now looking at WAL...

            regards, tom lane

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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: Users in pg_shadow
Следующее
От: "Peter T. Brown"
Дата:
Сообщение: restore from base