Postgres Pro
Downloads
Home   >   mailing lists

Re: LIKE optimization in UTF-8 and locale-C - Mailing list pgsql-hackers

From Andrew - Supernews
Subject Re: LIKE optimization in UTF-8 and locale-C
Date
Msg-id slrnf06rqv.7me.andrew+nonews@atlantis.supernews.net
Whole thread Raw
In response to Re: LIKE optimization in UTF-8 and locale-C  (ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>)
Responses Re: LIKE optimization in UTF-8 and locale-C  (Hannu Krosing <hannu@skype.net>)
List pgsql-hackers
Tree view 
On 2007-03-23, ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp> wrote:
> Thanks, it all made sense to me. My proposal was completely wrong.

Actually, I think your proposal is fundamentally correct, merely incomplete.

Doing octet-based rather than character-based matching of strings is a
_design goal_ of UTF8. Treating UTF8 like any other multibyte charset and
converting everything to wide-chars is, in my opinion, always going to
result in suboptimal performance.

-- 
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services

pgsql-hackers by date:

Previous
From: Andrew - Supernews
Date:
Subject: Re: LIKE optimization in UTF-8 and locale-C
Next
From: Hannu Krosing
Date:
Subject: Re: CREATE INDEX and HOT - revised design