The PostgreSQL team has released version 18 of the open source database.
According to the announcement, PostgreSQL 18 offers improved performance through “a new I/O subsystem that has demonstrated up to 3× performance improvements when reading from storage.” This new asynchronous I/O subsystem “lets PostgreSQL issue multiple I/O requests concurrently instead of waiting for each to finish in sequence.”
Other PostgreSQL 18 features include:
- Faster upgrade times
- Improved text processing
- A uuidv7() function for improved indexing and read performance for UUIDs
- Easier integration with single-sign on (SSO) systems with support for OAuth 2.0 authentication
- Accelerated query performance
Learn more at PostgreSQL.
