Denis,
> I'm wondering what else can be done to tune this type of query. Is 3
> minutes reasonable given the amount of data that is loaded into the 3
> tables? Is there anyone else who has made comparisons between Oracle and
> PostgreSQL?
We will probably be a bit slower on aggregates than Oracle is, for reasons
discussed on this list ad nauseum. However, it also looks from the queries
like you forgot to index your foriegn keys.
--
-Josh Berkus
Aglio Database Solutions
San Francisco