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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]