vacuumdb -d appdb --full

Category: Databases & SQL

vacuumdb -d appdb --full

Fully vacuum a database

Runs VACUUM FULL, which rewrites every table to compact it and return space to the OS. It takes exclusive locks on each table, blocking reads and writes, so run it in a maintenance window. Plain vacuumdb is safe anytime.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.