PostgreSQL 18, released today, dramatically accelerates asynchronous query performance-up to three times faster-and introduces virtual columns, enhancing database flexibility and efficiency.These improvements, alongside bolstered security features, position the latest version as a significant upgrade for developers and database administrators.
The new release addresses growing demands for faster data processing and more adaptable database structures. Asynchronous queries are crucial for handling complex operations without blocking applications, while virtual columns allow for dynamic data views without physically altering the underlying tables. These features benefit a wide range of applications,from data analytics and reporting to high-volume transaction processing. PostgreSQL 18 also prioritizes security with OAuth 2 support, SSL validation with FIPS, and a transition to Scram-Sha-256 for password hashing, phasing out the outdated MD5.
Further enhancements include the ability to easily utilize distant tables based on local schemes with the CREATE FOREIGN TABLE ... LIKE command.Detailed details on PostgreSQL 18 is available in the official announcement and release notes: https://www.postgresql.org/about/news/postgresql-18-released-3142/ and https://www.postgresql.org/docs/18/release-18.html.