> Tatsuo Ishii <[EMAIL PROTECTED]> writes: > > ... There seems some problems existing in the > > implementation. Considering REGEX is not so slow, maybe we should > > employ the same design as REGEX. i.e. using wide charcters, not > > multibyte streams... > > Seems like a good thing to put on the to-do list. In the meantime, > we still have the question of whether to enable multibyte in the > default configuration. I'd still vote YES, as these results seem > to me to demonstrate that there is no wide-ranging performance penalty. > A problem confined to LIKE on long strings isn't a showstopper IMHO. >
Added to TODO: * Use wide characters to evaluate regular expressions, for performance (Tatsuo) -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org