THE PART OF POSTGRESQL WE HATE THE MOST

Summary from the TLDR Web Dev newsletter

PostgreSQL's Multi-Version Concurrency Control (MVCC) has shortcomings. Despite PostgreSQL's overall popularity, its MVCC design suffers from several problems: excessive data duplication, table bloat due to dead tuples, secondary index maintenance overhead, and difficulty in managing the autovacuum process.