On May 25, 2006 01:31 pm, "Merlin Moncure" <mmoncure(at)gmail(dot)com> wrote:
> > SELECT DISTINCT ON (a, b) a, b, c FROM t ORDER BY a DESC, b DESC, c
> > DESC;
>
> that is actually slower than group by in my case...am i missing
> something? (both essentially resolved to seq_scan)
Try it with an index on a,b,c.
--
Alan