Speed up Hash Join by teaching ExprState about hashing

Title

Topic

Performance

Created

2024-05-13 09:24:18

Last modified

2024-08-20 01:43:06 (3 months ago)

Latest email

2024-08-17 05:14:10 (3 months ago)

Status

2024-09: Committed

2024-07: Moved to next CF

Target version

Authors

David Rowley (davidrowley)

Reviewers

Committer

David Rowley (davidrowley)

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/4985
git checkout commitfest/cf/4985

Emails

Speed up Hash Join by teaching ExprState about hashing: First at 2024-05-13 09:23:49 by David Rowley <dgrowleyml at gmail.com>
Latest at 2024-08-17 05:14:10 by David Rowley <dgrowleyml at gmail.com>
Latest attachment (v4-0001-Speed-up-Hash-Join-by-making-ExprStates-support-h.patch) at 2024-08-17 05:14:10 from David Rowley <dgrowleyml at gmail.com>
    Attachment (v4-0001-Speed-up-Hash-Join-by-making-ExprStates-support-h.patch) at 2024-08-17 05:14:10 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (hashjoin_bench.sh.txt) at 2024-08-14 23:36:57 from David Rowley <dgrowleyml at gmail.com> (Patch: No)
    Attachment (v2-0001-Speed-up-Hash-Join-by-making-ExprStates-hash.patch) at 2024-07-11 04:47:09 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (bench.sh.txt) at 2024-05-13 09:23:49 from David Rowley <dgrowleyml at gmail.com> (Patch: No)

History

When	Who	What
2024-08-20 01:43:06	David Rowley (davidrowley)	Closed in commitfest 2024-09 with status: Committed
2024-08-20 01:43:06	David Rowley (davidrowley)	Changed committer to davidrowley
2024-08-13 09:20:57	Alexey Dvoichenkov (alexey.d)	Removed alexey.d from reviewers
2024-08-11 10:14:27	Alexey Dvoichenkov (alexey.d)	Added alexey.d as reviewer
2024-08-01 04:47:19	Corey Huinker (coreyh)	Closed in commitfest 2024-07 with status: Moved to next CF
2024-05-13 09:24:28	David Rowley (davidrowley)	Changed authors to David Rowley (davidrowley)
2024-05-13 09:24:18	David Rowley (davidrowley)	Attached mail thread CAApHDvoexAxgQFNQD_GRkr2O_eJUD1-wUGm=m0L+Gc=T=kEa4g@mail.gmail.com
2024-05-13 09:24:18	David Rowley (davidrowley)	Created patch record