Re: Support "Right Semi Join" plan shapes - Mailing list pgsql-hackers

From Alena Rybakina
Subject Re: Support "Right Semi Join" plan shapes
Date
Msg-id 689d20f8-b08d-4e7c-b554-f61492f22c98@yandex.ru
Whole thread Raw
In response to Re: Support "Right Semi Join" plan shapes  (Richard Guo <guofenglinux@gmail.com>)
Responses Re: Support "Right Semi Join" plan shapes
List pgsql-hackers

To be honest, I didn't see it in the code, could you tell me where they are, please?

On 05.03.2024 05:44, Richard Guo wrote:

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
-- 
Regards,
Alena Rybakina
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company

pgsql-hackers by date:

Previous
From: Matthias van de Meent
Date:
Subject: Re: Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements
Next
From: Thomas Munro
Date:
Subject: Re: processes stuck in shutdown following OOM/recovery