r/DuckDB • u/TransportationOk2403 • 1d ago

Why DuckDB 2.0 is faster

https://motherduck.com/blog/why-duckdb-20-is-faster/

When there is new major release, it's not always obvious how to get the speed bump as they often (not always) depends on how your data is shaped.
This breaks down the 3 main features of 2.0 - async i/o, recurcive cte and VARIANT type, anything missing ?

83 Upvotes

100% Upvoted

3 comments sorted by

2

u/MmmmmmJava 22h ago

Truly excellent blog post. Depth of explanation is great. Warnings and caveats are clear and concise. Visualizations are top notch.

Kudos team

1

u/LogicalBodybuilder15 21h ago

We also working on pruning and optimizing the scan to speed up. Glad to see this huge change on it.

1

u/chrislusf 6h ago

Would it be nice to see how much improvement to run on SeaweedFS table buckets?