Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commitb648a33

Browse files
committed
doc: Clarify use of _ccnew and _ccold in REINDEX CONCURRENTLY
Invalid indexes are suffixed with "_ccnew" or "_ccold". Thedocumentation missed to mention the initial underscore.ChooseRelationName() may also append an extra number if indexes with asimilar name already exist; let's add a note about that too.Author: Alec Cozens <acozens@pixelpower.com>Discussion:https://postgr.es/m/174733277404.1455388.11471370288789479593@wrigleys.postgresql.orgBackpatch-through: 13
1 parent54c0529 commitb648a33

File tree

1 file changed

+5
-2
lines changed

1 file changed

+5
-2
lines changed

‎doc/src/sgml/ref/reindex.sgml

Lines changed: 5 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -464,14 +464,17 @@ Indexes:
464464
</programlisting>
465465

466466
If the index marked <literal>INVALID</literal> is suffixed
467-
<literal>ccnew</literal>, then it corresponds to the transient
467+
<literal>_ccnew</literal>, then it corresponds to the transient
468468
index created during the concurrent operation, and the recommended
469469
recovery method is to drop it using <literal>DROP INDEX</literal>,
470470
then attempt <command>REINDEX CONCURRENTLY</command> again.
471-
If the invalid index is instead suffixed <literal>ccold</literal>,
471+
If the invalid index is instead suffixed <literal>_ccold</literal>,
472472
it corresponds to the original index which could not be dropped;
473473
the recommended recovery method is to just drop said index, since the
474474
rebuild proper has been successful.
475+
A nonzero number may be appended to the suffix of the invalid index
476+
names to keep them unique, like <literal>_ccnew1</literal>,
477+
<literal>_ccold2</literal>, etc.
475478
</para>
476479

477480
<para>

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp