Re: Allow DISTINCT to use Incremental Sort

Поиск
Список
Период
Сортировка
От David Rowley
Тема Re: Allow DISTINCT to use Incremental Sort
Дата
Msg-id CAApHDvpJZtouyh-sF=xtmNCjj683RQPJ=rZataYJzo6V7UMm1Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Allow DISTINCT to use Incremental Sort  (Richard Guo <guofenglinux@gmail.com>)
Список pgsql-hackers
On Tue, 10 Jan 2023 at 16:07, Richard Guo <guofenglinux@gmail.com> wrote:
> Sorry I didn't make myself clear.  I mean currently on HEAD in planner.c
> from line 4847 to line 4857, we have the code to make sure we always use
> the more rigorous clause for explicit-sort case.  I think this code is
> not necessary, because we have already done that in line 4791 to 4796,
> for both DISTINCT ON and standard DISTINCT.

Thanks for explaining.  I'm unsure if that code ever did anything
useful, but I agree that it does nothing now.

>> I've attached an updated patch
>
>
> The patch looks good to me.

Thanks for having another look. I've now pushed the patch.

David



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Jeff Davis
Дата:
Сообщение: Re: allowing for control over SET ROLE
Следующее
От: sirisha chamarthi
Дата:
Сообщение: Wasted Vacuum cycles when OldestXmin is not moving