PostgreSQL's MVCC is bad. So is everyone else's.

This site does not allow itself to be embedded. You can still read it on the original site — the toolbar below keeps your place in the directory.

The first thing you will probably learn about Postgres, if you follow people who don't like Postgres, is that MVCC is bad. The 40-year-old design mistake. It's signatures are everywhere. Bloated tables that double in size, 32-bit transaction counter limit, the never ending struggle with VACCUM, dead tuples nightmares. It comes with credentials, too: Uber measured the write amplification…

Read on boringsql.com ↗