MotherDuck Blog company blog

Why DuckDB 2.0 is faster

by MotherDuck motherduck.com published 2026-09-10

DuckDB 2.0 alpha vs 1.5.5 on one laptop: recursive CTEs up to 90x, VARIANT 6x faster than JSON text, async I/O 2.4x on S3. What changes, and how to model data to get the speedup. | Reading time: 15 min read

Points

223

HN comments

71

Submissions

1

Cited by

0 commenters

Databases & DataSystems & Performance2026

Related posts from the same era

ICE using Palantir tool that feeds on Medicaid data

EFF Deeplinks20261,475 points969 comments details

Ingesting PDFs and why Gemini 2.0 changes everything

Sergey's Blog20251,303 points447 comments details

Tracking down the 16-year-old WAL-reset SQLite bug

Tailscale Blog20261,223 points239 commentscited by 3 details

Postgres IDE in VS Code

Microsoft Tech Community20251,040 points407 comments details

PGSimCity - How PostgreSQL Works

Nnikolays.github.io2026930 points90 comments details

The DuckDB Local UI

DuckDB Blog2025926 points188 commentscited by 3 details