Re: BUG #6061: Progresql.exe memory usage using HOLD cursor.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #6061: Progresql.exe memory usage using HOLD cursor.
Дата
Msg-id 12398.1308156201@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #6061: Progresql.exe memory usage using HOLD cursor.  ("Yann" <yann.delorme@esker.fr>)
Ответы Re: BUG #6061: Progresql.exe memory usage using HOLD cursor.  ("Delorme, Yann" <Yann.Delorme@esker.fr>)
Список pgsql-bugs
"Yann" <yann.delorme@esker.fr> writes:
> The issue is that in this case all rows are store in memory instead of file
> in the process postgresql.exe

> I think the issue is in the file tuplestore.c.
> When a tuple is added the function static void
> tuplestore_puttuple_common(Tuplestorestate *state, void *tuple), USEMEM is
> not called with tuple size.

Hmm ... yeah, I think there's a leak there.

> I think that, after adding the tuple in the array, a call to USEMEM should
> be done.

No, the callers of tuplestore_puttuple_common are supposed to do that.
But it looks like tuplestore_putvalues() forgot to do so.  So data loads
that go through that particular API would miss incrementing the space
counter.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #6060: does not work -z option of pg_basebackup
Следующее
От: "Sebastian"
Дата:
Сообщение: BUG #6062: psql terminates on auto-complete