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 -- Regards, Peter Geoghegan -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
