Jim Nasby <Jim.Nasby@xxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
