Re: Pg_upgrade and collation - Mailing list pgsql-docs

From Alvaro Herrera
Subject Re: Pg_upgrade and collation
Date
Msg-id 20160628225015.GA82106@alvherre.pgsql
Whole thread Raw
In response to Re: Pg_upgrade and collation  (Peter Geoghegan <pg@bowt.ie>)
Responses Re: Pg_upgrade and collation
List pgsql-docs
Peter Geoghegan wrote:

> The best argument for ICU is the evidently lax attitude that the glibc
> people have towards the correctness and consistency of their
> collations:
>
> https://bugzilla.redhat.com/show_bug.cgi?id=1320356#c3
>
> Here, Carlos O'Donnell, a glic committer, says "Regarding (b), the
> collations in glibc may change from build to build depending on
> changes in the algorithms or locales. You cannot rely on the collation
> stay the same once the process exits (nor can you rely upon it via a
> shared memory mapping to another process sorting strings in memory)".
> Frankly, we have no excuse for not heeding his warning.
>
> I'm not annoyed at the glibc people for taking this position. There
> is, quite simply, a misalignment of incentives. For the glibc people,
> the assumption is that any problem with collations leads only to
> slight annoyance from end users, as when the GUI produces subtly wrong
> ordering. Whereas, for us, any inconsistency is an extremely serious
> problem. Here we have the maintainers of glibc telling us that they
> feel like it's okay that that can happen at any time. Surely that
> isn't good enough.

Uhmm.  Until now I saw all this ICU thing as having fringe benefit on
strange platforms only, but it is seeming more and more like we need to
take it seriously.  I'm not prepared to spend effort on it myself,
though.

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


pgsql-docs by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: Pg_upgrade and collation
Next
From: Peter Geoghegan
Date:
Subject: Re: Pg_upgrade and collation