FAQ

On Monday 26 March 2007 14:39, henlin wrote:
hi.

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).
You could certainly put a trigger on table c that inserts or updates values in
another table and then use that for lookups of sums. It wouldn't be a very
general solution (you need to know ahead of time what aggregates you want to
query), but it might satisfy your needs.

Sean

Search Discussions

Discussion Posts

Previous

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 2 of 2 | next ›
Discussion Overview
grouppgsql-novice @
categoriespostgresql
postedMar 26, '07 at 7:07p
activeMar 26, '07 at 7:16p
posts2
users2
websitepostgresql.org
irc#postgresql

2 users in discussion

Henlin: 1 post Sean Davis: 1 post

People

Translate

site design / logo © 2022 Grokbase