VACUUM
CautionVacuum (PostgreSQL)
VACUUM [ANALYZE] [table];
Reclaims dead tuples and refreshes stats. Run manually after mass deletes; FULL takes an exclusive lock.
Examples
VACUUM ANALYZE orders;Reclaim and re-analyze
Syntax
VACUUM [FULL] [ANALYZE] [table]; (PostgreSQL)
Before you run it
VACUUM FULL locks the table.
The same reference, with no signal at all
Every command on this site, held on your device. The app adds 632 more: 1,510 commands and 120 fix flows, searchable with no connection. Free to install, no ads (some content is a one-time purchase).
Get it free on the App Store