PostgreSQL Bloat Is a Feature, Not a Bug
Introduction Your PostgreSQL database keeps growing, even though the number of rows stays roughly the same. Disk usage climbs, queries slow down, and you wonder what the heck is happening. It’s not a bug - it’s called bloat and it’s baked into the core design of Postgres. To understand why it happens we have to follow the lifecycle of a row from the moment it’s written to a physical file to the moment it becomes “dead” space. This journey begins at the physical storage layer: Pages and Tuples. ...