|< < 43 > >|

Postgres MVCC

Bloat

What happens if you update a row v times?

Obviously, you get v+1 versions. Eventually, the first v versions will become dead.

But they are still in the database.

This causes bloat, which is bad.

Suppose a table has N rows, each updated v times.

|< < 43 > >|