Re: Testing 9.2 in ~production environment

Peter Eisentraut <peter_e@gmx.net> writes:
> On tis, 2012-06-19 at 02:38 -0400, Tom Lane wrote:
>> If James is testing text-comparison-heavy operations, it doesn't seem
>> shocking in the least.  strcoll() in most non-C locales is a pig. 

> Ah yes, of course, having lc_ctype != C also selects strcoll instead of
> strcmp.

Come to think of it, another possible factor is that LIKE can't use
ordinary indexes on text if the locale isn't C.
        regards, tom lane