postgres.git / summary / log / commit / refs

commit    93c39f987e9c019cd28c450ece8a621b2d8ce28a
Author:   Alvaro Herrera <alvherre@alvh.no-ip.org>
Date:     Wed Jan 13 20:55:41 2021 +0000

    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


 doc/src/sgml/ref/create_index.sgml | 6 ++++++
 doc/src/sgml/ref/reindex.sgml      | 6 ++++++
 2 files changed, 12 insertions(+)

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
@@ -851,6 +851,12 @@ Indexes:
    to remove an index.
   </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
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
@@ -436,6 +436,12 @@ Indexes:
     CONCURRENTLY</command> cannot.
    </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


[parent: c21ea4d53e94]