Re: Using index for IS NULL query

From: Matthew Wakeling <matthew(at)flymine(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Andrus <kobruleht2(at)hot(dot)ee>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Using index for IS NULL query
Date: 2008-11-12 13:29:31
Message-ID: alpine.DEB.1.10.0811121327550.4666@aragorn.flymine.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, 11 Nov 2008, Tom Lane wrote:
>> Index is not used for
>> is null
>> How to fix ?
>
> Update to something newer than 8.1 (specifically, you'll need 8.3).

Oooh, that's useful to know. We can get rid of all our extra nulls
indexes. Thanks.

Matthew

--
As you approach the airport, you see a sign saying "Beware - low
flying airplanes". There's not a lot you can do about that. Take
your hat off? -- Michael Flanders

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Joshua Tolley 2008-11-12 13:54:05 Re: Index usage with sub select or inner joins
Previous Message Julien Theulier 2008-11-12 13:22:47 Index usage with sub select or inner joins