* PostgreSQL 18 introduces an asynchronous I/O (AIO) subsystem. : https://news.ycombinator.com/item?id=43916577

* PostgreSQL 18 now supports parallel builds for GIN indexes, which are commonly used for search over JSON and full-text data.

* Full list: https://www.postgresql.org/docs/18/release-18.html