The Architecture of PostgreSQL: How Queries Actually Execute
A journey through PostgreSQL internals: the planner, executor, buffer pool, WAL, and MVCC — understanding these makes every query you write more intentional.
A journey through PostgreSQL internals: the planner, executor, buffer pool, WAL, and MVCC — understanding these makes every query you write more intentional.
Traces, metrics, logs — the three pillars and the fourth nobody talks about: profiling. How to instrument distributed systems so you can debug them when they fail at 3am.
How Google Docs, Figma, and Notion let multiple users edit simultaneously without conflicts — the beautiful mathematics of conflict-free replicated data types.
At-least-once vs exactly-once delivery, dead letter queues, consumer groups, and idempotency — the complete mental model for building reliable event-driven systems.
Raft, Paxos, Viewstamped Replication — not as academic exercises but as practical mental models for understanding what your databases actually guarantee.
Why wall clocks lie in distributed systems, how logical clocks restore causality, and the precise guarantees you can and cannot rely on when reasoning about event ordering.
A candid look at what actually happened when we split our monolith — the wins, the unexpected failures, and whether it was worth it.
First-hand experiences and hard lessons from scaling a platform from zero to millions of users — what the textbooks don't tell you.
How experienced engineers think through complex technical problems — the mental models, heuristics, and systematic approaches that separate good from great.