Re:PostgreSQL 16 Released
by _bohm on Thursday September 14, 2023 @01:50PM
(#37512349)
Not quite true. Regular VACUUM marks dead tuples as available for re-use, so the system can overwrite the dead tuples with fresh ones after a VACUUM. VACUUM FULL completely rewrites and repacks the table.
https://www.postgresql.org/docs/current/sql-vacuum.html