Is were any way to make aggregates work faster? Like some kind of indexes?
as for example "SELECT a,sum(b) FROM c GROUP BY a;"
The only thing come to my mind is tmp tables && triggers && some kind of functions (not sure, which and how).
Grokbase › Groups › PostgreSQL › pgsql-novice › March 2007