Tag
MotherDuck 的技术博客详细解析 DuckDB 2.0 alpha 版本为何更快，重点介绍了通过独立下载线程池实现的异步 I/O，使 S3 上的 Parquet 查询性能显著提升，并分享了实际基准测试数据。
DuckDB is introducing asynchronous I/O for Parquet and CSV files in v2.0, improving remote storage query performance by avoiding blocking worker threads during data fetches.
PostgreSQL 19 introduces kernel asynchronous reads via io_uring, enabling direct asynchronous buffered I/O for improved performance without dedicated worker processes.
A technical comparison of epoll and io_uring in Linux, explaining their architectures and performance characteristics for asynchronous I/O.
The article explores using mmap to create a magic ring buffer where two contiguous virtual memory ranges map the same physical memory, and tests its compatibility with io_uring's registered buffers, finding that it works as expected.
Zig 0.16 ships a new std.Io interface for cross-platform I/O. The library zio provides a full async implementation using stackful coroutines and OS-level async APIs, enabling efficient concurrent tasks without thread-per-task overhead.