Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 14.0 \(3654.60.0.2.21\))
Subject: Re: RHEL OS upgrade from 6.7 (Current version) to 8 version for
 Postgresql database
From: Scott Ribe <scott_ribe@elevated-dev.com>
In-Reply-To: <4058401.1616163597@sss.pgh.pa.us>
Date: Fri, 19 Mar 2021 10:48:25 -0600
Cc: ram pratap maurya <rampratap0000@gmail.com>,
 paul.foerster@gmail.com,
 pgsql-admin@lists.postgresql.org
Content-Transfer-Encoding: quoted-printable
Message-Id: <54D63B98-4D39-4BA5-B37E-381DC3F51E76@elevated-dev.com>
References: 
 <CAAiDzSfzh2Ms-GYqbHfPcWGdfGEJT8ObQQp+rvYPS7+82HB+uw@mail.gmail.com>
 <4058401.1616163597@sss.pgh.pa.us>
To: Tom Lane <tgl@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/54D63B98-4D39-4BA5-B37E-381DC3F51E76%40elevated-dev.com>
Precedence: bulk

> On Mar 19, 2021, at 8:19 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>=20
> 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*