Re: group by points

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: group by points
Дата
Msg-id 15608.1148337515@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: group by points  (Bruno Wolff III <bruno@wolff.to>)
Ответы Re: group by points
Список pgsql-hackers
Bruno Wolff III <bruno@wolff.to> writes:
> On Mon, May 22, 2006 at 10:23:28 +0200,
>   Albe Laurenz <all@adv.magwien.gv.at> wrote:
>> In order to (efficiently) process a GROUP BY clause, you need a
>> total ordering on the data type that you group by, i.e. an ordering
>> such that for any two data x and y you have either x < y or x > x
>> or x = y.

> An equality operator is good enough if the number of unique groups isn't too
> large, so that a hash aggregate plan works efficiently.

Doesn't help for the case at hand, since point_eq isn't marked hashable
either.  It would be good to fix things so that the system doesn't
insist on having the sorting option available, though.
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: pgbench create index anomoly
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Porting MSSQL to PGSQL (Was: [OT] MySQL is bad, but THIS bad?)