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 (2 weeks, 1 day ago)

Latest email 2024-12-11 00:49:42 (2 weeks, 1 day 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