handle batch explosion in hash joins

Title

Topic

Performance

Created

2024-12-31 23:07:19

Last modified

2024-12-31 23:07:29 (2 weeks, 3 days ago)

Latest email

2025-01-13 17:29:05 (4 days, 10 hours ago)

Status

2025-01: Needs review

Target version

Authors

Tomas Vondra (fuzzycz)

Reviewers

Committer

Links

Checkout latest CFbot patchset

Go to your local checkout of the PostgreSQL repository and run:

git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/5482
git checkout commitfest/cf/5482

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-01-13 17:29:05 by Tomas Vondra <tomas at vondra.me>
Latest attachment (hashjoin-file-limit.patch) at 2025-01-12 00:42:28 from Tomas Vondra <tomas at vondra.me>
    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
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