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

From: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: "a REINDEX operation on an index pg_upgrade'd from a previous release could potentially fail."
Date: 2024-12-15 07:39:05
Message-ID: CANzqJaCk3sN+i9fs=-e_GZtn-wM=+oZU1bb4rpt0KZb31uha=Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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) §

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-CONCURRENTLY
says "6. The old indexes are dropped"?

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

Browse pgsql-admin by date

  From Date Subject
Next Message M.Yousaf Maqsood 2024-12-15 13:16:05 pg_upgrade utility with --link option
Previous Message Tom Lane 2024-12-14 21:42:52 Re: Why might it take so long to start up a cleanly-stopped instance?