X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 7C46C9FB345 for ; Wed, 16 Aug 2006 14:33:49 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 64460-01-10 for ; Wed, 16 Aug 2006 14:33:41 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 6D8FD9FB3B8 for ; Wed, 16 Aug 2006 14:33:18 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr4.postgresql.org (Postfix) with ESMTP id 7DBA85AFAC7 for ; Wed, 16 Aug 2006 16:59:49 +0000 (GMT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k7GGwCEI026677; Wed, 16 Aug 2006 12:58:12 -0400 (EDT) To: Kyle Bateman Cc: pgsql-sql@postgresql.org, fweimer@bfk.de Subject: Re: Using bitmap index scans-more efficient In-reply-to: <44E349BA.4070205@actarg.com> References: <44DF6582.4000806@actarg.com> <82mza77rch.fsf@mid.bfk.de> <44E11E1A.8020507@actarg.com> <27367.1155606817@sss.pgh.pa.us> <44E349BA.4070205@actarg.com> Comments: In-reply-to Kyle Bateman message dated "Wed, 16 Aug 2006 10:37:14 -0600" Date: Wed, 16 Aug 2006 12:58:12 -0400 Message-ID: <26676.1155747492@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.755 tagged_above=0 required=5 tests=AWL, SPF_FAIL X-Spam-Level: X-Archive-Number: 200608/121 X-Sequence-Number: 26079 Kyle Bateman writes: > I'm wondering if this might expose a weakness in the optimizer having to > do with left joins. Before 8.2 the optimizer has no ability to rearrange the order of outer joins. Do you have time to try your test case against CVS HEAD? regards, tom lane