diff options
| author | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2021-01-13 17:55:41 -0300 |
|---|---|---|
| committer | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2021-01-13 17:55:41 -0300 |
| commit | 93c39f987e9c019cd28c450ece8a621b2d8ce28a (patch) | |
| tree | 3189ef92c8e1fc6c3ad73d83a3b348e3a74c4103 | |
| parent | c21ea4d53e9404279273da800daa49b7b9a5e81e (diff) | |
| download | postgresql-93c39f987e9c019cd28c450ece8a621b2d8ce28a.tar.gz postgresql-93c39f987e9c019cd28c450ece8a621b2d8ce28a.zip | |
Call out vacuum considerations in create index docs
Backpatch to pg12, which is as far as it goes without conflicts.
Author: James Coleman <jtc331@gmail.com>
Reviewed-by: "David G. Johnston" <david.g.johnston@gmail.com>
Discussion: https://postgr.es/m/CAAaqYe9oEfbz7AxXq7OX+FFVi5w5p1e_Of8ON8ZnKO9QqBfmjg@mail.gmail.com
| -rw-r--r-- | doc/src/sgml/ref/create_index.sgml | 6 | ||||
| -rw-r--r-- | doc/src/sgml/ref/reindex.sgml | 6 |
2 files changed, 12 insertions, 0 deletions
diff --git a/doc/src/sgml/ref/create_index.sgml b/doc/src/sgml/ref/create_index.sgml index 6fff02d8243..a5271a9f8f2 100644 --- a/doc/src/sgml/ref/create_index.sgml +++ b/doc/src/sgml/ref/create_index.sgml @@ -852,6 +852,12 @@ Indexes: </para> <para> + Like any long-running transaction, <command>CREATE INDEX</command> on a + table can affect which tuples can be removed by concurrent + <command>VACUUM</command> on any other table. + </para> + + <para> Prior releases of <productname>PostgreSQL</productname> also had an R-tree index method. This method has been removed because it had no significant advantages over the GiST method. diff --git a/doc/src/sgml/ref/reindex.sgml b/doc/src/sgml/ref/reindex.sgml index 6e1cf067130..627b36300c9 100644 --- a/doc/src/sgml/ref/reindex.sgml +++ b/doc/src/sgml/ref/reindex.sgml @@ -437,6 +437,12 @@ Indexes: </para> <para> + Like any long-running transaction, <command>REINDEX</command> on a table + can affect which tuples can be removed by concurrent + <command>VACUUM</command> on any other table. + </para> + + <para> <command>REINDEX SYSTEM</command> does not support <command>CONCURRENTLY</command> since system catalogs cannot be reindexed concurrently. |