| From: | Richard Guo <guofenglinux(at)gmail(dot)com> |
|---|---|
| To: | Pg Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Convert NOT IN sublinks to anti-joins when safe |
| Date: | 2026-03-04 09:52:07 |
| Message-ID: | CAMbWs4_g4+Vc1oKgoTMfo=sEw5h4seMQyC5m1Wx23Kpy21gvHg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Sat, Feb 14, 2026 at 4:37 PM Richard Guo <guofenglinux(at)gmail(dot)com> wrote:
> On Thu, Feb 5, 2026 at 3:51 PM Richard Guo <guofenglinux(at)gmail(dot)com> wrote:
> > Attached is the updated patch, which adds the check requiring the
> > operator to be a member of a btree or hash opfamily.
> Attached is another updated patch rebased on current master, with the
> addition of support for RowCompareExpr to handle multi-column ordering
> operations; otherwise unchanged.
Attached is another updated patch rebased on current master, with some
minor cosmetic adjustments; nothing essential has changed.
- Richard
| Attachment | Content-Type | Size |
|---|---|---|
| v4-0001-Convert-NOT-IN-sublinks-to-anti-joins-when-safe.patch | application/octet-stream | 61.4 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nitin Motiani | 2026-03-04 09:57:14 | Re: Adding pg_dump flag for parallel export to pipes |
| Previous Message | Jakub Wartak | 2026-03-04 09:50:40 | Re: pg_plan_advice (now with transparent SQL plan performance overrides - pg_stash_advice) |