Tag
4 articles tagged #System Design.
P.01MVCC keeps several versions of each row so reads never wait on writes. See xmin and xmax in a live Postgres session, and why long transactions cause bloat.
P.02Your p99 is slower than your average suggests, and fan-out makes it worse. How hedged requests and load shedding cut tail latency, with TypeScript code.
P.03An LSM tree turns random writes into sequential ones by buffering in memory and merging sorted files. How it works, what compaction costs, and when to pick it.
P.04A write-ahead log makes a database durable by recording changes before touching data files. How WAL commits, recovers, replicates, and what it trades.