Perform join removal by editing the query's jointree

Edit

ID

Title

Perform join removal by editing the query's jointree

CI (CFBot)

Summary

Stats (from CFBot)

Patch version: v6, Patch count: 2, First patch: +922−1673, All patches: +978−1671

Tags

Bugfix

Created

2026-07-25 17:01:43

Last modified

2026-08-28 19:13:34 (1 week ago)

Latest email

2026-09-03 14:55:05 (2 days ago)

Status

PG20-2 (2026-09-01 – 2026-09-30): Committed

Target version

Authors

Tom Lane (tgl)

Reviewers

Become reviewer

Committer

Tom Lane (tgl)

Links

Emails

remove_useless_joins vs. bug #19560: First at 2026-07-20 18:52:24 by Tom Lane <tgl at sss.pgh.pa.us>
Latest at 2026-09-03 14:55:05 by Tom Lane <tgl at sss.pgh.pa.us>
Latest attachment (v2-0001-Remove-quals-made-redundant-by-reducing-outer-joi.patch) at 2026-09-01 02:07:55 from Richard Guo <guofenglinux at gmail.com>
    Attachment (v2-0001-Remove-quals-made-redundant-by-reducing-outer-joi.patch) at 2026-09-01 02:07:55 from Richard Guo <guofenglinux at gmail.com> (Patch: No)
    Attachment (v1-0001-Remove-quals-made-redundant-by-reducing-outer-joi.patch) at 2026-08-31 07:32:02 from Richard Guo <guofenglinux at gmail.com> (Patch: No)
    Attachment (skip-outer-level-PHVs.patch) at 2026-08-30 16:20:41 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (v2-0001-Fix-stale-copies-of-PHVs-in-LATERAL-subqueries.patch) at 2026-08-30 06:50:20 from Richard Guo <guofenglinux at gmail.com> (Patch: No)
    Attachment (put-back-preprocessed-PHV.patch) at 2026-08-29 20:10:45 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (nocfbot.delta-v6.patch) at 2026-08-27 05:46:18 from Richard Guo <guofenglinux at gmail.com> (Patch: Yes)
    Attachment (nocfbot.delta-v6.patch) at 2026-08-27 01:57:59 from Richard Guo <guofenglinux at gmail.com> (Patch: Yes)
    Attachment (v6-0001-Perform-join-removal-by-editing-the-query-s-joint.patch) at 2026-08-26 17:25:12 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: No)
    Attachment (nocfbot.Some-updates-to-v5.patch) at 2026-08-26 05:26:42 from Richard Guo <guofenglinux at gmail.com> (Patch: No)
    Attachment (v5-join-removal-per-branch-patches.tar.gz) at 2026-07-27 18:21:12 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: No)
    Attachment (benchmark.tar.gz) at 2026-07-26 20:34:43 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: No)
    Attachment (v4-0001-Postpone-initialization-of-all_result_relids-leaf.patch) at 2026-07-26 17:35:14 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: No)
    Attachment (finding-81-queries.sql) at 2026-07-26 04:23:00 from Jacob Brazeal <jacob.brazeal at gmail.com> (Patch: No)
    Attachment (v3-0001-Postpone-initialization-of-all_result_relids-leaf.patch) at 2026-07-26 02:15:28 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: No)
    Attachment (v2-0001-Postpone-initialization-of-all_result_relids-leaf.patch) at 2026-07-25 16:46:34 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: No)
    Attachment (v1-0001-wip-refactor-join-removal.patch) at 2026-07-24 13:38:05 from Richard Guo <guofenglinux at gmail.com> (Patch: No)

History

When	Who	What
2026-08-28 19:13:34	Tom Lane (tgl)	Closed in commitfest PG20-2 with status: Committed
2026-08-28 19:13:34	Tom Lane (tgl)	Changed committer to tgl
2026-07-25 17:01:44	Tom Lane (tgl)	Attached mail thread 1186816.1784573544@sss.pgh.pa.us
2026-07-25 17:01:43	Tom Lane (tgl)	Created patch record

Edit