Re: Support "Right Semi Join" plan shapes

Поиск
Список
Период
Сортировка
От Richard Guo
Тема Re: Support "Right Semi Join" plan shapes
Дата
Msg-id CAMbWs4_EodKyroqCW1fT=yuCPK9xvRgHkFCvHETPwNeZfg4pWw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Support "Right Semi Join" plan shapes  (Alena Rybakina <lena.ribackina@yandex.ru>)
Ответы Re: Support "Right Semi Join" plan shapes  (wenhui qiu <qiuwenhuifx@gmail.com>)
Re: Support "Right Semi Join" plan shapes  (Alena Rybakina <lena.ribackina@yandex.ru>)
Список pgsql-hackers

On Tue, Jan 30, 2024 at 2:51 PM Alena Rybakina <lena.ribackina@yandex.ru> wrote:
I have reviewed your patch and I think it is better to add an Assert for
JOIN_RIGHT_SEMI to the ExecMergeJoin and ExecNestLoop functions to
prevent the use of RIGHT_SEMI for these types of connections (NestedLoop
and MergeJoin).

Hmm, I don't see why this is necessary.  The planner should already
guarantee that we won't have nestloops/mergejoins with right-semi joins.

Thanks
Richard

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

Предыдущее
От: David Rowley
Дата:
Сообщение: Re: Add bump memory context type and use it for tuplesorts
Следующее
От: vignesh C
Дата:
Сообщение: Re: PostgreSQL Contributors Updates