Peter Eisentraut <pete...@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
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
