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 4331.1302065062@sss.pgh.pa.us
Whole thread Raw
In response to 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:
> 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 by date:

Previous
From: Mark Kirkwood
Date:
Subject: Re: Partial index slower than regular index
Next
From: Greg Smith
Date:
Subject: Re: Which is better Index