Perform join removal by editing the query's jointree

Edit
ID 7059
Title Perform join removal by editing the query's jointree
CI (CFBot) Summary
Stats (from CFBot) Patch version: v2, Patch count: 3, First patch: +19−27, All patches: +754−1674
Tags Bugfix
Created 2026-07-25 17:01:43
Last modified 2026-07-25 17:01:44 (1 hour ago)
Latest email 2026-07-25 16:46:34 (1 hour 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-25 16:46:34 by Tom Lane <tgl at sss.pgh.pa.us>
Latest 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>
    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
Edit