aboutsummaryrefslogtreecommitdiff
path: root/doc/src/sgml/ref/reindex.sgml
diff options
context:
space:
mode:
authorMichael Paquier <michael@paquier.xyz>2019-07-13 14:43:29 +0900
committerMichael Paquier <michael@paquier.xyz>2019-07-13 14:43:29 +0900
commit170d11b8e7cb9df96a7ee0b8140d28536d55fe3e (patch)
tree11bd2c7128c7f1be997387f082b2f4e300116676 /doc/src/sgml/ref/reindex.sgml
parent5b51bbfbd52a444a490247e66751d6a47d2ba7dd (diff)
downloadpostgresql-170d11b8e7cb9df96a7ee0b8140d28536d55fe3e.tar.gz
postgresql-170d11b8e7cb9df96a7ee0b8140d28536d55fe3e.zip
Fix and improve several places in the docs
This adds some missing markups, fixes a couple of incorrect ones and clarifies some documentation in various places. Author: Liudmila Mantrova Discussion: https://postgr.es/m/a068f947-7a51-5df1-b3fd-1a131ae5c044@postgrespro.ru Backpatch-through: 12
Diffstat (limited to 'doc/src/sgml/ref/reindex.sgml')
-rw-r--r--doc/src/sgml/ref/reindex.sgml14
1 files changed, 7 insertions, 7 deletions
diff --git a/doc/src/sgml/ref/reindex.sgml b/doc/src/sgml/ref/reindex.sgml
index 303436c89db..10881ab03a8 100644
--- a/doc/src/sgml/ref/reindex.sgml
+++ b/doc/src/sgml/ref/reindex.sgml
@@ -156,7 +156,7 @@ REINDEX [ ( VERBOSE ) ] { INDEX | TABLE | SCHEMA | DATABASE | SYSTEM } [ CONCURR
<para>
When this option is used, <productname>PostgreSQL</productname> will rebuild the
index without taking any locks that prevent concurrent inserts,
- updates, or deletes on the table; whereas a standard reindex build
+ updates, or deletes on the table; whereas a standard index rebuild
locks out writes (but not reads) on the table until it's done.
There are several caveats to be aware of when using this option
&mdash; see <xref linkend="sql-reindex-concurrently"
@@ -280,12 +280,12 @@ REINDEX [ ( VERBOSE ) ] { INDEX | TABLE | SCHEMA | DATABASE | SYSTEM } [ CONCURR
of writes. This method is invoked by specifying the
<literal>CONCURRENTLY</literal> option of <command>REINDEX</command>. When this option
is used, <productname>PostgreSQL</productname> must perform two scans of the table
- for each index that needs to be rebuild and in addition it must wait for
- all existing transactions that could potentially use the index to
- terminate. This method requires more total work than a standard index
+ for each index that needs to be rebuilt and wait for termination of
+ all existing transactions that could potentially use the index.
+ This method requires more total work than a standard index
rebuild and takes significantly longer to complete as it needs to wait
for unfinished transactions that might modify the index. However, since
- it allows normal operations to continue while the index is rebuilt, this
+ it allows normal operations to continue while the index is being rebuilt, this
method is useful for rebuilding indexes in a production environment. Of
course, the extra CPU, memory and I/O load imposed by the index rebuild
may slow down other operations.
@@ -442,8 +442,8 @@ broken_db=&gt; \q
</programlisting></para>
<para>
- Rebuild a table while authorizing read and write operations on involved
- relations when performed:
+ Rebuild indexes for a table, without blocking read and write operations
+ on involved relations while reindexing is in progress:
<programlisting>
REINDEX TABLE CONCURRENTLY my_broken_table;