Add a greedy join search algorithm to handle large join problems

Edit
ID 6274
Title Add a greedy join search algorithm to handle large join problems
CI (CFBot) Summary
Stats (from CFBot) Patch count: 0, First patch: +0−0, All patches: +0−0
Tags Performance
Created 2025-12-02 14:55:10
Last modified 2026-04-12 01:32:50 (4 weeks ago)
Latest email 2026-05-11 14:33:50 (9 hours ago)
Status
PG20-1 (2026-07-01 – 2026-07-31): Waiting on Author
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) 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-05-11 14:33:50 by Chengpeng Yan <chengpeng_yan at outlook.com>
Latest attachment (v4-job-benchmark-result-20260511.pdf) at 2026-05-11 14:33:50 from Chengpeng Yan <chengpeng_yan at outlook.com>
    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-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
Edit