MIME-Version: 1.0
References: <6E6059F6-E5A1-4A8D-8A5E-A41B921BBE67@gmail.com> <E0EC05FB-783D-4A24-81B9-0C345A5EC45A@gmail.com>
In-Reply-To: <E0EC05FB-783D-4A24-81B9-0C345A5EC45A@gmail.com>
From: Greg Sabino Mullane <htamfids@gmail.com>
Date: Wed, 12 Mar 2025 16:31:14 -0400
Message-ID: <CAKAnmmJ+PwfRunSzBpVJXttNCcP_Cims5uO4B5OYbcEuoWqYeg@mail.gmail.com>
Subject: Re: Moving from Linux to Linux?
To: Paul Foerster <paul.foerster@gmail.com>
Cc: Pgsql-General List <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000005698c406302b185d"
Archived-At: <https://www.postgresql.org/message-id/CAKAnmmJ%2BPwfRunSzBpVJXttNCcP_Cims5uO4B5OYbcEuoWqYeg%40mail.gmail.com>
Precedence: bulk

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

On Tue, Mar 11, 2025 at 2:35=E2=80=AFPM Paul Foerster <paul.foerster@gmail.=
com>
wrote:

> The question was a bit of an idea. So the glibc version in not known yet,
> but I'm highly confident that they will differ. A reindex could in theory
> be possible in most cases, but is a definite show stopper on some of our
> databases, because it would mean too much application downtime.
>

Keep in mind that you only need to reindex text-based indexes. Ints are
still gonna int. So it might not be too bad.

Cheers,
Greg

--
Crunchy Data - https://www.crunchydata.com
Enterprise Postgres Software Products & Tech Support

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

<div dir=3D"ltr"><div dir=3D"ltr">On Tue, Mar 11, 2025 at 2:35=E2=80=AFPM P=
aul Foerster &lt;<a href=3D"mailto:paul.foerster@gmail.com">paul.foerster@g=
mail.com</a>&gt; wrote:</div><div class=3D"gmail_quote gmail_quote_containe=
r"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;bord=
er-left:1px solid rgb(204,204,204);padding-left:1ex">The question was a bit=
 of an idea. So the glibc version in not known yet, but I&#39;m highly conf=
ident that they will differ. A reindex could in theory be possible in most =
cases, but is a definite show stopper on some of our databases, because it =
would mean too much application downtime.<br></blockquote></div><div><br></=
div><div>Keep in mind that you only need to reindex text-based indexes. Int=
s are still gonna int. So it might not be too bad.</div><div><br></div><div=
 dir=3D"ltr" class=3D"gmail_signature"><div dir=3D"ltr"><div>Cheers,</div><=
div>Greg</div><div><br></div><div>--</div><div>Crunchy Data - <a href=3D"ht=
tps://www.crunchydata.com" target=3D"_blank">https://www.crunchydata.com</a=
></div><div>Enterprise Postgres Software Products &amp; Tech Support</div><=
div><br></div></div></div></div>

--0000000000005698c406302b185d--