Re: Index on a NULL-value

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Index on a NULL-value
Дата
Msg-id 8324.1117516366@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Index on a NULL-value  (Greg Stark <gsstark@mit.edu>)
Список pgsql-performance
Greg Stark <gsstark@mit.edu> writes:
> then it would be a candidate because the ORDER BY or the other > 0 make the
> index look relevant. But I don't think (again I'm not 100% sure) that the
> partial index WHERE clause is considered in picking which indexes to consider.

Nope, the partial index will be considered simply on the strength of its
predicate matching the WHERE clause.

Of course, if you can get some additional mileage by having the index
contents be useful, that's great --- but it's not necessary.

            regards, tom lane

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

Предыдущее
От: Greg Stark
Дата:
Сообщение: Re: Index on a NULL-value
Следующее
От: Tobias Brox
Дата:
Сообщение: Re: Index on a NULL-value