Re: Partial index slower than regular index - Mailing list pgsql-performance

From Tom Lane
Subject Re: Partial index slower than regular index
Date
Msg-id 6664.1302158249@sss.pgh.pa.us
Whole thread Raw
In response to Re: Partial index slower than regular index  (Thom Brown <thom@linux.com>)
Responses Re: Partial index slower than regular index  (Thom Brown <thom@linux.com>)
List 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 by date:

Previous
From: Greg Smith
Date:
Subject: Re: Intel SSDs that may not suck
Next
From: Thom Brown
Date:
Subject: Re: Partial index slower than regular index