PostgreSQL VACUUM's Page-Level Byte-by-Byte Inspection
PostgreSQL VACUUM's three-stage operational mechanism was analyzed at the page level using pageinspect, pg_visibility, and pg_freespacemap. The difference between LP_DEAD and LP_UNUSED becomes clearer.
postgresqlvacuumdatabase-internalsindex-bloat