[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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to