What Does Freezing a Row Mean in PostgreSQL?
A short explanation of frozen rows, transaction ID wraparound, and why vacuum needs to freeze old tuple metadata.
Polished articles
Longer writeups on databases, systems programming, performance, and storage internals.
A short explanation of frozen rows, transaction ID wraparound, and why vacuum needs to freeze old tuple metadata.
How Parquet represents nested JSON data using flattened columns, repetition levels, and definition levels.
Notes from the OSTEP homework on discovering TLB cache sizes and miss costs