Re: BUG #15592: Memory overuse with subquery containing unnest() and set operations (11.x regression)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #15592: Memory overuse with subquery containing unnest() and set operations (11.x regression)
Дата
Msg-id 24396.1549732748@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: BUG #15592: Memory overuse with subquery containing unnest() andset operations (11.x regression)  (Andres Freund <andres@anarazel.de>)
Список pgsql-bugs
Andres Freund <andres@anarazel.de> writes:
> On 2019-02-09 10:09:57 -0500, Tom Lane wrote:
>> What is it you're actually hoping to do by removing this guarantee?

> I think we probably can do better in master, but I don't see a good
> solution that's not expensive in v11. The tuple hash table can be
> created / destroyed at a prodigious rate before 317ffdfea / 356687bd825,
> and I don't see a good way to get rid of needing an ExprContext created
> therein. We could register a callback on the memory context to drop the
> ExprContext, but unfortunately dropping ExprContexts retail isn't
> particularly cheap as it has to go through a singly linked list
> (something we ought to fix one day by using a doubly linked list, but
> certainly not a minor release).

Why not?  I think converting that list into a dlist might be a perfectly
reasonable thing to do.  Certainly there are ABI considerations in the
back branches, but we could probably dodge those adequately with the
usual hack of putting the added field at the end.

            regards, tom lane


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

Предыдущее
От: Amit Langote
Дата:
Сообщение: Re: BUG #15623: Inconsistent use of default for updatable view
Следующее
От: PG Bug reporting form
Дата:
Сообщение: BUG #15625: 10.6.1 Can't Find hstore.