A Box of DB
Notes and small tools for database systems work: PostgreSQL plans, optimizer behavior, execution paths, and reproducible tests.
Records
Articles and tools, listed as records rather than filler.
Explore PostgreSQL 14–18 system catalogs, columns, and documented references in a draggable read-only graph.
libpg_query makes PostgreSQL parsing practical, but a system still needs its own AST boundary.
Paste JSON EXPLAIN output and inspect natural-language flow plus plan_most_expensive.
PMR is about allocation locality and lifetime grouping, not single-object ownership.
Templates help DuckDB write one algorithm shape across many physical types.
DuckDB uses ownership, RAII, exceptions, and inheritance where PostgreSQL uses MemoryContext, longjmp, and NodeTag.
C++11 fails at the project boundary, and common DuckDB headers already depend on C++17 features.
Normalize a plan into relational tables, then read estimates, expensive nodes, and data flow through views.