MergeJoin beats HashJoin in the case of multiple hash clauses

5114

Title

CI (CFBot)

Needs rebase! Additional links previous successfully applied patch (outdated):

Summary

Stats (from CFBot)

Unknown

Topic

Performance

Created

2024-07-08 12:47:55

Last modified

2025-02-06 08:01:26 (1 month ago)

Latest email

2025-03-09 12:13:52 (2 days, 16 hours ago)

Status

2025-03: Needs review

2025-01: Moved to next CF

2024-11: Moved to next CF

2024-09: Moved to next CF

Target version

Authors

Andrei Lepikhov (lepikhov)

Reviewers

Become reviewer

Committer

Links

Emails

MergeJoin beats HashJoin in the case of multiple hash clauses: First at 2023-06-15 08:30:10 by Andrey Lepikhov <a.lepikhov at postgrespro.ru>
Latest at 2025-03-09 12:13:52 by Alexander Korotkov <aekorotkov at gmail.com>
Latest attachment (v3-0001-Use-extended-stats-for-precise-estimation-of-buck.patch) at 2025-03-09 12:13:52 from Alexander Korotkov <aekorotkov at gmail.com>
    Attachment (v3-0001-Use-extended-stats-for-precise-estimation-of-buck.patch) at 2025-03-09 12:13:52 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Use-extended-statistics-for-precise-estimation-of.patch) at 2025-03-03 08:24:40 from Andrei Lepikhov <lepihov at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Use-extended-statistics-for-precise-estimation-of.patch) at 2025-02-17 00:34:26 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Use-extended-statistics-for-precise-estimation-of.patch) at 2024-10-08 05:00:27 from Andrei Lepikhov <lepihov at gmail.com> (Patch: Yes)
    Attachment (0001-Use-extended-statistics-for-precise-estimation-of-bu.patch) at 2024-07-08 12:45:15 from Andrei Lepikhov <lepihov at gmail.com> (Patch: Yes)
    Attachment (fix_bucketsize_v2.diff) at 2023-09-11 08:04:22 from "Lepikhov Andrei" <a.lepikhov at postgrespro.ru> (Patch: Yes)
    Attachment (diff_estimate.diff) at 2023-06-28 13:53:06 from Alena Rybakina <lena.ribackina at yandex.ru> (Patch: Yes)
    Attachment (q2.sql) at 2023-06-15 08:30:10 from Andrey Lepikhov <a.lepikhov at postgrespro.ru> (Patch: No)

History

When	Who	What
2025-03-11 21:33:39	CFbot	Patch needs rebase
2025-02-06 08:01:26	Andrei Lepikhov (lepikhov)	Closed in commitfest 2025-01 with status: Moved to next CF
2024-12-02 13:33:23	Dmitry Dolgov (erthalion)	Closed in commitfest 2024-11 with status: Moved to next CF
2024-10-07 08:46:20	Andrei Lepikhov (lepikhov)	Closed in commitfest 2024-09 with status: Moved to next CF
2024-07-08 12:48:10	Andrei Lepikhov (lepikhov)	Changed authors to Andrei Lepikhov (lepikhov)
2024-07-08 12:47:55	Andrei Lepikhov (lepikhov)	Attached mail thread 52257607-57f6-850d-399a-ec33a654457b@postgrespro.ru
2024-07-08 12:47:55	Andrei Lepikhov (lepikhov)	Created patch record