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.
Databases · systems · performance
Technical notes, experiments, and active-recall braindumps about the lower layers of software.
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.
How PostgreSQL vacuum works, and what I got wrong along the way
How PAX-style layouts and Parquet organize data for analytics, and what I got wrong along the way
How two-phase locking controls concurrent transactions, and what I got wrong along the way
How databases handle multiple clients at once, and what I got wrong along the way