#postgresql
How PostgreSQL works inside: storage, WAL, transactions, the planner, and the code paths behind them.
Writing RSS
How PostgreSQL tells every connection its cache is stale
explainer
Each PostgreSQL connection caches the catalog for itself. How a change is announced to all of them at commit through a shared ring, and what happens to a connection that falls behind.
Notes
Full-page writes and torn pages
note · evergreen
Why the first change to a page after a checkpoint carries the whole 8 KB page in WAL.
Lazy transaction id assignment
note · seedling
A transaction does not get an xid at BEGIN; it gets one the first time it writes.
pd_lsn vs record LSN
note · budding
Two LSNs that are easy to mix up, and the rule recovery uses to compare them.
Projects
Smart Video Analysis
2025project · paused
Event-processing microservices for video analysis events over Kafka and PostgreSQL, deployed with Docker, Terraform and GitHub Actions.
Distributed PostgreSQL
2026–work · active
The internals of a horizontally scalable distributed PostgreSQL: sharding, distributed query execution, two-phase commit, and moving shards while the cluster serves.