Re: Index on a NULL-value

От: Tobias Brox
Тема: Re: Index on a NULL-value
Дата: ,
Msg-id: 20050531034529.GJ26100@tobias.exoweb.net
(см: обсуждение, исходный текст)
Ответ на: Re: Index on a NULL-value  (Bruno Wolff III)
Ответы: Re: Index on a NULL-value  (Greg Stark)
Список: 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, )

[Bruno Wolff III - Mon at 10:36:33PM -0500]
> You want something like this:
> CREATE INDEX b_is_null ON mock(b) WHERE b IS NULL;

Oh, cool.  I wasn't aware that this is possible.  This would probably help
us a lot of places. :-)

--
Tobias Brox, Beijing


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

От: "Praveen Raja"
Дата:
Сообщение: very large table
От: Dirk Lutzebäck
Дата:
Сообщение: SURVEY: who is running postgresql on 8 or more CPUs?