Postgres Pro
Downloads
Home   >   mailing lists

Re: Using index for IS NULL query - Mailing list pgsql-performance

From Matthew Wakeling
Subject Re: Using index for IS NULL query
Date
Msg-id alpine.DEB.1.10.0811121327550.4666@aragorn.flymine.org
Whole thread Raw
In response to Re: Using index for IS NULL query  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Oddity with view (now with test case)
Next
From: "Julien Theulier"
Date:
Subject: Index usage with sub select or inner joins