Re: Partial index slower than regular index

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Partial index slower than regular index
Дата
Msg-id 6664.1302158249@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: 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:
> On 6 April 2011 05:44, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> 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.

> Testing it again with very explicit collations, it still has issues:

Yeah, any sort of collation-sensitive operator in an index WHERE clause
was just plain broken.  Fixed now.

            regards, tom lane

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

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: Intel SSDs that may not suck
Следующее
От: Thom Brown
Дата:
Сообщение: Re: Partial index slower than regular index