X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 9E0ED9DCC0E for ; Sat, 17 Dec 2005 15:05:37 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 31719-02 for ; Sat, 17 Dec 2005 15:05:37 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.mi8.com (d01gw02.mi8.com [63.240.6.46]) by postgresql.org (Postfix) with ESMTP id 24DEF9DCC1C for ; Sat, 17 Dec 2005 15:05:34 -0400 (AST) Received: from 172.16.1.112 by mail.mi8.com with ESMTP (- Welcome to Mi8 Corporation www.Mi8.com (D2)); Sat, 17 Dec 2005 14:05:28 -0500 X-Server-Uuid: 7829E76E-BB9E-4995-8473-3C0929DF7DD1 Received: from MI8NYCMAIL06.Mi8.com ([172.16.1.175]) by D01SMTP02.Mi8.com with Microsoft SMTPSVC(6.0.3790.1830); Sat, 17 Dec 2005 14:05:28 -0500 Received: from 69.181.100.71 ([69.181.100.71]) by MI8NYCMAIL06.Mi8.com ( [172.16.1.219]) via Exchange Front-End Server mi8owa.mi8.com ( [172.16.1.105]) with Microsoft Exchange Server HTTP-DAV ; Sat, 17 Dec 2005 19:05:27 +0000 User-Agent: Microsoft-Entourage/11.2.1.051004 Date: Sat, 17 Dec 2005 11:05:27 -0800 Subject: Re: Should Oracle outperform PostgreSQL on a complex From: "Luke Lonergan" To: "Tom Lane" , "Simon Riggs" , "Bruce Momjian" , "P=?ISO-8859-1?B?5Q==?=l Stenslet" , pgsql-performance@postgresql.org cc: "Ayush Parashar" Message-ID: Thread-Topic: [PERFORM] Should Oracle outperform PostgreSQL on a complex Thread-Index: AcYDOmXNpqrVm3U8Q+q7MIqnCPtJCwAAnFkk In-Reply-To: <9010.1134845227@sss.pgh.pa.us> MIME-Version: 1.0 X-OriginalArrivalTime: 17 Dec 2005 19:05:28.0115 (UTC) FILETIME=[D7DD1830:01C6033C] X-WSS-ID: 6FBABEF22345170332-01-01 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.253 required=5 tests=[RCVD_NUMERIC_HELO=1.253] X-Spam-Score: 1.253 X-Spam-Level: * X-Archive-Number: 200512/431 X-Sequence-Number: 16252 Tom, On 12/17/05 10:47 AM, "Tom Lane" 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