Re: [HACKERS] Reusing abbreviated keys during second pass of ordered [set] aggregates

2015-09-26 Thread Peter Geoghegan
On Sun, Sep 6, 2015 at 9:35 PM, Thomas Munro wrote: > Running various contrived aggregate queries on a large low cardinality > dataset in a small range (therefore frequently the same weight & size), I > managed to measure a small improvement of up to a few percent

Re: [HACKERS] Reusing abbreviated keys during second pass of ordered [set] aggregates

2015-09-06 Thread Thomas Munro
On Sat, Jul 11, 2015 at 10:05 AM, Peter Geoghegan wrote: > Currently, there are certain aggregates that sort some tuples before > making a second pass over their memtuples array (through the tuplesort > "gettuple" interface), calling one or more attribute equality operator >

[HACKERS] Reusing abbreviated keys during second pass of ordered [set] aggregates

2015-07-10 Thread Peter Geoghegan
Currently, there are certain aggregates that sort some tuples before making a second pass over their memtuples array (through the tuplesort gettuple interface), calling one or more attribute equality operator functions as they go. For example, this occurs during the execution of the following