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 | c285a244f6d36073c6a8c9852e17492568664211 (patch) | |
| tree | 520cdfcd445fcf1616b446ebae1baa5ff12a77be | |
| parent | 6b045ca6cce01f1512af3438a8d4db4dc83b2d07 (diff) | |
| download | postgresql-c285a244f6d36073c6a8c9852e17492568664211.tar.gz postgresql-c285a244f6d36073c6a8c9852e17492568664211.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 2b41af48a7e..3537dfaade6 100644 --- a/doc/src/sgml/ref/create_index.sgml +++ b/doc/src/sgml/ref/create_index.sgml @@ -824,6 +824,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 df1759b0f1c..ef0e576d1ec 100644 --- a/doc/src/sgml/ref/reindex.sgml +++ b/doc/src/sgml/ref/reindex.sgml @@ -405,6 +405,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. |