Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id BDCA5634C6F
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Wed, 10 Mar 2010 09:51:15 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 30466-03
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Wed, 10 Mar 2010 13:51:04 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-ew0-f227.google.com (mail-ew0-f227.google.com
	[209.85.219.227])
	by mail.postgresql.org (Postfix) with ESMTP id 2C437634660
	for <pgsql-performance@postgresql.org>;
	Wed, 10 Mar 2010 09:51:05 -0400 (AST)
Received: by ewy27 with SMTP id 27so3921068ewy.34
	for <pgsql-performance@postgresql.org>;
	Wed, 10 Mar 2010 05:51:03 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from
	:user-agent:mime-version:to:cc:subject:references:in-reply-to
	:content-type:content-transfer-encoding;
	bh=+WB3Lg8G2HIDjwaeDeNC9g4ouKN4anTU8QtmTjvvLeQ=;
	b=NbOfR1bCSn788ZnwOP6h7TaKxVDVB0cx2i5b6KDEi3iAF7J5qxtV8GSfoIpO6aZ/5V
	L9NfHkJI3HbvALT5Qmc3lT/suItuTh3dOkquBQbHhvCByV6xdAxSiYOdkV7tmG4+uDlt
	sq29doAnjjxVA0VrgpL4eXGjlXKoPVzNBhCX4=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:user-agent:mime-version:to:cc:subject
	:references:in-reply-to:content-type:content-transfer-encoding;
	b=gBvuNHZKUvQFRMr/x6CgJgXxCfszkiz2ZXIAJVSiu+T48LVJFV/BSxjFl2A33TwY5j
	gBraHp01/ygmVGWtVrvM5845acmolZMoXX56GQ36BmkV913CkLcOEq+skyi6N6e4tXXu
	AVSaydmF04gmsFIg1r2+JUB3I6YHH2FOn8n4g=
Received: by 10.213.65.138 with SMTP id j10mr5239978ebi.23.1268229063288;
	Wed, 10 Mar 2010 05:51:03 -0800 (PST)
Received: from [0.0.0.0] (5357DA75.cable.casema.nl [83.87.218.117])
	by mx.google.com with ESMTPS id 15sm3883236ewy.4.2010.03.10.05.51.01
	(version=TLSv1/SSLv3 cipher=RC4-MD5);
	Wed, 10 Mar 2010 05:51:02 -0800 (PST)
Message-ID: <4B97A3C8.6000509@gmail.com>
Date: Wed, 10 Mar 2010 14:51:04 +0100
From: Yeb Havinga <yebhavinga@gmail.com>
User-Agent: Thunderbird 2.0.0.23 (Windows/20090812)
MIME-Version: 1.0
To: Kenneth Marshall <ktm@rice.edu>
CC: Benoit Delbosc <bdelbosc@nuxeo.com>,
 pgsql-performance@postgresql.org
Subject: Re: Bad query plan inside EXISTS clause
References: <4B979DFC.7080509@nuxeo.com>
	<20100310134342.GA29320@it.is.rice.edu>
In-Reply-To: <20100310134342.GA29320@it.is.rice.edu>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-0.74 tagged_above=-10 required=5 tests=BAYES_20=-0.74
X-Spam-Level: 
X-Archive-Number: 201003/111
X-Sequence-Number: 37936

Kenneth Marshall wrote:
> EXISTS matches NULLs too and since they are not indexed a
> sequential scan is needed to check for them. Try using
> IN instead.
>   
This is nonsense in more than one way.

regards
Yeb Havinga