PostgreSQL Internals

In Postgres an UPDATE is an insert, and your page space pays for it

A dev.to walkthrough of tuple storage shows why write volume, not row count, sets heap size. The explainer stops one sentence before the part operators actually need.