From: Scott Ribe <scott_ribe@elevated-dev.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: ram pratap maurya <rampratap0000@gmail.com>
Cc: paul.foerster@gmail.com
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: RHEL OS upgrade from 6.7 (Current version) to 8 version for Postgresql database
Date: Fri, 19 Mar 2021 10:48:25 -0600
Message-ID: <54D63B98-4D39-4BA5-B37E-381DC3F51E76@elevated-dev.com> (raw)
In-Reply-To: <4058401.1616163597@sss.pgh.pa.us>
References: <CAAiDzSfzh2Ms-GYqbHfPcWGdfGEJT8ObQQp+rvYPS7+82HB+uw@mail.gmail.com>
<4058401.1616163597@sss.pgh.pa.us>
> On Mar 19, 2021, at 8:19 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> RHEL8 incorporates new locale data [1]. This means that non-English
> text is rather likely to sort differently than it did before
I *think* I saw that random uuid-style strings of alphanumerics and underscores or dashes also sorted differently. I didn't stop to take time to definitively verify that, but just kept on with re-indexing as quickly as possible. But I definitely saw symptoms of corrupted indexes until the reindex completed, and they appeared with the OS upgrade, not before, *as far as I know*
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scott_ribe@elevated-dev.com, tgl@sss.pgh.pa.us, rampratap0000@gmail.com, paul.foerster@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: RHEL OS upgrade from 6.7 (Current version) to 8 version for Postgresql database
In-Reply-To: <54D63B98-4D39-4BA5-B37E-381DC3F51E76@elevated-dev.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox