On Thu, 31 Oct 2024 at 15:30, Andrei Lepikhov <lepi...@gmail.com> wrote: > Comparing the master with and without your patch, the first, I see is > more extensive usage of memory (see complete explains in the attachment): > > Current master: > Batches: 1 Memory Usage: 74513kB
> Patched: > Batches: 261 Memory Usage: 527905kB Disk Usage: 4832656kB Thanks for testing that. I had forgotten to adjust the storage location for the hash initial value when I rebased the patch against the changes made in 9ca67658d. I've fixed that in the attached patch. The patched version comes out faster for me now: master: Execution Time: 15515.401 ms v4 patch: Execution Time: 15024.395 ms David
v4-0001-Use-ExprStates-for-hashing-in-GROUP-BY-and-SubPla.patch
Description: Binary data
