"Peter Childs" <peterachilds(at)gmail(dot)com> writes:
> Is it actually in the sql spec to sort in a distinct
No. PG's code that supports GROUP BY is newer and smarter than the code
that supports DISTINCT, is all. One of the things on the to-do list is
to revise DISTINCT so it can also consider hash-based implementations.
The hard part of that is not to break DISTINCT ON ...
regards, tom lane
In response to
pgsql-performance by date
|Next:||From: Michal Taborsky - Internet Mall||Date: 2006-12-20 15:50:03|
|Subject: Re: Question: Clustering & Load Balancing|
|Previous:||From: CARMODA||Date: 2006-12-20 11:25:42|
|Subject: Question: Clustering & Load Balancing |