Notes and articles about how databases store, query, and coordinate data.
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.
Topic
Storage engines, file formats, concurrency control, MVCC, and query execution.
Notes and articles about how databases store, query, and coordinate data.
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
What linearizability means in distributed systems, and what I got wrong along the way
How SQLite processes a query from SQL text to results, and what I got wrong along the way
How LSM trees trade read performance for fast writes, and what I got wrong along the way