Cheat Sheet logoCheat Sheet Today
PostgreSQL Performance Cheat Sheet/VACUUM FULL table

Rewrite a bloated table more aggressively.

Back to sheetBrowse commands
Sign in to save
Section: Vacuum, Analyze, and Maintenance

VACUUM FULL table

sql
sql
VACUUM (FULL, ANALYZE) public.users;
Explanation

Requires more locking and space; use carefully.

View in sheet →

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Compare commandsView fixes

Related commands

Same sheet · prioritizing Vacuum, Analyze, and Maintenance
Vacuum one table
Reclaim dead tuples and maintain visibility data.
OpenIn sheetsqlsame section
Vacuum analyze one table
Vacuum and refresh planner stats in one command.
OpenIn sheetsqlsame section
Reindex table
Rebuild all indexes on a table.
OpenIn sheetsqlsame section
Analyze verbose
Show extra detail while updating planner statistics.
OpenIn sheetsqlsame section
Show autovacuum setting
Check whether autovacuum is enabled.
OpenIn sheetsqlsame section
Batch deletes
Delete in chunks to avoid huge transactions.
OpenIn sheetsql1 tag match