TLDR · PROGRAMMING, DESIGN & DATA SCIENCE
GET EXCITED ABOUT POSTGRES 18
Summary from the TLDR newsletter
Postgres18 adds asynchronous I/O, which means faster reads for many use cases. This is a part of a bigger series of performance improvements planned. Asynchronous I/O allows workers to optimize idle time and improve system throughput by batching reads. It provides a more predictable and better-performing method for batching operations at the database level. Writes will continue to be synchronous as this is needed for ACID compliance.