From: | "Luke Lonergan" <llonergan(at)greenplum(dot)com> |
---|---|
To: | "P=?ISO-8859-1?B?5Q==?=l Stenslet" <paal(dot)stenslet(at)exie(dot)com>, pgsql-performance(at)postgresql(dot)org |
Cc: | "Jie Zhang" <jzhang(at)greenplum(dot)com>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Subject: | Re: Should Oracle outperform PostgreSQL on a complex |
Date: | 2005-12-12 18:30:03 |
Message-ID: | BFC301AB.16680%llonergan@greenplum.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Paal,
On 12/12/05 2:10 AM, "Pål Stenslet" <paal(dot)stenslet(at)exie(dot)com> wrote:
> Here are the schema details, but first a little introduction:
Terrific, very helpful and thanks for both.
I wonder why the bitmap scan isn't selected in this query, Tom might have
some opinion and suggestions about it.
I'd like to run your case with Bizgres and the new bitmap index to see if we
can increase the selectivity on the query and knock down the times being
spent joining. I think the AND bitmap operations should do just that.
Can you provide one more thing - either the smalltalk code to generate the
csv files or I can provide a web server to upload to (or yours).
Thanks!
- Luke
From | Date | Subject | |
---|---|---|---|
Next Message | Merlin Moncure | 2005-12-12 18:33:27 | Re: How much expensive are row level statistics? |
Previous Message | Bealach-na Bo | 2005-12-12 16:24:40 | Re: Very slow queries - please help |