Add --min-xid-age and --min-mxid-age options to vacuumdb

Michael Paquier <michael@paquier.xyz>

Commit: 00d1e88d36687ceae1be2317fac90e967941c085
Author: Michael Paquier <michael@paquier.xyz>
Date: 2019-01-31T04:07:56Z
Releases: 12.0
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

Files

PathChange+/−
doc/src/sgml/ref/vacuumdb.sgml modified +54 −0
src/bin/scripts/t/100_vacuumdb.pl modified +18 −1
src/bin/scripts/vacuumdb.c modified +76 −1

Documentation touched

Discussion