Re: GROUP BY vs DISTINCT

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Peter Childs" <peterachilds(at)gmail(dot)com>
Cc: "Postgresql Performance" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: GROUP BY vs DISTINCT
Date: 2006-12-20 15:36:38
Message-ID: 22279.1166628998@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"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

Browse pgsql-performance by date

  From Date Subject
Next Message Michal Taborsky - Internet Mall 2006-12-20 15:50:03 Re: Question: Clustering & Load Balancing
Previous Message CARMODA 2006-12-20 11:25:42 Question: Clustering & Load Balancing