> 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]

Reply via email to