Add a greedy join search algorithm to handle large join problems

6274

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch version: v7, Patch count: 2, First patch: +1732−2, All patches: +1931−1

Tags

Performance

Created

2025-12-02 14:55:10

Last modified

2026-11-15 08:53:50 (22 minutes ago)

Latest email

2026-11-15 08:51:47 (24 minutes ago)

Status

PG20-4 (2027-01-01 – 2027-01-31): Needs review

PG20-1 (2026-07-01 – 2026-07-31): Moved to different CF

PG19-Final (2026-03-01 – 2026-04-09): Moved to different CF

PG19-4 (2026-01-01 – 2026-01-31): Moved to different CF

Target version

Authors

Chengpeng Yan (chengpeng.yan)

Reviewers

lakshmi g (lakshmi) Log in to become reviewer

Committer

Links

Emails

Add a greedy join search algorithm to handle large join problems: First at 2025-12-02 03:48:26 by Chengpeng Yan <chengpeng_yan at outlook.com>
Latest at 2026-11-15 08:51:47 by Chengpeng Yan <chengpeng_yan at outlook.com>
Latest attachment (goo-v7-data.tar.xz) at 2026-11-15 08:51:47 from Chengpeng Yan <chengpeng_yan at outlook.com>
    Attachment (goo-v7-data.tar.xz) at 2026-11-15 08:51:47 from Chengpeng Yan <chengpeng_yan at outlook.com> (Patch: No)
    Attachment (v6-0001-Add-GOO-Greedy-Operator-Ordering-join-search-as-a.patch) at 2026-06-22 15:33:59 from Tomas Vondra <tomas at vondra.me> (Patch: Yes)
    Attachment (v4-job-benchmark-result-20260511.pdf) at 2026-05-11 14:33:50 from Chengpeng Yan <chengpeng_yan at outlook.com> (Patch: No)
    Attachment (v5-job-benchmark-execution-result.pdf) at 2026-05-03 12:46:46 from Chengpeng Yan <chengpeng_yan at outlook.com> (Patch: No)
    Attachment (v5-0001-Add-GOO-Greedy-Operator-Ordering-join-search-as-a.patch) at 2026-02-14 05:39:33 from Chengpeng Yan <chengpeng_yan at outlook.com> (Patch: Yes)
    Attachment (v4_job.pdf) at 2026-01-05 04:15:25 from Chengpeng Yan <chengpeng_yan at Outlook.com> (Patch: No)
    Attachment (tpch_tests_result.zip) at 2025-12-16 14:38:03 from Chengpeng Yan <chengpeng_yan at Outlook.com> (Patch: No)
    Attachment (tpc-ds-ryzen.csv) at 2025-12-11 17:30:46 from Tomas Vondra <tomas at vondra.me> (Patch: No)
    Attachment (v2-0001-Add-GOO-Greedy-Operator-Ordering-join-search-as-a.patch) at 2025-12-10 05:20:01 from Chengpeng Yan <chengpeng_yan at Outlook.com> (Patch: Yes)
    Attachment (crash.txt) at 2025-12-09 19:20:32 from Tomas Vondra <tomas at vondra.me> (Patch: No)
    Attachment (v1-0001-Add-GOO-Greedy-Operator-Ordering-join-search-as-a.patch) at 2025-12-02 03:48:26 from Chengpeng Yan <chengpeng_yan at outlook.com> (Patch: Yes)

History

When	Who	What
2026-11-15 08:53:50	Chengpeng Yan (chengpeng.yan)	New status: Needs review
2026-11-15 08:53:47	Chengpeng Yan (chengpeng.yan)	Moved from CF PG20-1 to CF PG20-4
2026-04-12 01:32:50	Chengpeng Yan (chengpeng.yan)	Moved from CF PG19-Final to CF PG20-1
2026-03-26 09:57:41	Chengpeng Yan (chengpeng.yan)	New status: Waiting on Author
2026-02-20 11:32:57	lakshmi g (lakshmi)	Added lakshmi as reviewer
2026-02-14 05:53:29	Chengpeng Yan (chengpeng.yan)	Moved from CF PG19-4 to CF PG19-Final
2025-12-02 14:56:57	Chengpeng Yan (chengpeng.yan)	Changed targetversion to None
2025-12-02 14:55:10	Chengpeng Yan (chengpeng.yan)	Attached mail thread 3FF63E99-AB4F-41A9-BC78-AAB28823FBD0@Outlook.com
2025-12-02 14:55:10	Chengpeng Yan (chengpeng.yan)	Created patch record