Horton

Re: Support "Right Semi Join" plan shapes

Alena Rybakina <lena.ribackina@yandex.ru>

View thread
From: Alena Rybakina <lena.ribackina@yandex.ru>
To: Richard Guo <guofenglinux@gmail.com>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>, wenhui qiu <qiuwenhuifx@gmail.com>, vignesh C <vignesh21@gmail.com>
Date: 2024-03-05T20:10:00Z
Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Support "Right Semi Join" plan shapes

  2. Fix neqjoinsel's behavior for semi/anti join cases.

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