Re: Using index for IS NULL query

От: Tom Lane
Тема: Re: Using index for IS NULL query
Дата: ,
Msg-id: 12244.1226436315@sss.pgh.pa.us
(см: обсуждение, исходный текст)
Ответ на: Using index for IS NULL query  ("Andrus")
Ответы: Re: Using index for IS NULL query  (Andreas Kretschmer)
Re: Using index for IS NULL query  (Matthew Wakeling)
Список: pgsql-performance

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

Using index for IS NULL query  ("Andrus", )
 Re: Using index for IS NULL query  (Tom Lane, )
  Re: Using index for IS NULL query  (Andreas Kretschmer, )
  Re: Using index for IS NULL query  (Matthew Wakeling, )
 Re: Using index for IS NULL query  (Andreas Kretschmer, )
 Re: Using index for IS NULL query  (Tomas Vondra, )
  Re: Using index for IS NULL query  ("Vladimir Sitnikov", )
   Re: Using index for IS NULL query  ("Scott Marlowe", )
   Re: Using index for IS NULL query  (Tomas Vondra, )
  Index usage with sub select or inner joins  ("Julien Theulier", )
   Re: Index usage with sub select or inner joins  (Joshua Tolley, )
    Re: Index usage with sub select or outer joins  ("Julien Theulier", )

"Andrus" <> 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 по дате сообщения:

От: Tom Lane
Дата:
Сообщение: Re: Oddity with view (now with test case)
От: Matthew Wakeling
Дата:
Сообщение: Re: Using index for IS NULL query