Blogs

Persistent Storage of Adaptive Radix Trees (ART) in DuckDB

duckdb.org

DuckDB uses Adaptive Radix Tree (ART) Indexes to enforce constraints and to speed up query filters. Up to this point, indexes were not persisted, causing issues like loss of indexing information and high reload times for tables with data constraints. We now persist ART Indexes to disk, drastically diminishing database loading times (up to orders of magnitude), and we no longer lose track of existing indexes. This bl…

Visit Site

Blogs duckdb.org