Blog / databases

Posts tagged databases

2 posts filed under this topic.

• MVCC Is a Time Machine With a Cleanup Problem — How PostgreSQL gives every transaction a consistent snapshot, why Repeatable Read still allows write skew, what Serializable actually adds, and why a long transaction is a vacuum emergency. 2026-11-03 · 18 min read
• The Index Is Not a Magic Wand — Adding an index can make a query slower. A deep dive into PostgreSQL storage, B-tree internals, planner costs, composite indexes, write amplification, and the operational habits that keep an index set honest. 2026-10-24 · 18 min read