Home Original page

starjoin join order planning

This patch is part of a closed commitfest. It is no longer being picked up by CI. If you want CI to run on this patch, move it to an open commitfest.

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 Tom Lane (tgl)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
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