logoalt Hacker News

fragebogen • today at 3:33 PM • 2 replies • view on HN

>DuckDB 2.0 introduces asynchronous I/O for reading Parquet and CSV files.

Sorry, does this mean that their own duckdb format already supports async or doesn't?


Replies

adrian_b • today at 3:39 PM

For now, the latter:

> Other formats, such as JSON files and DuckDB's native database format, use synchronous I/O.

For the future:

> Most of its benefit comes from accessing remote data, but cold local reads can also benefit, albeit less. Next, we plan to add async reads for JSON and DuckDB-native files, as these are the two other formats most relevant to DuckDB core. Formats that live in out-of-tree extensions are not on the roadmap yet.

pdet • today at 6:09 PM

The DuckDB format supports Async I/O.

Disclaimer: I'm the DuckDB developer who implemented Async I/O for parquet, csvs and the DuckDB Format.