| From: | Tender Wang <tndrwang(at)gmail(dot)com> |
|---|---|
| To: | Nicolas Adenis-Lamarre <nicolas(dot)adenis(dot)lamarre(at)gmail(dot)com> |
| Cc: | pgsql-hackers(at)lists(dot)postgresql(dot)org, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Subject: | Re: Planner : anti-join on left joins |
| Date: | 2026-01-05 10:59:12 |
| Message-ID: | CAHewXNmi83wQqHTcHNX9X2xOHj5N1OuZgocZ1BgXt1CULpHzWg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi,
Nicolas Adenis-Lamarre <nicolas(dot)adenis(dot)lamarre(at)gmail(dot)com> 于2026年1月2日周五
17:19写道：
> Tender,
>
> not sure you see one suggestion i did.
> just in case you think it may be interesting, i modified for you 0001.
>
> it just add (and reindent) ' if(forced_null_vars != NIL) ' around the
> optimisation while most of left join have probably no forced nulls,
> and thus it avoids to compute find_nonnullable_vars and
> have_var_is_notnull for them.
>
> Nicolas
>
Yeah, I forgot to add your suggestion. Please check the v4 patch.
I combined the code and tests into one patch and also added it to [1]
commitfest.
[1] https://commitfest.postgresql.org/patch/6375/
--
Thanks,
Tender Wang
| Attachment | Content-Type | Size |
|---|---|---|
| v4-0001-Reduce-JOIN_LEFT-TO-JOIN_ANTI.patch | application/octet-stream | 7.6 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tender Wang | 2026-01-05 11:06:13 | Re: Add SPLIT PARTITION/MERGE PARTITIONS commands |
| Previous Message | Mario González Troncoso | 2026-01-05 10:56:23 | Re: [PATCH} Move instrumentation structs |