The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/sql-reindex.html Description:
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.