Postgres Pro
Downloads
Home   >   mailing lists

(collation) Building postgresql on FreeBSD, the pros and cons of icu - Mailing list pgsql-general

From Patrick Dung
Subject (collation) Building postgresql on FreeBSD, the pros and cons of icu
Date
Msg-id 1382535664.17242.YahooMailNeo@web193504.mail.sg3.yahoo.com
Whole thread Raw
Responses Re: (collation) Building postgresql on FreeBSD, the pros and cons of icu
List pgsql-general
Tree view
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

pgsql-general by date:

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