TX_022· Engineering
Postgres 18's async I/O subsystem hits 3x on sequential scans
Postgres 18 introduced an asynchronous I/O subsystem that issues parallel I/O requests instead of waiting on each one. Benchmarks show up to 3x gains on seq scans, bitmap heap scans, and vacuum.