Storage layer
How databases keep data
Know exactly when Postgres has your data, and what another transaction can see.
- 01
How Postgres writes a row
From INSERT to bytes on disk.
- 02
The write-ahead log and fsync
Why the log is written before the table.
- 03
B-tree indexes
Why one index makes a query 1,000 times faster.
- 04
Transactions
All or nothing, and what that costs.
- 05
Isolation levels
The anomalies each level allows, with examples.
- 06
MVCC and locks
How readers and writers avoid blocking each other.
- 07
Replication
Copies, lag, and reading your own writes.