vacuumdb

Vacuum database

$ vacuumdb [database]

$ vacuumdb --all

$ vacuumdb --analyze [database]

$ vacuumdb --full [database]

$ vacuumdb -t [table_name] [database]

$ vacuumdb -j [4] [database]

$ vacuumdb -v [database]

vacuumdb [-a] [-z] [-f] [-t table] [-j jobs] [options] [database]

vacuumdb cleans and analyzes PostgreSQL databases. It reclaims storage and updates query planner statistics.
Regular vacuum marks dead tuples for reuse. It doesn't reclaim disk space but prevents table bloat from growing indefinitely.
Full vacuum rewrites tables, reclaiming disk space. It requires exclusive lock and more time than regular vacuum.
Analyze updates statistics used by the query planner. Accurate statistics lead to better query plans and performance.
Parallel vacuuming processes multiple tables simultaneously. This speeds up vacuum on databases with many tables.
The tool wraps the SQL VACUUM command with convenient options for scripting and cron jobs.

-a, --all

Vacuum all databases.

Update statistics.

Only analyze, no vacuum.

Full vacuum.

Vacuum specific table.

Parallel jobs.

Echo commands.

Quiet mode.

Verbose output.

Database server host.

Server port.

Username.

Prompt for password.

Min age for MXID vacuum.

Full vacuum locks tables exclusively. Regular vacuum should run frequently. Large tables take time. Disk space needed for full vacuum.

vacuumdb has been part of PostgreSQL since early versions. It provides command-line access to vacuum operations essential for database maintenance.

psql(1), pg_dump(1), reindexdb(1), clusterdb(1)