Re: 9.5: Memory-bounded HashAgg

Поиск
Список
Период
Сортировка
От Jeff Davis
Тема Re: 9.5: Memory-bounded HashAgg
Дата
Msg-id 1408030764.2335.111.camel@jeff-desktop
обсуждение исходный текст
Ответ на Re: 9.5: Memory-bounded HashAgg  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: 9.5: Memory-bounded HashAgg  (Atri Sharma <atri.jiit@gmail.com>)
Re: 9.5: Memory-bounded HashAgg  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Thu, 2014-08-14 at 10:06 -0400, Tom Lane wrote:
> If you're following the HashJoin model, then what you do is the same thing
> it does: you write the input tuple back out to the pending batch file for
> the hash partition that now contains key 1001, whence it will be processed
> when you get to that partition.  I don't see that there's any special case
> here.

HashJoin only deals with tuples. With HashAgg, you have to deal with a
mix of tuples and partially-computed aggregate state values. Not
impossible, but it is a little more awkward than HashJoin.

Regards,Jeff Davis





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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: jsonb format is pessimal for toast compression
Следующее
От: Atri Sharma
Дата:
Сообщение: Re: 9.5: Memory-bounded HashAgg