Rewrites the table into a compact form and returns space to the operating system, unlike plain VACUUM. It takes an exclusive lock for the whole run, blocking reads and writes on that table, so schedule it in a maintenance window.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.