Perform join removal by editing the query's jointree

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch version: v5, Patch count: 1, First patch: +922−1673, All patches: +922−1673

Tags

Bugfix

Created

2026-07-25 17:01:43

Last modified

2026-07-25 17:01:44 (2 weeks ago)

Latest email

2026-07-29 06:21:18 (2 weeks ago)

Status

PG20-2 (2026-09-01 – 2026-09-30): Needs review

Target version

Authors

Tom Lane (tgl)

Reviewers

Become reviewer

Committer

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-07-29 06:21:18 by Richard Guo <guofenglinux at gmail.com>
Latest 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>
    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-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