Re: group by points - Mailing list pgsql-hackers

From Bruno Wolff III
Subject Re: group by points
Date
Msg-id 20060522201031.GA20297@wolff.to
Whole thread Raw
In response to Re: group by points  ("Albe Laurenz" <all@adv.magwien.gv.at>)
Responses Re: group by points
List pgsql-hackers
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.


pgsql-hackers by date:

Previous
From: imacat
Date:
Subject: Re: Compiling PL/Perl and Pl/Python on x86_64
Next
From: Andrew Dunstan
Date:
Subject: Re: error-free disabling of individual child partition