From: Yeb Havinga <yebhavinga@gmail.com>
To: Kenneth Marshall <ktm@rice.edu>
Cc: Benoit Delbosc <bdelbosc@nuxeo.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Bad query plan inside EXISTS clause
Date: Wed, 10 Mar 2010 14:51:04 +0100
Message-ID: <4B97A3C8.6000509@gmail.com> (raw)
In-Reply-To: <20100310134342.GA29320@it.is.rice.edu>
References: <4B979DFC.7080509@nuxeo.com>
<20100310134342.GA29320@it.is.rice.edu>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: yebhavinga@gmail.com, ktm@rice.edu, bdelbosc@nuxeo.com
Subject: Re: Bad query plan inside EXISTS clause
In-Reply-To: <4B97A3C8.6000509@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox