Re: Partial index slower than regular index

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