Hi, Laurenz ! Thanks for the reply !
I agree that 'Server Setup and Operation' is the best place for the proposed changes. On the other hand it should not be only for PG20, but rather for all previous PG versions too. About the structure: - first, we should refer to Locale Providers <https://www.postgresql.org/docs/current/locale.html#LOCALE-PROVIDERS> chapter - then mention that icu/libc locale providers are backed by libicu/glibc libraries which versions might change from time to time (even within the lifecycle of the same major version of OS) - libicu/glibc version changes might lead to changes of SQL-queries which use affected indexes, so it's important to keep an eye on such changes - the next item should describe what to do in case of libicu/glibc version changes - mainly about rebuilding the indexes, but not only - finally, we should provide the list of commands to identify affected indexes, to rebuild them online/offline, concurrently etc. Pls. feel free to propose the changes to this structure. best regards, Alexey Shishkin *Alexey Shishkin* Technical Account Manager EDB Software GmbH [email protected] www.enterprisedb.com <https://enterprisedb.com/> Planned PTO: Nov-04 - Nov-08 On Tue, Oct 27, 2026 at 9:27 PM Laurenz Albe <[email protected]> wrote: > On Tue, 2026-10-27 at 09:49 +0100, Alexey Shishkin wrote: > > > > It looks like the PostgreSQL documentation doesn't explain the > customers > > > > what to do with PostgreSQL in case of OS system version upgrade > or/and glibc > > > > / libicu version change. > > > > > > > > So, my proposal to dedicate a chapter in the PostgreSQL > documentation about > > > > the topic. > > > > Any news about the subject ? > > > > I think it's the right time to prepare such chapter in order to have it > in PG19 documentation. > > It might be a little late for v19, but not for v20. > > I agree that it might be good to have some mention of this > in the documentation, but I am not sure what would be a good > place. On the one hand, this could be somewhere under > "Localization", but I guess that nobody would look for it there. > > A good place could be a chapter in "Server Setup and Operation", > and my personal recommendation is to create clusters with the > C locale. > > If you want to get that moving, how about proposing a patch? > > Yours, > Laurenz Albe >
