| From: | Michael Paquier <michael(at)paquier(dot)xyz> |
|---|---|
| To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
| Subject: | pgsql: Add --min-xid-age and --min-mxid-age options to vacuumdb |
| Date: | 2019-01-31 04:18:12 |
| Message-ID: | E1gp3no-0001xk-Sc@gemulon.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers |
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(-)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2019-01-31 19:23:16 | Re: pgsql: Build src/port files as a library with -fPIC, and use that in li |
| Previous Message | Tom Lane | 2019-01-31 00:25:42 | pgsql: Allow RECORD and RECORD[] to be specified in function coldeflist |