Add a greedy join search algorithm to handle large join problems

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch version: v5, Patch count: 2, First patch: +1720−5, All patches: +1922−4

Tags

Performance

Created

2025-12-02 14:55:10

Last modified

2026-02-14 05:53:29 (11 hours ago)

Latest email

2026-01-05 04:15:25 (1 month ago)

Status

PG19-Final (2026-03-01 – 2026-03-31): Needs review

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

Target version

Authors

Chengpeng Yan (chengpeng.yan)

Reviewers

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-02-14 05:39:33 by Chengpeng Yan <chengpeng_yan at outlook.com>
Latest attachment (v4_job.pdf) at 2026-01-05 04:15:25 from Chengpeng Yan <chengpeng_yan at Outlook.com>
    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-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