vacuumdb

Maintenance

Garbage-collect and analyze PostgreSQL database

Options & Flags

Available options for this command

-a

Vacuum all databases

-z

Also update optimizer statistics

-f

Full vacuum (reclaims more space)

-j

Number of parallel jobs

Examples

Common usage examples

Vacuum specific database

vacuumdb mydb

Vacuum all databases with analyze

vacuumdb -a -z

Full vacuum for maximum space recovery

vacuumdb -f mydb

Notes

Regular vacuum is non-blocking
Full vacuum requires exclusive lock

Related Commands

You might also find these useful