diff options
author | Michael Paquier <michael@paquier.xyz> | 2019-07-13 14:43:29 +0900 |
---|---|---|
committer | Michael Paquier <michael@paquier.xyz> | 2019-07-13 14:43:29 +0900 |
commit | 170d11b8e7cb9df96a7ee0b8140d28536d55fe3e (patch) | |
tree | 11bd2c7128c7f1be997387f082b2f4e300116676 /doc/src/sgml/ref/reindex.sgml | |
parent | 5b51bbfbd52a444a490247e66751d6a47d2ba7dd (diff) | |
download | postgresql-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.sgml | 14 |
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 — 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=> \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; |