Inside database data files (2/3): PostgreSQL
After InnoDB, PostgreSQL. Both engines solve the same problems (store rows, find them fast, survive a crash, let people read while others write) but made almost opposite choices. Knowing them explains the need for VACUUM, table bloat, or why the first SELECT after a big load writes to disk. The data directory First habit to…