mvcc

MySQL vs PostgreSQL: The Differences That Actually Matter

A concrete comparison of MySQL and PostgreSQL: MVCC and VACUUM, clustered index vs heap, isolation defaults, transactional DDL, and replication durability.