| From: | Nicolas Adenis-Lamarre <nicolas(dot)adenis(dot)lamarre(at)gmail(dot)com> |
|---|---|
| To: | pgsql-hackers(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Planner : anti-join on left joins |
| Date: | 2026-01-02 09:19:01 |
| Message-ID: | CACPGbcvqjQfd-QC3mqD=SMeNX-iEvS-sirpX=RptOxy1Y8Wr3A@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| Attachment | Content-Type | Size |
|---|---|---|
| 0001-Reduce-JOIN_LEFT-TO-JOIN_ANTI.patch | text/x-patch | 4.4 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrey Borodin | 2026-01-02 09:25:10 | Re: CREATE TABLE LIKE INCLUDING TRIGGERS |
| Previous Message | Xuneng Zhou | 2026-01-02 09:17:34 | Re: Implement waiting for wal lsn replay: reloaded |