Feedback-ID: i0fe9450f:Fastmail
Date: Sat, 17 May 2025 08:44:09 -0400
From: Michael Paquier <michael@paquier.xyz>
To: acozens@pixelpower.com, pgsql-docs@lists.postgresql.org
Subject: Re: reindex documentation
Message-ID: <aCiEmbG52nk5iip7@paquier.xyz>
References: 
 <174733277404.1455388.11471370288789479593@wrigleys.postgresql.org>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha256;
	protocol="application/pgp-signature"; boundary="+PW0U6iXPl4YuiGS"
Content-Disposition: inline
In-Reply-To: 
 <174733277404.1455388.11471370288789479593@wrigleys.postgresql.org>
Archived-At: 
 <https://www.postgresql.org/message-id/aCiEmbG52nk5iip7%40paquier.xyz>
Precedence: bulk


--+PW0U6iXPl4YuiGS
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

On Thu, May 15, 2025 at 06:12:54PM +0000, PG Doc comments form wrote:
> The following paragraph:
> "If the index marked INVALID is suffixed ccnew, then it corresponds to the
> transient index created during the concurrent operation, and the recommended
> recovery method is to drop it using DROP INDEX, then attempt REINDEX
> CONCURRENTLY again. If the invalid index is instead suffixed ccold, it
> corresponds to the original index which could not be dropped; the
> recommended recovery method is to just drop said index, since the rebuild
> proper has been successful."
> It seems to me that the indexes are suffixed with _ccnew and _ccold not
> ccnew and ccold. Also, if _ccnew or _ccold indexes alread exist, an integer
> value starting from 1 will be added until a unique index is found - e.g.
> _ccnew1, _ccold1, _ccnew2 etc.

Right, following the rules defined internally by ChooseRelationName()
when creating the new/old indexes in the process.  So this could be
added.  Would you like to suggest a rewording of this sentence for the
extra number optionally appended to the suffix if a duplicated entry
exists?
--
Michael

--+PW0U6iXPl4YuiGS
Content-Type: application/pgp-signature; name=signature.asc

-----BEGIN PGP SIGNATURE-----

iQIzBAEBCAAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmgohJkACgkQnvQgOdby
QH22ww//cDU1SfwUdOAGYEGL6lJaZWvVc21UZy4nx54XSIuxA89rYn3OIa1xROBk
Hu0PSZ7sIdJ3lDIZU6lPyXb67H2O1MPn/vcUoxORhtpj8YaebhI5qx/XNZ8V13jP
AKd+yrg4tVQ5BZkrzsRzB4cIIecdXwgagN7/3jOfLH3gGxdcpHLYSHcRWoNL1m1X
MIf9v7HsdMlWVUrnrDnorge1mmAqDBmTLALAZ0xZKT4c5UO01EAaL8CnK8RPy4vf
azuFEygixjQWXwUz0vApaBBF9on1xKaoI4F08XsZgi0AWrsEKSMtVr0Cy5y2h47U
92VPPnuTB5GfpLG2LEkktrdBH6M7iyJNAOfZsCE2qLwFT7ccCmVcLieLEhV6SO3q
sleW1y9Ti0UvDQKy+UHU0uuYzqI5yNnKaMFFKXPpfQPH9xDGnevBoXXRnXN85b5X
doUOB/ARnzruYY79qK2SSDhkQxVlxkFfH+Sf2VPWJPJF/CBLXJGL7UrSzXCmIVkf
l28lb6cPVUPx8aKNRYHIkSBCvQ1w59xF4PEtOAgieVdbYjhjnCH74o0vq9UIBSWC
Oiu3vpsw3BadzrHYbGWGkuwkAthoImURyUiByP17v8X/uAWBp2P/pubOqlpJVIJi
UKAK5DBqPKA4hYP5Ljtg8Decq7JEZoVg4FRL+DC6xtbr+Xvbr7w=
=LvXU
-----END PGP SIGNATURE-----

--+PW0U6iXPl4YuiGS--