#databases
Database systems in general: storage engines, transactions, consistency, and the trade-offs between 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.