PostgreSQL Vacuum
How PostgreSQL vacuum works, and what I got wrong along the way
Active recall
Braindumps
Rougher notes written from memory first, then corrected.
PAX, Row Groups, and Parquet
How PAX-style layouts and Parquet organize data for analytics, and what I got wrong along the way
Two-Phase Locking (2PL)
How two-phase locking controls concurrent transactions, and what I got wrong along the way
Database Concurrency Models
How databases handle multiple clients at once, and what I got wrong along the way
Paxos
How Paxos coordinates state across machines, and what I got wrong along the way
Linearizability
What linearizability means in distributed systems, and what I got wrong along the way
SQLite Query Execution
How SQLite processes a query from SQL text to results, and what I got wrong along the way
Log-Structured Merge Trees
How LSM trees trade read performance for fast writes, and what I got wrong along the way