Postgres Pro
Downloads
Home   >   mailing lists

Re: Query running slower than same on Oracle - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Query running slower than same on Oracle
Date
Msg-id 200306251451.33928.josh@agliodbs.com
Whole thread Raw
In response to Query running slower than same on Oracle  ("Sailer, Denis (YBUSA-CDR)" <Denis.Sailer@Yellowbook.com>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Query running slower than same on Oracle
Next
From: SZUCS Gábor
Date:
Subject: Re: Similar querys, better execution time on worst execution plan