6 questions · ~5 min · intermediate
Six questions on what vacuum really does inside PostgreSQL: reclaiming dead tuples, maintaining visibility metadata, and freezing old XIDs before they become dangerous.
Why does a normal PostgreSQL `UPDATE` create vacuum work later on?