agora inbox for [email protected]
help / color / mirror / Atom feedFrom: Alvaro Herrera <[email protected]>
Subject: [PATCH v5] Note CIC and RC in vacuum's doc
Date: Mon, 30 Nov 2020 18:50:06 -0300
Per James Coleman
---
doc/src/sgml/maintenance.sgml | 12 +++++++++++-
1 file changed, 11 insertions(+), 1 deletion(-)
diff --git a/doc/src/sgml/maintenance.sgml b/doc/src/sgml/maintenance.sgml
index 4d8ad754f8..d68d7f936e 100644
--- a/doc/src/sgml/maintenance.sgml
+++ b/doc/src/sgml/maintenance.sgml
@@ -159,7 +159,17 @@
concurrency control (<acronym>MVCC</acronym>, see <xref linkend="mvcc"/>): the row version
must not be deleted while it is still potentially visible to other
transactions. But eventually, an outdated or deleted row version is no
- longer of interest to any transaction. The space it occupies must then be
+ longer of interest to any transaction.
+ <footnote>
+ <para>
+ Note that <command>VACUUM</literal> needs to retain tuples that are
+ nominally visible to transactions running
+ <command>CREATE INDEX CONCURRENTLY</command> or
+ <command>REINDEX CONCURRENTLY</command>, even when run on tables
+ other than the tables being indexed.
+ </para>
+ </footnote>
+ The space it occupies must then be
reclaimed for reuse by new rows, to avoid unbounded growth of disk
space requirements. This is done by running <command>VACUUM</command>.
</para>
--
2.20.1
--6c2NcOVqGQ03X4Wi--
view thread (2+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected]
Subject: Re: [PATCH v5] Note CIC and RC in vacuum's doc
In-Reply-To: <no-message-id-185813@localhost>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox