Waiting for Postgres 18: Accelerating Disk Reads with Asynchronous I/O

With the Postgres 18 Beta 1 release this week, a multi-year effort and significant architectural shift in Postgres is taking shape: Asynchronous I/O (AIO). These capabilities are still under active development, but they represent a fundamental change in how Postgres handles I/O, offering the potential for significant performance gains, particularly in cloud environments where latency is often the

[tmatsuu]

PostgreSQL 18で非同期IOに対応、cold cacheで2〜3倍のパフォーマンス改善。デフォルトはworkerになるので18に上げるだけで性能向上、さらにio_uringに変えればより高性能に。わいわい