Thread: pgsql: Add --min-xid-age and --min-mxid-age options to vacuumdb
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 Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/00d1e88d36687ceae1be2317fac90e967941c085 Modified Files -------------- doc/src/sgml/ref/vacuumdb.sgml | 54 +++++++++++++++++++++++++++ src/bin/scripts/t/100_vacuumdb.pl | 19 +++++++++- src/bin/scripts/vacuumdb.c | 77 ++++++++++++++++++++++++++++++++++++++- 3 files changed, 148 insertions(+), 2 deletions(-)