VACUUM FULL

RU: VACUUM FULL

A PostgreSQL variant of VACUUM that rewrites the entire table and all its indexes into new files, physically compacting the data and returning unused space to the OS. It requires an ACCESS EXCLUSIVE lock for its full duration, blocking all reads and writes, making it unsuitable for high-availability environments without maintenance windows.