Add ExprState hashing for GROUP BY and hashed SubPlans

5229

Title

Topic

Performance

Created

2024-09-01 11:49:48

Last modified

2024-12-02 13:41:22 (6 days, 7 hours ago)

Latest email

2024-11-28 07:05:09 (1 week, 3 days ago)

Status

2025-01: Needs review

2024-11: Moved to next CF

2024-09: Moved to next CF

Target version

Authors

David Rowley (davidrowley)

Reviewers

Become reviewer

Committer

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-11-28 07:05:09 by David Rowley <dgrowleyml at gmail.com>
Latest 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>
    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-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