From: Luke Lonergan <llonergan@greenplum.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
To: Simon Riggs <simon@2ndquadrant.com>
To: Bruce Momjian <pgman@candle.pha.pa.us>
To: Pål Stenslet <paal.stenslet@exie.com>
To: pgsql-performance@postgresql.org
Cc: Ayush Parashar <aparashar@greenplum.com>
Subject: Re: Should Oracle outperform PostgreSQL on a complex
Date: Sat, 17 Dec 2005 11:05:27 -0800
Message-ID: <BFC9A177.16BB2%llonergan@greenplum.com> (raw)
In-Reply-To: <9010.1134845227@sss.pgh.pa.us>
Tom,
On 12/17/05 10:47 AM, "Tom Lane" <tgl@sss.pgh.pa.us> wrote:
> BTW, some experimentation suggests that in fact a star join is already
> slower than the "regular" plan in 8.1. You can force a star-join plan
> to be generated like this:
Cool!
We've got Paal's test case in the queue to run, it's taking us some time to
get to it, possibly by next week we should be able to run some of these
cases:
1) 8.1.1 btree with bitmap scan
2) 8.1.1 on-disk bitmap with direct AND operations
3) (2) with forced star transformation (materialize)
We'll also be trying the same things with the CVS tip of Bizgres MPP,
probably over X-mas.
We should be able to handily beat Oracle's 3 second number.
- 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, tgl@sss.pgh.pa.us, simon@2ndquadrant.com, pgman@candle.pha.pa.us, paal.stenslet@exie.com, aparashar@greenplum.com
Subject: Re: Should Oracle outperform PostgreSQL on a complex
In-Reply-To: <BFC9A177.16BB2%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