Why DuckDB 2.0 is faster

DuckDB 2.0 has improved performance by 2-5x compared to its predecessor, thanks to several key optimizations. The new version includes a reworked query optimizer, improved memory management, and better support for parallel processing. Additionally, DuckDB 2.0 has added support for more data types and improved performance on certain workloads such as data aggregation and filtering. The reworked query optimizer uses a combination of techniques such as reordering of joins and the use of indexes to improve performance. The improved memory management allows for more efficient use of memory and reduces the overhead of memory allocation and deallocation. DuckDB 2.0 also includes several new features such as support for data types like timestamp and interval, as well as improved support for parallel processing which allows for faster execution of complex queries. The new version has been tested on a variety of workloads and has shown significant performance improvements.