Re: Index on a NULL-value

From: Tobias Brox <tobias(at)nordicbet(dot)com>
To: Tobias Brox <tobias(at)nordicbet(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Index on a NULL-value
Date: 2005-06-01 05:42:51
Message-ID: 20050601054251.GT26100@tobias.exoweb.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

[Tobias Brox - Tue at 11:02:07AM +0800]
> I read in the manual today:
>
> Indexes are not used for IS NULL clauses by default. The best way to use
> indexes in such cases is to create a partial index using an IS NULL
> predicate.

I have summarized this thread in a postgresql doc user comment, posted at
http://www.postgresql.org/docs/current/interactive/sql-createindex.html

I think it's a good thing to do, since it can be difficult to search the
mailing list archives :-)

--
Tobias Brox, Beijing

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Mark Kirkwood 2005-06-01 06:33:22 Re: postgresql-8.0.1 performance tuning
Previous Message Cosimo Streppone 2005-06-01 05:30:37 Re: postgresql-8.0.1 performance tuning