handle batch explosion in hash joins

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch version: v20250218, Patch count: 3, First patch: +129−0, All patches: +5635−0

Topic

Performance

Created

2024-12-31 23:07:19

Last modified

2025-02-19 20:23:03 (3 months ago)

Latest email

2025-02-25 18:02:01 (3 months ago)

Status

2025-03: Committed

2025-01: Moved to next CF

Target version

Authors

Tomas Vondra (fuzzycz)

Reviewers

Committer

Tomas Vondra (fuzzycz)

Links

Emails

Adjusting hash join memory limit to handle batch explosion: First at 2024-12-31 23:06:59 by Tomas Vondra <tomas at vondra.me>
Latest at 2025-02-25 18:02:01 by James Hunter <james.hunter.pg at gmail.com>
Latest attachment (v20250218-0001-Reduce-the-impact-of-hashjoin-batch-explos.patch) at 2025-02-18 15:44:05 from Tomas Vondra <tomas at vondra.me>
    Attachment (v20250218-0001-Reduce-the-impact-of-hashjoin-batch-explos.patch) at 2025-02-18 15:44:05 from Tomas Vondra <tomas at vondra.me> (Patch: Yes)
    Attachment (v20250208-0003-hashjoin-patch-tests.patch) at 2025-02-07 23:54:40 from Tomas Vondra <tomas at vondra.me> (Patch: Yes)
    Attachment (v20250206-0003-hashjoin-patch-tests.patch) at 2025-02-06 18:48:10 from Tomas Vondra <tomas at vondra.me> (Patch: Yes)
    Attachment (v20250125-0001-Balance-memory-usage-with-hashjoin-batch-e.patch) at 2025-01-25 20:41:29 from Tomas Vondra <tomas at vondra.me> (Patch: Yes)
    Attachment (hashjoin-file-limit.patch) at 2025-01-12 00:42:28 from Tomas Vondra <tomas at vondra.me> (Patch: Yes)
    Attachment (vadjust-size-0001-hashjoin-sizing-balance.patch) at 2025-01-06 02:59:39 from Tomas Vondra <tomas at vondra.me> (Patch: Yes)
    Attachment (v20241231-adjust-limit-0001-Account-for-batch-files-in-ha.patch) at 2024-12-31 23:06:59 from Tomas Vondra <tomas at vondra.me> (Patch: Yes)

History

When	Who	What
2025-02-19 20:23:03	Tomas Vondra (fuzzycz)	Closed in commitfest 2025-03 with status: Committed
2025-02-19 20:23:03	Tomas Vondra (fuzzycz)	Changed committer to fuzzycz
2025-02-06 22:06:35	Tomas Vondra (fuzzycz)	Closed in commitfest 2025-01 with status: Moved to next CF
2024-12-31 23:07:29	Tomas Vondra (fuzzycz)	Changed authors to Tomas Vondra (fuzzycz)
2024-12-31 23:07:19	Tomas Vondra (fuzzycz)	Attached mail thread 7bed6c08-72a0-4ab9-a79c-e01fcdd0940f@vondra.me
2024-12-31 23:07:19	Tomas Vondra (fuzzycz)	Created patch record