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-06 04:44:22
Message-ID: 4331.1302065062@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:
> 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Greg Smith 2011-04-06 06:55:29 Re: Which is better Index
Previous Message Mark Kirkwood 2011-04-06 02:03:53 Re: Partial index slower than regular index