2026-11-02·by Sijie Wang#fundamentals#storage

storage

How a database keeps concurrent readers and writers out of each other's way, promises a commit and then survives a power cut, and finds one row among hundreds of millions in a handful of page reads — and how all of it is priced, underneath, by the disk's block size and random IOPS.

The set: mvcc for separating readers from writers, isolation-levels for the contract that separation is sold at, wal for durability, b-tree for finding rows, io-block-size-and-iops for the price list everything above is negotiated against.

about this entry

One of sijie's wiki entries. The AI on this site is grounded in the same corpus and answers in sijie's voice, with citations back to entries like this one — answering costs sijie money, so it waits behind a code: enter an access code →

storage — Sijie Wang