Vacuum at the Page Level

This article provides a detailed explanation of how PostgreSQL's VACUUM process works, including its three phases: heap scan and pruning, index cleanup, and heap cleanup. It also covers the line pointer lifecycle, free space map, and visibility map.