aboutsummaryrefslogtreecommitdiff
path: root/doc/src
diff options
context:
space:
mode:
authorBruce Momjian <bruce@momjian.us>2012-08-04 10:35:37 -0400
committerBruce Momjian <bruce@momjian.us>2012-08-04 10:35:47 -0400
commit4639432597d14f6cb29919eec3f9b4708d152b70 (patch)
treebc3a1df33f1dab097eaded194bac2dc2d0fc7962 /doc/src
parent3152bf722fe334b70281256dbb74d9cb1e3643e1 (diff)
downloadpostgresql-4639432597d14f6cb29919eec3f9b4708d152b70.tar.gz
postgresql-4639432597d14f6cb29919eec3f9b4708d152b70.zip
Reword documentation for concurrent index rebuilds to be clearer.
Backpatch to 9.1 and 9.2.
Diffstat (limited to 'doc/src')
-rw-r--r--doc/src/sgml/ref/create_index.sgml17
1 files changed, 8 insertions, 9 deletions
diff --git a/doc/src/sgml/ref/create_index.sgml b/doc/src/sgml/ref/create_index.sgml
index 2ab6470367d..17b433a47e4 100644
--- a/doc/src/sgml/ref/create_index.sgml
+++ b/doc/src/sgml/ref/create_index.sgml
@@ -394,15 +394,14 @@ CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ <replaceable class="parameter">name</
</para>
<para>
- In a concurrent index build, the index is actually entered into the
- system catalogs in one transaction, then the two table scans occur in a
- second and third transaction. All active transactions at the time the
- second table scan starts, not just ones that already involve the table,
- have the potential to block the concurrent index creation until they
- finish. When checking for transactions that could still use the original
- index, concurrent index creation advances through potentially interfering
- older transactions one at a time, obtaining shared locks on their virtual
- transaction identifiers to wait for them to complete.
+ In a concurrent index build, the index is actually entered into
+ the system catalogs in one transaction, then two table scans occur in
+ two more transactions. Any transaction active when the second table
+ scan starts can block concurrent index creation until it completes,
+ even transactions that only reference the table after the second table
+ scan starts. Concurrent index creation serially waits for each old
+ transaction to complete using the method outlined in section <xref
+ linkend="view-pg-locks">.
</para>
<para>