Re: Partial Indexes condtions

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Partial Indexes condtions
Дата
Msg-id 23634.1060784130@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Partial Indexes condtions  ("Donald Fraser" <demolish@cwgsy.net>)
Список pgsql-bugs
"Donald Fraser" <demolish@cwgsy.net> writes:
> Not sure whether you classify this as a bug or not?

It's a bug --- it's fixed for 7.4.  7.3 has some problems with the
timing of constant simplification in queries vs. predicate expressions.

I'm surprised you can get it to use the index at all, though, since the
system is going to think a condition involving <> is quite unselective.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Slow Query
Следующее
От: Bertrand Petit
Дата:
Сообщение: 7.4 beta 1: SET log_statement=false