Why DuckDB 2.0 is faster
Summary
DuckDB 2.0 introduces async I/O for S3, a rewritten recursive CTE engine, and a shredded VARIANT data type, delivering 2x–3x faster S3 reads and major improvements for deep hierarchy queries. The post gives benchmark results, modeling guidance, and release highlights to help operators optimize data pipelines without changing queries.