MIME-Version: 1.0
References: <B927CE6F-0A36-4237-BD4D-75CD609F3E89@gmail.com>
 <20240919174349.grrz4w25jmxfk77a@hjp.at> <58CD40AA-6316-40B6-89C2-390D16FF5FA0@gmail.com>
 <20240920223316.muvdgqekzh6dvcii@hjp.at> <DA5B67BD-F5EB-4566-B8C4-AFBBB0753CF4@gmail.com>
 <b281ad68-efb5-40d3-b03b-5d7c1e111914@joeconway.com> <CAHAc2jdOR=MRKW9=a7AUcFvViXOQDXKHp_FLzSLstLy=_voYqQ@mail.gmail.com>
In-Reply-To: <CAHAc2jdOR=MRKW9=a7AUcFvViXOQDXKHp_FLzSLstLy=_voYqQ@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Sun, 22 Sep 2024 10:11:00 -0400
Message-ID: <CANzqJaDqUTrm4f-UxK1A3=uk24wbYCW==t8xp=t0nRwu6vcKiA@mail.gmail.com>
Subject: Re: glibc updarte 2.31 to 2.38
To: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000002f15d60622b5d820"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaDqUTrm4f-UxK1A3%3Duk24wbYCW%3D%3Dt8xp%3Dt0nRwu6vcKiA%40mail.gmail.com>
Precedence: bulk

--0000000000002f15d60622b5d820
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Shaheed,

How often do you sort words in text editors?
How often do you have your text editor care whether the word you just typed
is the *only* instance of that word in the document?

Not too often.  So... yes, we ignore the problem.

The real question is why nobody notices it in other RDBMSs like Oracle, SQL
Server and MySQL.

On Sun, Sep 22, 2024 at 9:59=E2=80=AFAM Shaheed Haque <shaheedhaque@gmail.c=
om>
wrote:

> I've been working on Unix-like systems for decades and though I thought I
> understood most of the issues to do with i18n/l10n, I've only just starte=
d
> using Postgres and I don't understand is why these changes ONLY seem to
> affect Postgres. Or is it more that it also affects text editors and the
> like, but we just tend to ignore that?
>
> On Sun, 22 Sep 2024, 14:47 Joe Conway, <mail@joeconway.com> wrote:
>
>> On 9/21/24 15:19, Paul Foerster wrote:
>> > I already expressed the idea of changing all locales to ICU. The
>> > problem there is that I'd have to create new instances and then move
>> > each database individually. I wish I could convert already running
>> > databases=E2=80=A6 This also takes time. Still, I think I'm going to t=
ry
>> > this route. It's always a gamble if reindexing is needed or not with
>> > any glibc change.
>>
>>
>> Note that moving to ICU might improve things, but there are similar
>> potential issues with ICU as well. The trick there would be to get your
>> OS distro provider to maintain the same ICU version across major
>> versions of the distro, which is not the case currently. Nor does the
>> PGDG repo do that.
>>
>>
>> --
>> Joe Conway
>> PostgreSQL Contributors Team
>> RDS Open Source Databases
>> Amazon Web Services: https://aws.amazon.com
>>
>>
>>

--=20
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> crustacean!

--0000000000002f15d60622b5d820
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Shaheed,</div><div><br></div><div>How often do you so=
rt words in text editors?</div><div>How often do you have your text editor =
care whether the word you just typed is the <b>only</b>=C2=A0instance of th=
at word in the document?</div><div><br></div><div>Not too often.=C2=A0 So..=
. yes, we ignore the problem.</div><div><br></div><div>The real question is=
 why nobody notices it in other RDBMSs like Oracle, SQL Server and MySQL.</=
div><div dir=3D"ltr"><br></div><div class=3D"gmail_quote"><div dir=3D"ltr" =
class=3D"gmail_attr">On Sun, Sep 22, 2024 at 9:59=E2=80=AFAM Shaheed Haque =
&lt;<a href=3D"mailto:shaheedhaque@gmail.com">shaheedhaque@gmail.com</a>&gt=
; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px=
 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><p dir=
=3D"ltr">I&#39;ve been working on Unix-like systems for decades and though =
I thought I understood most of the issues to do with i18n/l10n, I&#39;ve on=
ly just started using Postgres and I don&#39;t understand is why these chan=
ges ONLY seem to affect Postgres. Or is it more that it also affects text e=
ditors and the like, but we just tend to ignore that? </p>
<br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Sun=
, 22 Sep 2024, 14:47 Joe Conway, &lt;<a href=3D"mailto:mail@joeconway.com" =
target=3D"_blank">mail@joeconway.com</a>&gt; wrote:<br></div><blockquote cl=
ass=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid=
 rgb(204,204,204);padding-left:1ex">On 9/21/24 15:19, Paul Foerster wrote:<=
br>
&gt; I already expressed the idea of changing all locales to ICU. The<br>
&gt; problem there is that I&#39;d have to create new instances and then mo=
ve<br>
&gt; each database individually. I wish I could convert already running<br>
&gt; databases=E2=80=A6 This also takes time. Still, I think I&#39;m going =
to try<br>
&gt; this route. It&#39;s always a gamble if reindexing is needed or not wi=
th<br>
&gt; any glibc change.<br>
<br>
<br>
Note that moving to ICU might improve things, but there are similar <br>
potential issues with ICU as well. The trick there would be to get your <br=
>
OS distro provider to maintain the same ICU version across major <br>
versions of the distro, which is not the case currently. Nor does the <br>
PGDG repo do that.<br>
<br>
<br>
-- <br>
Joe Conway<br>
PostgreSQL Contributors Team<br>
RDS Open Source Databases<br>
Amazon Web Services: <a href=3D"https://aws.amazon.com" rel=3D"noreferrer n=
oreferrer" target=3D"_blank">https://aws.amazon.com</a><br>
<br>
<br>
</blockquote></div>
</blockquote></div><br clear=3D"all"><div><br></div><span class=3D"gmail_si=
gnature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><d=
iv dir=3D"ltr">Death to &lt;Redacted&gt;, and butter sauce.<div>Don&#39;t b=
oil me, I&#39;m still alive.<br><div><div>&lt;Redacted&gt; crustacean!</div=
></div></div></div></div></div>

--0000000000002f15d60622b5d820--