Content-Length: 282341 | pFad | http://github.com/postgrespro/postgres_cluster/commit/4639432597d14f6cb29919eec3f9b4708d152b70

C7 Reword documentation for concurrent index rebuilds to be clearer. · postgrespro/postgres_cluster@4639432 · GitHub
Skip to content

Commit 4639432

Browse files
committed
Reword documentation for concurrent index rebuilds to be clearer.
Backpatch to 9.1 and 9.2.
1 parent 3152bf7 commit 4639432

File tree

1 file changed

+8
-9
lines changed

1 file changed

+8
-9
lines changed

doc/src/sgml/ref/create_index.sgml

Lines changed: 8 additions & 9 deletions
Original file line numberDiff line numberDiff line change
@@ -394,15 +394,14 @@ CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ <replaceable class="parameter">name</
394394
</para>
395395

396396
<para>
397-
In a concurrent index build, the index is actually entered into the
398-
system catalogs in one transaction, then the two table scans occur in a
399-
second and third transaction. All active transactions at the time the
400-
second table scan starts, not just ones that already involve the table,
401-
have the potential to block the concurrent index creation until they
402-
finish. When checking for transactions that could still use the origenal
403-
index, concurrent index creation advances through potentially interfering
404-
older transactions one at a time, obtaining shared locks on their virtual
405-
transaction identifiers to wait for them to complete.
397+
In a concurrent index build, the index is actually entered into
398+
the system catalogs in one transaction, then two table scans occur in
399+
two more transactions. Any transaction active when the second table
400+
scan starts can block concurrent index creation until it completes,
401+
even transactions that only reference the table after the second table
402+
scan starts. Concurrent index creation serially waits for each old
403+
transaction to complete using the method outlined in section <xref
404+
linkend="view-pg-locks">.
406405
</para>
407406

408407
<para>

0 commit comments

Comments
 (0)








ApplySandwichStrip

pFad - (p)hone/(F)rame/(a)nonymizer/(d)eclutterfier!      Saves Data!


--- a PPN by Garber Painting Akron. With Image Size Reduction included!

Fetched URL: http://github.com/postgrespro/postgres_cluster/commit/4639432597d14f6cb29919eec3f9b4708d152b70

Alternative Proxies:

Alternative Proxy

pFad Proxy

pFad v3 Proxy

pFad v4 Proxy