Re: Index on a NULL-value

От: Tobias Brox
Тема: Re: Index on a NULL-value
Дата: ,
Msg-id: 20050601054251.GT26100@tobias.exoweb.net
(см: обсуждение, исходный текст)
Ответ на: Index on a NULL-value  (Tobias Brox)
Список: pgsql-performance

Скрыть дерево обсуждения

Index on a NULL-value  (Tobias Brox, )
 Re: Index on a NULL-value  (Bruno Wolff III, )
  Re: Index on a NULL-value  (Tobias Brox, )
   Re: Index on a NULL-value  (Bruno Wolff III, )
 Re: Index on a NULL-value  (Tobias Brox, )
  Re: Index on a NULL-value  (Bruno Wolff III, )
   Re: Index on a NULL-value  (Tobias Brox, )
    Re: Index on a NULL-value  (Greg Stark, )
     Re: Index on a NULL-value  (Tom Lane, )
   Re: Index on a NULL-value  (Tom Lane, )
    Re: Index on a NULL-value  (Tobias Brox, )
 Re: Index on a NULL-value  (Tobias Brox, )

[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


В списке pgsql-performance по дате сообщения:

От: "Martin Fandel"
Дата:
Сообщение: Re: postgresql-8.0.1 performance tuning
От: Alvaro Herrera
Дата:
Сообщение: Re: TIP 9: the planner will ignore... & datatypes