Re: DISTINCT vs. GROUP BY

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Hans-Jürgen Schönig <postgres(at)cybertec(dot)at>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: DISTINCT vs. GROUP BY
Date: 2005-09-19 15:09:12
Message-ID: 27382.1127142552@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

=?ISO-8859-1?Q?Hans-J=FCrgen_Sch=F6nig?= <postgres(at)cybertec(dot)at> writes:
> I was wondering whether it is possible to teach the planner to handle
> DISTINCT in a more efficient way:

Probably (although the interactions with ORDER BY might be tricky).
No one has touched that part of the planner in a very long time.

regards, tom lane

Browse pgsql-hackers by date

  From Date Subject
Next Message Magnus Hagander 2005-09-19 15:12:14 Re: Beta2 Wrap Up ...
Previous Message Jim C. Nasby 2005-09-19 15:05:16 Re: Per-table freeze limit proposal