Re: Partial index slower than regular index

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Partial index slower than regular index
Дата
Msg-id 4331.1302065062@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Partial index slower than regular index  (Thom Brown <thom@linux.com>)
Ответы Re: Partial index slower than regular index  (Thom Brown <thom@linux.com>)
Список pgsql-performance
Thom Brown <thom@linux.com> writes:
> The index doesn't get used.  There's probably a logical explanation,
> which is what I'm curious about.

Er ... it's broken?

It looks like the index predicate expression isn't getting the right
collation assigned, so predtest.c decides the query doesn't imply the
index's predicate.  Too tired to look into exactly why right now, but
it's clearly bound up in all the recent collation changes.

            regards, tom lane

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

Предыдущее
От: Mark Kirkwood
Дата:
Сообщение: Re: Partial index slower than regular index
Следующее
От: Greg Smith
Дата:
Сообщение: Re: Which is better Index