Home > mailing lists

indexed aggregates? - Mailing list pgsql-novice

From	henlin
Subject	indexed aggregates?
Date	March 26, 2007 19:07:49
Msg-id	46081357.000002.05062@webmail13.yandex.ru Whole thread Raw
Responses	Re: indexed aggregates? (Sean Davis <sdavis2@mail.nih.gov>)
List	pgsql-novice

Tree view

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

pgsql-novice by date:

From: Tom Lane
Date: 26 March 2007, 18:02:25
Subject: Re: MS ASCII characters in text field

From: Sean Davis
Date: 26 March 2007, 19:16:47
Subject: Re: indexed aggregates?

indexed aggregates? - Mailing list pgsql-novice

Previous

Next