DuckDB 2.0 Performance: Async I/O, Recursive CTEs & VARIANT Explained
- admin / 2 months
- 0
- 29 min read
DuckDB 2.0 is shaping up to be a significant release for analytical workloads. Beyond raw execution speed, the new version changes how DuckDB handles remote files, recursive queries, semi-structured data, and database-side operations. This guide explores async I/O for S3 and Parquet, faster recursive CTE execution, the new VARIANT type, and several smaller features that could affect real-world data pipelines.
