Re: Bad query plan inside EXISTS clause

From: Yeb Havinga <yebhavinga(at)gmail(dot)com>
To: Kenneth Marshall <ktm(at)rice(dot)edu>
Cc: Benoit Delbosc <bdelbosc(at)nuxeo(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Bad query plan inside EXISTS clause
Date: 2010-03-10 13:51:04
Message-ID: 4B97A3C8.6000509@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Yeb Havinga 2010-03-10 14:05:20 Re: Bad query plan inside EXISTS clause
Previous Message Kenneth Marshall 2010-03-10 13:43:42 Re: Bad query plan inside EXISTS clause