hubert depesz lubaczewski wrote:
Well, this query basically has to be slow. Correct approach to this problem is to add precalculated aggregates...
The point of this data set and associated queries is to see how fast the database can do certain types of queries on its own. Some other types of database implementations automatically do well here due to column storage and other techniques; the idea is to measure how you can do without trying to rewrite the app any though. If precomputed aggregates were added, they'd improve performance for everybody else, too.
-- Greg Smith 2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support greg@xxxxxxxxxxxxxxx www.2ndQuadrant.com -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
