Re: Unicode combining characters - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Unicode combining characters
Date
Msg-id 200110032227.f93MRll24126@candle.pha.pa.us
Whole thread Raw
In response to Re: Unicode combining characters  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
> Tom Lane writes:
> 
> > In the meantime, we still have the question of whether to enable
> > multibyte in the default configuration.
> 
> This would make more sense if all of multibyte, locale, and NLS became
> defaults in one release.  I haven't quite sold people in the second item
> yet, although I have a design how to do that (see below).  And the third,
> well who knows...
> 
> Perhaps we could make it a release goal for 7.3 to
> 
> * Optimize i18n stuff to have a minimal performance penalty when it's not
>   used. (locale=C etc.)
> 
> * Make i18n stuff sufficiently well-behaved to make it the default.
>   (Especially, add initdb options and GUC parameters to set the locale.
>   Don't rely on environment variables -- too complicated.)
> 
> Meanwhile, quadratic performance penalties (or so it seems) for LIKE
> expressions aren't exactly a "minor" problem.
> 

Added to TODO:

* Optimize locale to have minimal performance impact when not used
(Peter E)
--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG: text(varchar) truncates at 31 bytes
Next
From: Martín Marqués
Date:
Subject: Re: Missing inserts