agora inbox for pgsql-docs@postgresql.org
help / color / mirror / Atom feedreindex documentation
3+ messages / 2 participants
[nested] [flat]
* reindex documentation
@ 2025-05-15 18:12 PG Doc comments form <noreply@postgresql.org>
0 siblings, 1 reply; 3+ messages in thread
From: PG Doc comments form @ 2025-05-15 18:12 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org; +Cc: acozens@pixelpower.com
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: reindex documentation
@ 2025-05-17 12:44 Michael Paquier <michael@paquier.xyz>
parent: PG Doc comments form <noreply@postgresql.org>
0 siblings, 1 reply; 3+ messages in thread
From: Michael Paquier @ 2025-05-17 12:44 UTC (permalink / raw)
To: acozens@pixelpower.com; pgsql-docs@lists.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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: reindex documentation
@ 2025-05-21 02:41 Michael Paquier <michael@paquier.xyz>
parent: Michael Paquier <michael@paquier.xyz>
0 siblings, 0 replies; 3+ messages in thread
From: Michael Paquier @ 2025-05-21 02:41 UTC (permalink / raw)
To: acozens@pixelpower.com; pgsql-docs@lists.postgresql.org
On Sat, May 17, 2025 at 08:44:09AM -0400, Michael Paquier wrote:
> 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?
Alec's latest message did not reach the lists, but it was only to
suggest a wording for the whole area, as a reply to my previous
message. I've reused most of his words with some slight tweaks,
applied the result down to 13 as 54675d898633, marking him as the
author.
--
Michael
Attachments:
[application/pgp-signature] signature.asc (832B, ../../aC09TBaiISMUrW9H@paquier.xyz/2-signature.asc)
download
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2025-05-21 02:41 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-05-15 18:12 reindex documentation PG Doc comments form <noreply@postgresql.org>
2025-05-17 12:44 ` Michael Paquier <michael@paquier.xyz>
2025-05-21 02:41 ` Michael Paquier <michael@paquier.xyz>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox