Re: Optimizing DISTINCT with LIMIT

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Optimizing DISTINCT with LIMIT
Дата
Msg-id 27036.1228753575@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Optimizing DISTINCT with LIMIT  (Gregory Stark <stark@enterprisedb.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Simple postgresql.conf wizard
Следующее
От: Tom Lane
Дата:
Сообщение: Re: benchmarking the query planner (was Re: Simple postgresql.conf wizard)