Re: Hash grouping, aggregates

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Hash grouping, aggregates
Дата
Msg-id 25794.1044978113@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Hash grouping, aggregates  (Greg Stark <gsstark@mit.edu>)
Ответы Re: Hash grouping, aggregates  (Bruno Wolff III <bruno@wolff.to>)
Список pgsql-hackers
Greg Stark <gsstark@mit.edu> writes:
> So one of the items on the TODO list is "Add hash for evaluating GROUP BY
> aggregates (Tom)" 

It's done in CVS tip ... give it a try.

> The neat thing is that hash aggregates would allow grouping on data types that
> have = operators but no useful < operator.

Hm.  Right now I think that would barf on you, because the parser wants
to find the '<' operator to label the grouping column with, even if the
planner later decides not to use it.  It'd take some redesign of the
query data structure (specifically SortClause/GroupClause) to avoid that.
        regards, tom lane


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

Предыдущее
От: Greg Stark
Дата:
Сообщение: Re: Hash grouping, aggregates
Следующее
От: "Merlin Moncure"
Дата:
Сообщение: Re: [pgsql-advocacy] PostgreSQL Benchmarks