FAQ
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).

Search Discussions

  • Sean Davis at Mar 26, 2007 at 7:16 pm

    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

Related Discussions

Discussion Navigation
viewthread | post
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