On Fri, Mar 20, 2015 at 5:54 AM, Peter Geoghegan <peter.geoghegan86@xxxxxxxxx> wrote: > On Wed, Mar 18, 2015 at 11:03 PM, Haribabu Kommi > <kommi.haribabu@xxxxxxxxx> wrote: >> For our next set of development activities in PostgreSQL, we want to >> use the Unicode organization code with PostgreSQL to open source that >> feature. Is the Unicode license is compatible with PostgreSQL. > > Do you mean that you'd like to add ICU support? I think that would be > extremely interesting, FWIW. The stability of ICU collations would be > quite helpful from a number of different perspective. One of which is > that having a contract about the stability of strxfrm()-style binary > keys would allow me to make text abbreviated keys exploited in the > internal pages of B-Tree indexes, to greatly reduce cache misses with > index scans on text attributes. This general technique already been > very effective with sorting [1], but it feels likely that we'll need > ICU to make the abbreviation technique useful for indexes. > > [1] http://pgeoghegan.blogspot.com/2015/01/abbreviated-keys-exploiting-locality-to.html Hi All, Thanks for the information. we are just evaluating some conversion algorithms to convert from UTF32/16 to UTF8 and vice versa. Regards, Hari Babu Fujitsu Australia -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
