VACUUM at the Page Level
Summary
A technical deep-dive into PostgreSQL VACUUM internals, tracing the page-level changes during vacuuming, the line pointer lifecycle, and associated structures like the free space map and visibility map. The piece walks through a concrete example, distinguishes regular VACUUM from VACUUM FULL, and presents an interactive visualizer to illustrate the process.