Re: [HACKERS] Implications of multi-byte support in a distribution - Mailing list pgsql-hackers

From Oleg Bartunov
Subject Re: [HACKERS] Implications of multi-byte support in a distribution
Date
Msg-id Pine.GSO.3.96.SK.990831155206.6807H-100000@ra
Whole thread Raw
In response to Re: [HACKERS] Implications of multi-byte support in a distribution  (Tatsuo Ishii <t-ishii@sra.co.jp>)
Responses Re: [HACKERS] Implications of multi-byte support in a distribution
List pgsql-hackers
On Tue, 31 Aug 1999, Tatsuo Ishii wrote:

> Date: Tue, 31 Aug 1999 18:29:21 +0900
> From: Tatsuo Ishii <t-ishii@sra.co.jp>
> To: Thomas Lockhart <lockhart@alumni.caltech.edu>
> Cc: Oliver Elphick <olly@lfix.co.uk>, hackers@postgresql.org,
>     43702@bugs.debian.org
> Subject: Re: [HACKERS] Implications of multi-byte support in a distribution 
> 
> >> I have had a request to add multi-byte support to the Debian binary
> >> packages of PostgreSQL.
> >> Since I live in England, I have personally no need of this and therefore
> >> have little understanding of the implications.
> >> If I change the packages to use multi-byte support, (UNICODE (UTF-8) is
> >> suggested as the default), will there be any detrimental effects on the
> >> fairly large parts of the world that don't need it?  Should I try to
> >> provide two different packages, one with and one without MB support?
> >
> >Probably. The downside to having MB support is reduced performance and
> >perhaps functionality. If you don't need it, don't build it...
> 
> Not really. I did the regression test with/without multi-byte enabled.
> 
> with MB:    2:53:92 elapsed
> w/o MB:        2:52.92 elapsed
> 
> Perhaps the worst case for MB would be regex ops. If you do a lot of
> regex queries, performance degration might not be neglectable.

It should be. What would be nice is to have a column-specific
MB support. But I doubt if it's possible.

> 
> Load module size:
> 
> with MB:    1208542
> w/o MB:        1190925
> 
> (difference is 17KB)
> 
> Talking about the functionality, I don't see any missing feature with
> MB comparing w/o MB. (there are some features only MB has. for
> example, SET NAMES).
> --
> Tatsuo Ishii
> 
> ************
> 

_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83



pgsql-hackers by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: [HACKERS] Implications of multi-byte support in a distribution
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] optimizer pruning problem