Re: Should Oracle outperform PostgreSQL on a complex multidimensional query?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Pål Stenslet <paal(dot)stenslet(at)exie(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Should Oracle outperform PostgreSQL on a complex multidimensional query?
Date: 2005-12-11 20:38:54
Message-ID: 18666.1134333534@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

=?iso-8859-1?Q?P=E5l_Stenslet?= <paal(dot)stenslet(at)exie(dot)com> writes:
> I have established similar conditions for the query in PostgreSQL, and =
> it runs in about 30 seconds. Again the CPU utilization is high with no =
> noticable I/O. The query plan is of course very different from that of =
> Oracle, since PostgreSQL lacks the bitmap index merge operation.

Perhaps you should be trying this on PG 8.1? In any case, without
specific details of your schema or a look at EXPLAIN ANALYZE results,
it's unlikely that anyone is going to have any useful comments for you.

regards, tom lane

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Luke Lonergan 2005-12-11 21:15:14 Re: Should Oracle outperform PostgreSQL on a complex
Previous Message Tom Lane 2005-12-11 20:36:25 Re: Join the same row