> 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

In response to

• Re: Unicode combining characters at 2001-10-02 01:23:18 from Bruce Momjian

Responses

• Re: Unicode combining characters at 2001-10-02 16:31:40 from Bruce Momjian
• Re: Unicode combining characters at 2001-10-02 22:14:16 from Peter Eisentraut

pgsql-hackers by date

Next:	From: Dave Page	Date: 2001-10-02 07:45:19
	Subject: pgAdmin users upgrading to PostgreSQL 7.2
Previous:	From: James L. Hubbard III	Date: 2001-10-02 06:06:30
	Subject: Genetic Query Optimizer