Re: Optimizing DISTINCT with LIMIT - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Optimizing DISTINCT with LIMIT
Date
Msg-id 27036.1228753575@sss.pgh.pa.us
Whole thread Raw
In response to Re: Optimizing DISTINCT with LIMIT  (Gregory Stark <stark@enterprisedb.com>)
List pgsql-hackers
Gregory Stark <stark@enterprisedb.com> writes:
> But I can also see Tom's reluctance. It's a fair increase in the amount of
> code to maintain in that file for a pretty narrow use case. On the other hand
> it looks like it would be all in that file. The planner wouldn't have to do
> anything special to set it up which is nice.

No, the planner would have to be changed to be aware of the behavioral
difference.  Otherwise it might pick some other plan besides the one
that has the performance advantage.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Simple postgresql.conf wizard
Next
From: Tom Lane
Date:
Subject: Re: benchmarking the query planner (was Re: Simple postgresql.conf wizard)