Tech
Computer science, databases first: storage, transactions and recovery, then operating systems, networks, languages and algorithms.
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.
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.
Follow Tech alone: RSS.