Pins tagged “performance”

A practical walk through DuckDB internals, starting with why running in process avoids client protocol overhead and then following SQL through parsing, binding, optimization, physical planning, pipelines, and storage.

There is also a second part from the series which goes further into DuckDB's vectorized execution engine, precompiled inner loops, SIMD, and push based pipelines.

Ulrich Drepper's classic long-form guide to how modern memory hardware actually works: CPU caches, cache coherency, virtual memory, NUMA, and the concrete techniques you can use to write cache-friendly code. Dated in a few specifics but still the single best foundation for reasoning about memory performance on today's machines.