DuckDB Internals: Why is DuckDB Fast? (Part 1)
Summary
This Greybeam article is a technical deep-dive into DuckDB, an in-process analytical SQL database. It explains why DuckDB is fast, covering design choices such as in-process execution, columnar storage with zone maps, vectorized execution, morsel-driven parallelism, and optimistic MVCC, and discusses data access patterns for Parquet, CSV, and in-process querying.