Re: Remove inner joins based on foreign keys

Richard Guo <guofenglinux@gmail.com>

From: Richard Guo <guofenglinux@gmail.com>

To: Tender Wang <tndrwang@gmail.com>

Cc: Alexandra Wang <alexandra.wang.oss@gmail.com>, David Rowley <dgrowleyml@gmail.com>, Pg Hackers <pgsql-hackers@lists.postgresql.org>, Robert Haas <robertmhaas@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>, Paul A Jungwirth <pj@illuminatedcomputing.com>, Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>

Date: 2026-06-23T06:54:14Z

Lists: pgsql-hackers

Attachments

v6-0001-Remove-inner-joins-based-on-foreign-keys.patch (application/octet-stream) patch v6-0001
v6-0002-Suppress-FK-based-inner-join-removal-during-the-t.patch (application/octet-stream) patch v6-0002

On Mon, Jun 22, 2026 at 7:42 PM Tender Wang <tndrwang@gmail.com> wrote:
> Richard Guo <guofenglinux@gmail.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

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Strip removed-relation references from PlaceHolderVars at join removal
- 9a60f295bcb1 19 (unreleased) cited
Fix LATERAL references in GRAPH_TABLE with multi-label pattern
- 4cb2a9863d89 19 (unreleased) cited