--- Scott Marlowe <[EMAIL PROTECTED]> 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. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend