"Herouth Maoz" <hero...@unicell.co.il> writes:
> So, I must, at this point, draw the conclusion that string comparison is a
> much, much heavier task in utf-8 than it is in an 8-bit encoding - or that
> the collation is the problem.
Going from "C" collation to anything else is generally a huge hit in
terms of string comparison/sorting performance. Do you really need
locale-aware sorting, or just enforcement of utf8 encoding? Because you
can use "C" locale with any encoding.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
