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 Orac
"Sailer, Denis (YBUSA-CDR)" <[EMAIL PROTECTED]> writes:
> We are evaluating PostgreSQL for a typical data warehouse application. I
> have 3 tables below that are part of a Star schema design. The query listed
> below runs in 16 seconds on Oracle 9.2 and 3+ minutes on PostgreSQL 7.3.3
> Here are t
We are evaluating PostgreSQL for a typical data warehouse application. I
have 3 tables below that are part of a Star schema design. The query listed
below runs in 16 seconds on Oracle 9.2 and 3+ minutes on PostgreSQL 7.3.3
Here are the details.
I'm wondering what else can be done to tune this ty