Hollis Varden: What deleting rows does to a PostgreSQL table

T2Covered by 1 source · first reported by Planet PostgreSQL at 13 Oct, 00:00 UTC

A table that shrinks in rows does not shrink on disk. Everyone who has run PostgreSQL for a while knows this in general. I wanted the actual numbers, because "VACUUM reclaims space" means something narrower than it sounds. Short answer: I deleted every second row of a 2,000,000-row table. The table…

cloud

Sources

• T2Hollis Varden: What deleting rows does to a PostgreSQL tablePlanet PostgreSQL13 Oct, 00:00