2026-11-02·por 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.

sobre esta entrada

Una de las entradas de wiki de sijie. La IA en este sitio está anclada en el mismo corpus y responde en la voz de sijie, con citas que vuelven a entradas como esta — responder le cuesta dinero a sijie, así que espera detrás de un código: ingrese código de acceso →