Re: Need to increase performance of a query - Mailing list pgsql-performance

From Anne Rosset
Subject Re: Need to increase performance of a query
Date
Msg-id 4C11463B.7080608@collab.net
Whole thread Raw
In response to Re: Need to increase performance of a query  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Responses Re: Need to increase performance of a query  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
List pgsql-performance
Heikki Linnakangas wrote:
> On 10/06/10 22:47, Craig James wrote:
>> Postgres normally doesn't index NULL values even if the column is
>> indexed, so it has to do a table scan when your query includes an IS
>> NULL condition.
>
> That was addressed in version 8.3. 8.3 and upwards can use an index
> for IS NULL.
>
> I believe the NULLs were stored in the index in earlier releases too,
> they just couldn't be searched for.
>
I am using postgres 8.3.6. So why doesn't it use my index?
Thanks,
Anne

pgsql-performance by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Need to increase performance of a query
Next
From: Joe Conway
Date:
Subject: Re: Need to increase performance of a query