agora inbox for pgsql-docs@postgresql.org
help / color / mirror / Atom feedFrom: Michael Paquier <michael@paquier.xyz>
To: acozens@pixelpower.com
To: pgsql-docs@lists.postgresql.org
Subject: Re: reindex documentation
Date: Sat, 17 May 2025 08:44:09 -0400
Message-ID: <aCiEmbG52nk5iip7@paquier.xyz> (raw)
In-Reply-To: <174733277404.1455388.11471370288789479593@wrigleys.postgresql.org>
References: <174733277404.1455388.11471370288789479593@wrigleys.postgresql.org>
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
Attachments:
[application/pgp-signature] signature.asc (832B, ../aCiEmbG52nk5iip7@paquier.xyz/2-signature.asc)
download
view thread (3+ messages) latest in thread
Message-ID: <aCiEmbG52nk5iip7@paquier.xyz>
Permalink: ../aCiEmbG52nk5iip7@paquier.xyz/
Also on: postgresql.org/message-id/aCiEmbG52nk5iip7@paquier.xyz
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: michael@paquier.xyz, acozens@pixelpower.com, pgsql-docs@lists.postgresql.org
Subject: Re: reindex documentation
In-Reply-To: <aCiEmbG52nk5iip7@paquier.xyz>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox