Re: Remove inner joins based on foreign keys

From: Richard Guo <guofenglinux(at)gmail(dot)com>
To: Tender Wang <tndrwang(at)gmail(dot)com>
Cc: Alexandra Wang <alexandra(dot)wang(dot)oss(at)gmail(dot)com>, David Rowley <dgrowleyml(at)gmail(dot)com>, Pg Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Robert Haas <robertmhaas(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Paul A Jungwirth <pj(at)illuminatedcomputing(dot)com>, Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>
Subject: Re: Remove inner joins based on foreign keys
Date: 2026-06-23 06:54:14
Message-ID: CAMbWs4_txToqETeJ3-5k0qx61tf=t6mAQe3NKu4RGNcJ8G7_wA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Jun 22, 2026 at 7:42 PM Tender Wang <tndrwang(at)gmail(dot)com> wrote:
> Richard Guo <guofenglinux(at)gmail(dot)com> 于2026年5月26日周二 05:01写道:
> > (Attached v5 is the split version of v4, plus addressing Alex's two
> > comments. 0002 is still the lock-based predicate from v4, posted as
> > the concrete reference for option (B); it can be swapped for whichever
> > approach the gap-handling discussion settles on.)

> (The patches need to be rebased due to commit 9a60f295bcb18)

Right. Here is the rebase.

- Richard

Attachment Content-Type Size
v6-0001-Remove-inner-joins-based-on-foreign-keys.patch application/octet-stream 69.3 KB
v6-0002-Suppress-FK-based-inner-join-removal-during-the-t.patch application/octet-stream 14.4 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Richard Guo 2026-06-23 07:14:40 Re: [PATCH v1] PL/Perl: Fix NULL deref for forged array
Previous Message Xing Guo 2026-06-23 06:46:44 [PATCH v1] PL/Perl: Fix NULL deref for forged array