02 / Notes / Database Systems
Database Systems
following.
Storage engines, indexes, transactions, concurrency, and the maintenance work behind simple queries.
0102
Database Systems / Explainer
Why PostgreSQL Keeps the Row You Updated
Follow one UPDATE through heap pages, row versions, snapshots, HOT, and VACUUM to see why the old value cannot disappear immediately.
Read noteDatabase Systems / Explainer
Why Databases Love Immutable Files
Build an LSM storage engine one problem at a time and see why faster writes create more work for reads and cleanup.
Read note