|< < 7 > >|

Postgres MVCC

Indexes — it gets worse

Any update to a row causes every index to be updated, and become slightly more bloated.

And then each of those obsolete index entries have to be cleaned up during vacuum.

This was a significant part of the reason that Uber moved from Postgres to MySQL.

|< < 7 > >|