| From: | wenhui qiu <qiuwenhuifx(at)gmail(dot)com> |
|---|---|
| To: | Richard Guo <guofenglinux(at)gmail(dot)com> |
| Cc: | Alena Rybakina <lena(dot)ribackina(at)yandex(dot)ru>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, vignesh C <vignesh21(at)gmail(dot)com> |
| Subject: | Re: Support "Right Semi Join" plan shapes |
| Date: | 2024-03-05 03:05:46 |
| Message-ID: | CAGjGUA+iPkks3NDPwfYc2zXdgkwKifnwrd5SDOsiEw+hM6whgA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi Richard
Agree +1 ,I think can push now.
Richard
On Tue, 5 Mar 2024 at 10:44, Richard Guo <guofenglinux(at)gmail(dot)com> wrote:
>
> On Tue, Jan 30, 2024 at 2:51 PM Alena Rybakina <lena(dot)ribackina(at)yandex(dot)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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | vignesh C | 2024-03-05 03:20:38 | Re: Improve eviction algorithm in ReorderBuffer |
| Previous Message | vignesh C | 2024-03-05 02:50:47 | Re: PostgreSQL Contributors Updates |