diff options
author | Michael Paquier <michael@paquier.xyz> | 2019-01-31 13:06:51 +0900 |
---|---|---|
committer | Michael Paquier <michael@paquier.xyz> | 2019-01-31 13:07:56 +0900 |
commit | 00d1e88d36687ceae1be2317fac90e967941c085 (patch) | |
tree | 1a3c52aa0db5956a743649108b4361b18ee15368 /doc/src | |
parent | 5f5c01459053c0975b89b5aa1a3d705e677348ae (diff) | |
download | postgresql-00d1e88d36687ceae1be2317fac90e967941c085.tar.gz postgresql-00d1e88d36687ceae1be2317fac90e967941c085.zip |
Add --min-xid-age and --min-mxid-age options to vacuumdb
These two new options can be used to improve the selectivity of
relations to vacuum or analyze even further depending on the age of
respectively their transaction ID or multixact ID, so as it is possible
to prioritize tables to prevent wraparound of one or the other.
Combined with --table, it is possible to target a subset of tables to
choose as potential processing targets.
Author: Nathan Bossart
Reviewed-by: Michael Paquier, Masahiko Sawada
Discussion: https://postgr.es/m/FFE5373C-E26A-495B-B5C8-911EC4A41C5E@amazon.com
Diffstat (limited to 'doc/src')
-rw-r--r-- | doc/src/sgml/ref/vacuumdb.sgml | 54 |
1 files changed, 54 insertions, 0 deletions
diff --git a/doc/src/sgml/ref/vacuumdb.sgml b/doc/src/sgml/ref/vacuumdb.sgml index f304627802e..41c7f3df793 100644 --- a/doc/src/sgml/ref/vacuumdb.sgml +++ b/doc/src/sgml/ref/vacuumdb.sgml @@ -173,6 +173,60 @@ PostgreSQL documentation </varlistentry> <varlistentry> + <term><option>--min-mxid-age <replaceable class="parameter">mxid_age</replaceable></option></term> + <listitem> + <para> + Only execute the vacuum or analyze commands on tables with a multixact + ID age of at least <replaceable class="parameter">mxid_age</replaceable>. + This setting is useful for prioritizing tables to process to prevent + multixact ID wraparound (see + <xref linkend="vacuum-for-multixact-wraparound"/>). + </para> + <para> + For the purposes of this option, the multixact ID age of a relation is + the greatest of the ages of the main relation and its associated + <acronym>TOAST</acronym> table, if one exists. Since the commands + issued by <application>vacuumdb</application> will also process the + <acronym>TOAST</acronym> table for the relation if necessary, it does + not need to be considered separately. + </para> + <note> + <para> + This option is only available for servers running + <productname>PostgreSQL</productname> 9.6 and later. + </para> + </note> + </listitem> + </varlistentry> + + <varlistentry> + <term><option>--min-xid-age <replaceable class="parameter">xid_age</replaceable></option></term> + <listitem> + <para> + Only execute the vacuum or analyze commands on tables with a + transaction ID age of at least + <replaceable class="parameter">xid_age</replaceable>. This setting + is useful for prioritizing tables to process to prevent transaction + ID wraparound (see <xref linkend="vacuum-for-wraparound"/>). + </para> + <para> + For the purposes of this option, the transaction ID age of a relation + is the greatest of the ages of the main relation and its associated + <acronym>TOAST</acronym> table, if one exists. Since the commands + issued by <application>vacuumdb</application> will also process the + <acronym>TOAST</acronym> table for the relation if necessary, it does + not need to be considered separately. + </para> + <note> + <para> + This option is only available for servers running + <productname>PostgreSQL</productname> 9.6 and later. + </para> + </note> + </listitem> + </varlistentry> + + <varlistentry> <term><option>-q</option></term> <term><option>--quiet</option></term> <listitem> |