(collation) Building postgresql on FreeBSD, the pros and cons of icu

From: Patrick Dung <patrick_dkt(at)yahoo(dot)com(dot)hk>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: (collation) Building postgresql on FreeBSD, the pros and cons of icu
Date: 2013-10-23 13:41:04
Message-ID: 1382535664.17242.YahooMailNeo@web193504.mail.sg3.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

By default, FreeBSD ports does not build postgresql with icu (http://www.icu-project.org/)

Some questions:

1) It is necessary that icu should be used on FreeBSD?
I have heard that FreeBSD's locale (glibc) has sorting problem with Postgresql UTF8 DB.
reference: http://wiki.postgresql.org/wiki/Todo:ICU

2) After searching in google, it was said that using ICU is faster (in terms of sorting in locale).

3) Any other pros and cons?

Thanks,
Patrick

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2013-10-23 13:44:49 Re: (collation) Building postgresql on FreeBSD, the pros and cons of icu
Previous Message Rémi Cura 2013-10-23 08:39:52 Re: [postgis-users] Error with "return query" ( "return next" working ) with custom type