Tom,
> FWIW, I've implemented hashed aggregation in CVS tip. I have not had
> the time to try to benchmark it, but I'd be interested if anyone can
> run some tests on 7.4devel. Eliminating the need for a SORT step
> should help aggregations over large datasets.
I'd love to, but I am still too much of a tyro to build Postgres from CVS.
As soon as there's a tarball of 7.4devel, I'll build it and run comparisons.
--
-Josh Berkus
Aglio Database Solutions
San Francisco