Re: Using index for IS NULL query

Поиск
Список
Период
Сортировка
От Matthew Wakeling
Тема Re: Using index for IS NULL query
Дата
Msg-id alpine.DEB.1.10.0811121327550.4666@aragorn.flymine.org
обсуждение исходный текст
Ответ на Re: Using index for IS NULL query  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
On Tue, 11 Nov 2008, Tom Lane wrote:
>> Index is not used for
>>  is null
>> How to fix ?
>
> Update to something newer than 8.1 (specifically, you'll need 8.3).

Oooh, that's useful to know. We can get rid of all our extra nulls
indexes. Thanks.

Matthew

--
As you approach the airport, you see a sign saying "Beware - low
flying airplanes". There's not a lot you can do about that. Take
your hat off?                                  -- Michael Flanders

В списке pgsql-performance по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Oddity with view (now with test case)
Следующее
От: "Julien Theulier"
Дата:
Сообщение: Index usage with sub select or inner joins