Thom Brown <thom@xxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
