MIME-Version: 1.0
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Sun, 15 Dec 2024 02:39:05 -0500
Message-ID: 
 <CANzqJaCk3sN+i9fs=-e_GZtn-wM=+oZU1bb4rpt0KZb31uha=Q@mail.gmail.com>
Subject: "a REINDEX operation on an index pg_upgrade'd from a previous release
 could potentially fail."
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000381b8e06294a2900"
Archived-At: 
 <https://www.postgresql.org/message-id/CANzqJaCk3sN%2Bi9fs%3D-e_GZtn-wM%3D%2BoZU1bb4rpt0KZb31uha%3DQ%40mail.gmail.com>
Precedence: bulk

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

According to https://www.postgresql.org/docs/release/12.0/
"
In new btree indexes, the maximum index entry length is reduced by eight
bytes, to improve handling of duplicate entries (Peter Geoghegan) =C2=A7

This means that a REINDEX operation on an index pg_upgrade'd from a
previous release could potentially fail.
"

Would a REINDEX CONCURRENTLY mitigate that risk, since
https://www.postgresql.org/docs/14/sql-reindex.html#SQL-REINDEX-CONCURRENTL=
Y
says "6. The old indexes are dropped"?

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

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

<div dir=3D"ltr"><div>According to <a href=3D"https://www.postgresql.org/do=
cs/release/12.0/">https://www.postgresql.org/docs/release/12.0/</a></div><d=
iv>&quot;</div><div>In new btree indexes, the maximum index entry length is=
 reduced by eight bytes, to improve handling of duplicate entries (Peter Ge=
oghegan) =C2=A7<br><br>This means that a REINDEX operation on an index pg_u=
pgrade&#39;d from a previous release could potentially fail.</div><div>&quo=
t;</div><div><br></div><div>Would a REINDEX CONCURRENTLY mitigate that risk=
, since=C2=A0<a href=3D"https://www.postgresql.org/docs/14/sql-reindex.html=
#SQL-REINDEX-CONCURRENTLY">https://www.postgresql.org/docs/14/sql-reindex.h=
tml#SQL-REINDEX-CONCURRENTLY</a> says &quot;6.=C2=A0The old indexes are dro=
pped&quot;?</div><div><br></div><span class=3D"gmail_signature_prefix">-- <=
/span><br><div dir=3D"ltr" class=3D"gmail_signature" data-smartmail=3D"gmai=
l_signature"><div dir=3D"ltr">Death to &lt;Redacted&gt;, and butter sauce.<=
div>Don&#39;t boil me, I&#39;m still alive.<br><div><div>&lt;Redacted&gt; l=
obster!</div></div></div></div></div></div>

--000000000000381b8e06294a2900--