starjoin join order planning

Edit
ID 5553
Title starjoin join order planning
CI (CFBot) Summary
Stats (from CFBot) Patch version: v5, Patch count: 2, First patch: +710−3, All patches: +794−3
Tags Performance
Created 2025-02-06 22:05:22
Last modified 2025-11-12 15:52:33 (4 months ago)
Latest email 2025-11-29 14:18:49 (4 months ago)
Status
PG19-3 (2025-11-01 – 2025-11-30): Needs review
PG19-2 (2025-09-01 – 2025-09-30): Moved to different CF
2025-03 (2025-03-01 – 2025-04-08): Moved to different CF
Target version
Authors Tomas Vondra (fuzzycz)
Reviewers Become reviewer
Committer
Links
Emails
should we have a fast-path planning for OLTP starjoins?
First at 2025-02-04 14:00:49 by Tomas Vondra <tomas at vondra.me>
Latest at 2025-11-29 14:18:49 by Robert Haas <robertmhaas at gmail.com>
Latest attachment (v5-0002-Allow-dimensions-with-some-join-restrictions.patch) at 2025-11-12 15:39:50 from Tomas Vondra <tomas at vondra.me>
    Attachment (v5-0002-Allow-dimensions-with-some-join-restrictions.patch) at 2025-11-12 15:39:50 from Tomas Vondra <tomas at vondra.me> (Patch: Yes)
    Attachment (v4-0001-Simplify-planning-of-starjoin-queries.patch) at 2025-11-08 20:14:54 from Tomas Vondra <tomas at vondra.me> (Patch: Yes)
    Attachment (v3-0001-Simplify-planning-of-starjoin-queries.patch) at 2025-09-23 19:46:05 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (v2-0001-Simplify-planning-of-starjoin-queries.patch) at 2025-07-28 19:44:11 from Tomas Vondra <tomas at vondra.me> (Patch: Yes)
    Attachment (starjoin.sql) at 2025-02-04 14:00:49 from Tomas Vondra <tomas at vondra.me> (Patch: No)
History
When Who What
2026-04-07 15:51:04 Tom Lane (tgl) Removed tgl from reviewers
2025-11-12 15:52:33 Tomas Vondra (fuzzycz) New status: Needs review
2025-10-19 11:57:37 Tomas Vondra (fuzzycz) Moved from CF PG19-2 to CF PG19-3
2025-10-02 15:40:32 Tom Lane (tgl) New status: Waiting on Author
2025-09-24 16:57:31 CFbot Patch does not need rebase anymore
2025-09-04 23:12:20 CFbot Patch needs rebase
2025-08-07 00:20:54 Tom Lane (tgl) Added tgl as reviewer
2025-07-28 19:53:27 Tomas Vondra (fuzzycz) Moved from CF 2025-03 to CF PG19-2
2025-02-06 22:05:31 Tomas Vondra (fuzzycz) Changed authors to Tomas Vondra (fuzzycz)
2025-02-06 22:05:22 Tomas Vondra (fuzzycz) Attached mail thread 1ea167aa-457d-422a-8422-b025bb660ef3@vondra.me
2025-02-06 22:05:22 Tomas Vondra (fuzzycz) Created patch record
Edit