Re: Some revises in adding sorting path

Поиск
Список
Период
Сортировка
От Richard Guo
Тема Re: Some revises in adding sorting path
Дата
Msg-id CAMbWs48aQnD3xw8eciJO=i90XwJ9KC2sNfNearoPh5H3PvXUog@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Some revises in adding sorting path  (Etsuro Fujita <etsuro.fujita@gmail.com>)
Список pgsql-hackers

On Thu, Feb 16, 2023 at 7:50 PM Etsuro Fujita <etsuro.fujita@gmail.com> wrote:
I'm not sure this is a good idea, because the epq_path will return at
most one tuple in an EPQ recheck.

The reason why an extra Sort node is injected into the epq_path is
only label it with the correct sort order to use it as an input for
the EPQ merge-join path of a higher-level foreign join, so shouldn't
we keep this step as much as simple and save cycles even a little?
 
Agreed.  Thanks for the explanation.  I also wondered whether it's
worthwhile to do the change here.  I'll remove the 0001 patch.

Thanks
Richard

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

Предыдущее
От: "Hayato Kuroda (Fujitsu)"
Дата:
Сообщение: RE: Time delayed LR (WAS Re: logical replication restrictions)
Следующее
От: Richard Guo
Дата:
Сообщение: Re: Some revises in adding sorting path