TLDR Tech / Data
DuckDB Internals: Why is DuckDB Fast? (Part 2 Vectorized Execution)
DuckDB is fast because it processes data in cache-friendly batches of 2,048 rows instead of one row at a time. Its vector formats, selection vectors, precompiled operations, and push-based pipelines reduce copying, function-call overhead, and parallel execution costs.
Read the full story