X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 5D173D1B486 for ; Wed, 3 Dec 2003 03:53:53 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 45763-06 for ; Tue, 2 Dec 2003 23:53:30 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 05D65D1B44D for ; Tue, 2 Dec 2003 23:53:20 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.10/8.12.10) with ESMTP id hB33rR19026700; Tue, 2 Dec 2003 22:53:27 -0500 (EST) To: Greg Stark Cc: Jared Carr , pgsql-performance@postgresql.org Subject: Re: A question on the query planner In-reply-to: <87znea7kis.fsf@stark.dyndns.tv> References: <3FCBB639.10409@89glass.com> <1070385381.24915.8650.camel@camel> <3FCCD225.8030609@89glass.com> <87d6b79har.fsf@stark.dyndns.tv> <3FCCE48B.10406@89glass.com> <871xrn9e09.fsf@stark.dyndns.tv> <3FCCF61E.90307@89glass.com> <87ptf697h0.fsf@stark.dyndns.tv> <25476.1070409047@sss.pgh.pa.us> <87znea7kis.fsf@stark.dyndns.tv> Comments: In-reply-to Greg Stark message dated "02 Dec 2003 20:33:15 -0500" Date: Tue, 02 Dec 2003 22:53:27 -0500 Message-ID: <26699.1070423607@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/45 X-Sequence-Number: 4905 Greg Stark writes: > Tom Lane writes: >> Define "no longer works well". > Well it seems to completely bar the use of a straight merge join between two > index scans: Hmmm ... [squints] ... it's not supposed to do that ... [digs] ... yeah, there's something busted here. Will get back to you ... regards, tom lane