Re: Memory-Bounded Hash Aggregation

Поиск
Список
Период
Сортировка
От Adam Lee
Тема Re: Memory-Bounded Hash Aggregation
Дата
Msg-id 20200220040437.GA4389@earth.local
обсуждение исходный текст
Ответ на Re: Memory-Bounded Hash Aggregation  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Список pgsql-hackers
On Wed, Feb 19, 2020 at 08:16:36PM +0100, Tomas Vondra wrote:
> 4) lookup_hash_entries says
> 
>   /* check to see if we need to spill the tuple for this grouping set */
> 
> But that seems bogus, because AFAIK we can't spill tuples for grouping
> sets. So maybe this should say just "grouping"?

As I see it, it does traverse all hash sets, fill the hash table and
spill if needed, for each tuple.

The segfault is probably related to this and MixedAggregate, I'm looking
into it.

-- 
Adam Lee



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

Предыдущее
От: Thomas Munro
Дата:
Сообщение: Experimenting with transactional memory for SERIALIZABLE
Следующее
От: Andres Freund
Дата:
Сообщение: Re: Improve heavyweight locks instead of building new lock managers?