Jim Nasby <jim.na...@bluetreble.com> writes:
> On 12/31/15 9:02 AM, Tom Lane wrote:
>> If you don't want to rebuild the whole database, you can create indexes to
>> support this by declaring them with COLLATE "C", or the older way is to
>> declare them with text_pattern_ops as the index opclass.
> Do you have to do anything special in the query itself for COLLATE "C"
> to work?
No.
> I didn't realize the two methods were equivalent.
Well, they're not equivalent exactly, but indxpath.c knows that either
way produces an index that will work for LIKE.
regards, tom lane
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
