agora inbox for pgsql-docs@postgresql.org
help / color / mirror / Atom feedFrom: PG Doc comments form <noreply@postgresql.org>
To: pgsql-docs@lists.postgresql.org
Cc: acozens@pixelpower.com
Subject: reindex documentation
Date: Thu, 15 May 2025 18:12:54 +0000
Message-ID: <174733277404.1455388.11471370288789479593@wrigleys.postgresql.org> (raw)
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.
view thread (3+ messages) latest in thread
Message-ID: <174733277404.1455388.11471370288789479593@wrigleys.postgresql.org>
Permalink: ../174733277404.1455388.11471370288789479593@wrigleys.postgresql.org/
Also on: postgresql.org/message-id/174733277404.1455388.11471370288789479593@wrigleys.postgresql.org
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: noreply@postgresql.org, pgsql-docs@lists.postgresql.org, acozens@pixelpower.com
Subject: Re: reindex documentation
In-Reply-To: <174733277404.1455388.11471370288789479593@wrigleys.postgresql.org>
* 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