Add ExprState hashing for GROUP BY and hashed SubPlans

5229

Title

CI (CFBot)

Not processed

Stats (from CFBot)

Unknown

Topic

Performance

Created

2024-09-01 11:49:48

Last modified

2024-12-11 09:45:43 (3 months ago)

Latest email

2024-12-11 00:49:42 (3 months 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

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