On Thu, Feb 25, 2021 at 6:47 PM Ганиев Ильяс wrote:
>
> I had an Ubuntu 18.04.0 with Postgres 9.6.
>
> Before Ubuntu upgrade following command result was:
>
> vodka@ubuntu140:~$ ( echo "1-1"; echo "11" ) | LC_COLLATE=en_US.UTF-8 sort
> 1-1
> 11
>
> But after upgrading Ubuntu 18.04 to latest release via apt upgrade (18.04.5)
> result of the command above totally changed:
>
> vodka@ubuntu140:~$ ( echo "1-1"; echo "11" ) | LC_COLLATE=en_US.UTF-8 sort
> 11
> 1-1
>
> Due to this our production Postgres database started work very slowly and we
> had a long downtime for REINDEX. Sorting method is very important for
> Postgres database: https://wiki.postgresql.org/wiki/Locale_data_changes
>
> Please, read "Testing collation" part.
>
> Is it normal behavior for Ubuntu? Why glibc totally changed within LTS
> release without 'major upgrade'? I did not expect this...
Hi,
this has been filed and discussed here:
https://bugs.launchpad.net/ubuntu/+source/base-files/+bug/1916935
I'd ask you to read (and write if you have more to add) there for
further progress on this.
> --
> Ubuntu-devel-discuss mailing list
> Ubuntu-devel-discuss@lists.ubuntu.com
> Modify settings or unsubscribe at:
> https://lists.ubuntu.com/mailman/listinfo/ubuntu-devel-discuss
--
Christian Ehrhardt
Staff Engineer, Ubuntu Server
Canonical Ltd
--
Ubuntu-devel-discuss mailing list
Ubuntu-devel-discuss@lists.ubuntu.com
Modify settings or unsubscribe at:
https://lists.ubuntu.com/mailman/listinfo/ubuntu-devel-discuss