Re: DISTINCT vs. GROUP BY - Mailing list pgsql-hackers

From Tom Lane
Subject Re: DISTINCT vs. GROUP BY
Date
Msg-id 27382.1127142552@sss.pgh.pa.us
Whole thread Raw
In response to DISTINCT vs. GROUP BY  (Hans-Jürgen Schönig <postgres@cybertec.at>)
List pgsql-hackers
Hans-Jürgen Schönig <postgres@cybertec.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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Start translating
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Per-table freeze limit proposal