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

Started by Michael Paquierover 7 years ago1 messagescomitters
Jump to latest
#1Michael Paquier
michael@paquier.xyz

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: /messages/by-id/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(-)