X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 67303D1B54B for ; Thu, 13 Nov 2003 17:20:15 +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 78988-07 for ; Thu, 13 Nov 2003 13:19:44 -0400 (AST) Received: from bramble.mmrd.com (unknown [65.217.53.66]) by svr1.postgresql.org (Postfix) with ESMTP id 3E382D1B558 for ; Thu, 13 Nov 2003 13:19:43 -0400 (AST) Received: from thorn.mmrd.com (thorn.mmrd.com [172.25.10.100]) by bramble.mmrd.com (8.12.8/8.12.8) with ESMTP id hADGOgcM009669; Thu, 13 Nov 2003 11:24:42 -0500 Received: from gnvex001.mmrd.com (gnvex001.mmrd.com [192.168.3.55]) by thorn.mmrd.com (8.11.6/8.11.6) with ESMTP id hADHJgl28561; Thu, 13 Nov 2003 12:19:42 -0500 Received: from camel.mmrd.com ([172.25.5.213]) by gnvex001.mmrd.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2657.72) id V3JRTQL2; Thu, 13 Nov 2003 12:19:41 -0500 Subject: Re: IN surpasses NOT EXISTS in 7.4RC2 ?? From: Robert Treat To: Tom Lane Cc: Rajesh Kumar Mallah , pgsql-performance@postgresql.org In-Reply-To: <27151.1068742810@sss.pgh.pa.us> References: <200311131323.39762.mallah@trade-india.com> <1068737502.10946.18338.camel@camel> <27151.1068742810@sss.pgh.pa.us> Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.8 Date: 13 Nov 2003 12:19:42 -0500 Message-Id: <1068743982.10945.18510.camel@camel> Mime-Version: 1.0 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/92 X-Sequence-Number: 4652 On Thu, 2003-11-13 at 12:00, Tom Lane wrote: > Robert Treat writes: > > Does the not exist query produce worse results in 7.4 than it did in > > 7.3? > > EXISTS should work the same as before. > right. the original poster is asking if there is "something wrong with exist" based on the comparison to IN, he needs to compare it vs. 7.3 EXISTS to determine if something is wrong. Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL