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 5FE6F9DD442 for ; Mon, 12 Dec 2005 14:30:19 -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 20606-02 for ; Mon, 12 Dec 2005 14:30:18 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.Mi8.com (d01gw01.mi8.com [63.240.6.47]) by postgresql.org (Postfix) with ESMTP id B95FE9DD75F for ; Mon, 12 Dec 2005 14:30:16 -0400 (AST) Received: from 172.16.1.26 by mail.Mi8.com with ESMTP (- Welcome to Mi8 Corporation www.Mi8.com (D1)); Mon, 12 Dec 2005 13:30:04 -0500 X-Server-Uuid: 241911D6-425B-44B9-A073-E3FE0F8FC774 Received: from MI8NYCMAIL06.Mi8.com ([172.16.1.175]) by D01HOST01.Mi8.com with Microsoft SMTPSVC(6.0.3790.1830); Mon, 12 Dec 2005 13:30:04 -0500 Received: from 67.103.45.218 ([67.103.45.218]) by MI8NYCMAIL06.Mi8.com ( [172.16.1.219]) via Exchange Front-End Server mi8owa.mi8.com ( [172.16.1.106]) with Microsoft Exchange Server HTTP-DAV ; Mon, 12 Dec 2005 18:30:04 +0000 User-Agent: Microsoft-Entourage/11.2.1.051004 Date: Mon, 12 Dec 2005 10:30:03 -0800 Subject: Re: Should Oracle outperform PostgreSQL on a complex From: "Luke Lonergan" To: "P=?ISO-8859-1?B?5Q==?=l Stenslet" , pgsql-performance@postgresql.org cc: "Jie Zhang" , "Tom Lane" Message-ID: Thread-Topic: [PERFORM] Should Oracle outperform PostgreSQL on a complex multidimensional query? Thread-Index: AcX76ks0M7ht9LVDRK2tRVq5kQ9ZKACrQlEgABV4NuAAFzb0pw== In-Reply-To: <43D5D5C1F10C384B9AB4AE34A0510EC12B2D58@e1.exie.no> MIME-Version: 1.0 X-OriginalArrivalTime: 12 Dec 2005 18:30:04.0785 (UTC) FILETIME=[1231E610:01C5FF4A] X-WSS-ID: 6F831E262V82198538-01-01 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.253 required=5 tests=[AWL=0.000, RCVD_NUMERIC_HELO=1.253] X-Spam-Score: 1.253 X-Spam-Level: * X-Archive-Number: 200512/294 X-Sequence-Number: 16115 Paal, On 12/12/05 2:10 AM, "P=E5l Stenslet" 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 w= e 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