News for hackers. Stuff that matters.
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

There are no comments on this comment yet.