Peter Eisentraut <peter_e(at)gmx(dot)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