Re: reindex documentation

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