--- Scott Marlowe <scott.marlowe@gmail.com> wrote:
> Generally, for these kinds of things it's often best to use
> materialized views / rollup tables so that you aren't re-aggregating
> the same data over and over.
I don't know if this was already mentioned, but here is one of the links that describe the method
of implementing a materialized view.
http://www.jonathangardner.net/PostgreSQL/materialized_views/matviews.html
other useful docs like this one can be found here:
http://www.postgresql.org/docs/techdocs.2
Regards,
Richard Broersma Jr.