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 and flow from this site, held on your device and searchable with no connection. Free to install, no ads.
Get it free on the App Store