Add ExprState hashing for GROUP BY and hashed SubPlans

Edit
ID 5229
Title Add ExprState hashing for GROUP BY and hashed SubPlans
Topic Performance
Created 2024-09-01 11:49:48
Last modified 2024-12-11 09:45:43 (1 day, 3 hours ago)
Latest email 2024-12-11 00:49:42 (1 day, 12 hours ago)
Status
2025-01: Committed
2024-11: Moved to next CF
2024-09: Moved to next CF
Target version
Authors David Rowley (davidrowley)
Reviewers Become reviewer
Committer David Rowley (davidrowley)
Links CFbot results (CirrusCI) CFbot GitHub
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/5229
git checkout commitfest/cf/5229
Emails
Add ExprState hashing for GROUP BY and hashed SubPlans
First at 2024-09-01 11:49:19 by David Rowley <dgrowleyml at gmail.com>
Latest at 2024-12-11 00:49:42 by David Rowley <dgrowleyml at gmail.com>
Latest attachment (m2_hashjoin_with_execjust_funcs.jpg) at 2024-12-10 22:36:30 from David Rowley <dgrowleyml at gmail.com>
    Attachment (m2_hashjoin_with_execjust_funcs.jpg) at 2024-12-10 22:36:30 from David Rowley <dgrowleyml at gmail.com> (Patch: No)
    Attachment (v7-0001-Add-dedicated-evaluation-functions-for-hashing-Ex.patch) at 2024-12-10 11:44:52 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (v6-0001-Use-ExprStates-for-hashing-in-GROUP-BY-and-SubPla.patch) at 2024-11-28 07:05:09 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (v5-0001-Use-ExprStates-for-hashing-in-GROUP-BY-and-SubPla.patch) at 2024-11-05 20:38:09 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (comment_fix.diff) at 2024-11-02 09:13:16 from Andrei Lepikhov <lepihov at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Use-ExprStates-for-hashing-in-GROUP-BY-and-SubPla.patch) at 2024-10-31 23:17:27 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (bench_results.txt) at 2024-10-31 02:30:06 from Andrei Lepikhov <lepihov at gmail.com> (Patch: No)
    Attachment (v3-0001-Use-ExprStates-for-hashing-in-GROUP-BY-and-SubPla.patch) at 2024-10-31 01:16:07 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Use-ExprStates-for-hashing-in-GROUP-BY-and-SubPla.patch) at 2024-10-29 09:47:22 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (hashjoin_bench.sh.txt) at 2024-09-01 11:49:19 from David Rowley <dgrowleyml at gmail.com> (Patch: No)
History
When Who What
2024-12-11 09:45:43 David Rowley (davidrowley) Closed in commitfest 2025-01 with status: Committed
2024-12-11 09:45:43 David Rowley (davidrowley) Changed committer to davidrowley
2024-12-02 13:41:22 Dmitry Dolgov (erthalion) Closed in commitfest 2024-11 with status: Moved to next CF
2024-10-30 21:55:10 David Rowley (davidrowley) New status: Needs review
2024-10-28 08:51:23 Andrei Lepikhov (lepikhov) New status: Waiting on Author
2024-10-08 02:10:30 Michael Paquier (michael-kun) Closed in commitfest 2024-09 with status: Moved to next CF
2024-09-01 11:50:03 David Rowley (davidrowley) Changed authors to David Rowley (davidrowley)
2024-09-01 11:49:49 David Rowley (davidrowley) Attached mail thread CAApHDvpYSO3kc9UryMevWqthTBrxgfd9djiAjKHMPUSQeX9vdQ@mail.gmail.com
2024-09-01 11:49:48 David Rowley (davidrowley) Created patch record
Edit