#Database Architecture • 2 Articles
Articles tagged with #Database Architecture
A curated list of engineering series, deep dives, and notes related to #Database Architecture.
Engineering Database Internals from First Principles • Part 17 2026-10-13
MySQL vs PostgreSQL MVCC: Heap Tuple Versions vs Undo Log Segments
Compare MySQL InnoDB and PostgreSQL MVCC implementations: Undo log version chains vs in-page heap tuples, HOT optimizations, and VACUUM engines.
Engineering Database Internals from First Principles • Part 14 2026-10-02
InnoDB Primary Clustered Indexes vs Secondary Index Lookups (The Double Lookup Cost)
Explore InnoDB clustered index architectures, secondary index lookup mechanics, double lookup costs, and why UUID v4 primary keys degrade database insertion performance.