| From: | Scott Ribe <scott_ribe(at)elevated-dev(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | ram pratap maurya <rampratap0000(at)gmail(dot)com>, paul(dot)foerster(at)gmail(dot)com, pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: RHEL OS upgrade from 6.7 (Current version) to 8 version for Postgresql database |
| Date: | 2021-03-19 16:48:25 |
| Message-ID: | 54D63B98-4D39-4BA5-B37E-381DC3F51E76@elevated-dev.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
> On Mar 19, 2021, at 8:19 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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*
| From | Date | Subject | |
|---|---|---|---|
| Next Message | MichaelDBA | 2021-03-19 17:18:17 | Re: RHEL OS upgrade from 6.7 (Current version) to 8 version for Postgresql database |
| Previous Message | Tom Lane | 2021-03-19 14:19:57 | Re: RHEL OS upgrade from 6.7 (Current version) to 8 version for Postgresql database |