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.