On Thu, Feb 25, 2021 at 6:47 PM Ганиев Ильяс <family-...@yandex.ru> 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