"Kevin Grittner" <Kevin.Grittner@xxxxxxxxxxxx> writes: > We have been using the C locale for everything at our site, but > there is occasionally talk of supporting characters outside the > ASCII7 set. In playing around with indexing, to see what the impact > of that would be, I stumbled across something which was mildly > surprising. > In the C locale, if you want to search for an exact value which > doesn't contain wildcard characters, it doesn't matter whether you > use the 'LIKE' operator or the '=' operator. With LATIN1 encoding, > it made three orders of magnitude difference, both in the estimated > cost and the actual run time. What PG version are you testing? 8.4 and up should know that an exact-match pattern can be optimized regardless of the lc_collate setting. 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
