Re: Partial index slower than regular index

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Thom Brown <thom(at)linux(dot)com>
Cc: pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Partial index slower than regular index
Date: 2011-04-07 06:37:29
Message-ID: 6664.1302158249@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Thom Brown <thom(at)linux(dot)com> writes:
> On 6 April 2011 05:44, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Thom Brown 2011-04-07 07:10:14 Re: Partial index slower than regular index
Previous Message Greg Smith 2011-04-07 05:48:26 Re: Intel SSDs that may not suck