Re: Unicode combining characters
От | Tatsuo Ishii |
---|---|
Тема | Re: Unicode combining characters |
Дата | |
Msg-id | 20011002154952Y.t-ishii@sra.co.jp обсуждение исходный текст |
Ответ на | Re: Unicode combining characters (Bruce Momjian <pgman@candle.pha.pa.us>) |
Ответы |
Re: Unicode combining characters
Re: Unicode combining characters |
Список | pgsql-hackers |
> Also, have we decided if multibyte should be the configure default now? Not sure. Anyway I have tested LIKE/REGEX query test using current. The query executed is: explain analyze select '0000000 5089 474e...( 16475 bytes long text containing only 0-9a-z chars) like 'aaa'; and explain analyze select '0000000 5089 474e...( 16475 bytes long text containing only 0-9a-z chars) ~ 'aaa'; Here is the result: no MB with MB LIKE 0.09 msec 0.08 msec REGEX 0.09 msec 0.10 msec LIKE with MB seemed to be resonably fast, but REGEX with MB seemed a little bit slow. Probably this is due the wide character conversion overhead. -- Tatsuo Ishii
В списке pgsql-hackers по дате отправления: