VACUUM ANALYZE performs a VACUUM and then an ANALYZE for each selected table. This is a handy combination form for routine maintenance scripts. See ANALYZE for more details about its processing. Plain VACUUM (without FULL) simply reclaims space and makes it available for re-use.
Does vacuum full block?
VACUUM or Full VACUUM Also since FULL VACUUM takes exclusive lock on the table, it blocks all operations on the corresponding table. So doing FULL VACUUM sometimes can slow down the overall database.22 nov 2019
Does vacuum freeze lock table?
Selects "full" vacuum, which can reclaim more space, but takes much longer and exclusively locks the table. This method also requires extra disk space, since it writes a new copy of the table and doesn't release the old copy until the operation is complete. ... Selects aggressive "freezing" of tuples.