> Any suggestions? FYI the original question wasn't meant as a poke at
> comparing PG to MySQL to DB2. I'm not making an yvalue judgements either
> way. I'm just trying to understand how we can use it the best way possible.
>
> If anyone from the bizgres team is watching, have they done any work in
> this area?
>
> Thanks.
> John
>
Actually we just thought about something. With PG, we can create an index
that is a SUM of the column where indexing, no? We're going to test this in
a few hours. Would that be able to be satisfied by an index scan?
Also, we're looking at the link provided for the materialized views in PG.
Thanks.