RE: Re: Spilling hashed SetOps and aggregates to disk

Поиск
Список
Период
Сортировка
От serge@rielau.com
Тема RE: Re: Spilling hashed SetOps and aggregates to disk
Дата
Msg-id 20180605064145.9cf3801d03770ada01bb39dc8f52321d.e7845a4b75.mailapi@email18.godaddy.com
обсуждение исходный текст
Ответ на Re: Spilling hashed SetOps and aggregates to disk  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Ответы Re: Spilling hashed SetOps and aggregates to disk  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Список pgsql-hackers
In our code base we have added a WithStats-Flavor for creating memory contexts.
This api accepts a pointer to metric for accounting and it is inherited by all subcontexts unless overridden.
So we only needed to change context creation API where we wanted (such as TopTansactionContext, Message Context, ..)
That's quite trivial, actually.
 
Also we have fixed all those missing hash spills - albeit based on the 9.6 hash table design I think.
 
If there is interest by the community we are very willing to share.
 
Cheers
Serge
Salesforce

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

Предыдущее
От: Ashutosh Bapat
Дата:
Сообщение: Re: why partition pruning doesn't work?
Следующее
От: Alexander Korotkov
Дата:
Сообщение: Locking B-tree leafs immediately in exclusive mode