Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id C5C00650DBC
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Mon, 30 Jun 2008 01:48:58 -0300 (ADT)
Received: from postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 45170-08 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Mon, 30 Jun 2008 01:48:47 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130])
	by postgresql.org (Postfix) with ESMTP id 119D9650CF5
	for <pgsql-performance@postgresql.org>;
	Mon, 30 Jun 2008 01:48:47 -0300 (ADT)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m5U4miJU011688;
	Mon, 30 Jun 2008 00:48:44 -0400 (EDT)
To: "Jaime Casanova" <jcasanov@systemguards.com.ec>
cc: Ulrich <ulrich.mierendorff@gmx.net>, pgsql-performance@postgresql.org
Subject: Re: Subquery WHERE IN or WHERE EXISTS faster? 
In-reply-to: <3073cc9b0806292133l397f0d8etef06b5bb3aba13ae@mail.gmail.com> 
References: <48665741.2060900@gmx.net> <29009.1214668423@sss.pgh.pa.us>
	<3073cc9b0806292133l397f0d8etef06b5bb3aba13ae@mail.gmail.com>
Comments: In-reply-to "Jaime Casanova" <jcasanov@systemguards.com.ec>
	message dated "Sun, 29 Jun 2008 23:33:57 -0500"
Date: Mon, 30 Jun 2008 00:48:44 -0400
Message-ID: <11687.1214801324@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200806/220
X-Sequence-Number: 30570

"Jaime Casanova" <jcasanov@systemguards.com.ec> writes:
> i've made some queries run faster using EXISTS instead of large IN
> clauses... actually, it was NOT EXISTS replacing a NOT IN

That's just about entirely unrelated ...

			regards, tom lane