pg_maintenance(8)
NAME
pg_maintenance - perform maintenance tasks on all clusters
SYNOPSIS
pg_maintenance [-f|--full] [-a|--analyze] [-v|--verbose] [--force]
DESCRIPTION
This script performs maintenance actions on all databases in all
clusters. In particular, this calls vacuumdb on all databases, which
frees up unused space and helps to improve database performance (if
--analyze is specified).
This script is intended to be called regularly in a cronjob.
OPTIONS
- -c, --cluster version/cluster
- Perform maintenance only on specified cluster. By default, all
clusters are handled. - -f, --full
- Perform a "full vacuum", which is more effective but takes more
time and needs to completely lock tables while working on it. - -a, --analyze
- Perform some statistical analyses on the tables which helps to
improve database performance. This only needs read access to the
tables, thus does not require any locking. - -v, --verbose
- Passed to vacuumdb, which prints lots of information about the vacuuming and analysis.
- --force
- By default a cluster is not processed if autovacuuming is enabled
for it. If this option is specified, the cluster is processed
regardless of the autovacuum daemon status.
SEE ALSO
vacuumdb(1), vacuum(7), analyze(7), pg_ctlcluster(1)
AUTHOR
- Martin Pitt <mpitt@debian.org>