From: Luke Lonergan <llonergan@greenplum.com>
To: Pål Stenslet <paal.stenslet@exie.com>
To: pgsql-performance@postgresql.org
Cc: Jie Zhang <jzhang@greenplum.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Subject: Re: Should Oracle outperform PostgreSQL on a complex
Date: Mon, 12 Dec 2005 10:30:03 -0800
Message-ID: <BFC301AB.16680%llonergan@greenplum.com> (raw)
In-Reply-To: <43D5D5C1F10C384B9AB4AE34A0510EC12B2D58@e1.exie.no>
Paal,
On 12/12/05 2:10 AM, "Pål Stenslet" <paal.stenslet@exie.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: llonergan@greenplum.com, paal.stenslet@exie.com, jzhang@greenplum.com, tgl@sss.pgh.pa.us
Subject: Re: Should Oracle outperform PostgreSQL on a complex
In-Reply-To: <BFC301AB.16680%llonergan@greenplum.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox