ITAGAKI Takahiro <[EMAIL PROTECTED]> writes: > I found LIKE operators are slower on multi-byte encoding databases > than single-byte encoding ones. It comes from difference between > MatchText() and MBMatchText().
> We've had an optimization for single-byte encodings using > pg_database_encoding_max_length() == 1 test. I'll propose to extend it > in UTF-8 with locale-C case. If this works for UTF8, won't it work for all the backend-legal encodings? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org