Add ExprState hashing for GROUP BY and hashed SubPlans

Title

Topic

Performance

Created

2024-09-01 11:49:48

Last modified

2024-10-30 21:55:10 (2 weeks, 5 days ago)

Latest email

2024-11-05 20:38:09 (1 week, 6 days ago)

Status

2024-11: Needs review

2024-09: Moved to next CF

Target version

Authors

David Rowley (davidrowley)

Reviewers

Committer

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/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-05 20:38:09 by David Rowley <dgrowleyml at gmail.com>
Latest 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>
    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-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