Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Using index for IS NULL query
Date
Msg-id 12244.1226436315@sss.pgh.pa.us
Whole thread Raw
In response to Using index for IS NULL query  ("Andrus" <kobruleht2@hot.ee>)
Responses Re: Using index for IS NULL query
Re: Using index for IS NULL query
List pgsql-performance
Tree view 
"Andrus" <kobruleht2@hot.ee> writes:
> Index is not used for
>  is null

> How to fix ?

Update to something newer than 8.1 (specifically, you'll need 8.3).

            regards, tom lane

pgsql-performance by date:

Previous
From: "Andrus"
Date:
Subject: Using index for IS NULL query
Next
From: Andreas Kretschmer
Date:
Subject: Re: Using index for IS NULL query