Re: Speeding up aggregates

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