PostgreSQL has just released its latest version, Postgres 18, continuing a tradition of major updates each fall. This database software is wildly popular among developers, with over 15,000 people naming it their favorite in the 2025 Stack Overflow Developer Survey. The new release features over 200 updates, thanks to the efforts of 110 contributors—a boost in both features and community involvement compared to last year.

One of the biggest highlights is the new asynchronous I/O system. This feature helps speed up how data moves between disks and memory, which is a common bottleneck in databases. Early tests show it can double or even triple performance for some tasks. But it’s not just about raw speed. It also allows the CPU to work on other things while waiting for data to load, making the whole system more responsive and efficient. For businesses, this means faster queries, better handling of large data analysis, and more efficient use of hardware—all without changing existing applications.

Enhanced Security with Built-in OAuth

Another major upgrade is the addition of OAuth authentication. Many big companies now use centralized identity systems like Okta or LDAP, which manage user access securely and easily. Now, Postgres can directly support OAuth, making it simpler for companies to integrate their existing login systems. This helps reduce operational complexity and improves security by adhering to modern standards. Plus, the update deprecates older, less secure methods like MD5 and strengthens protections for distributed setups with new support for SCRAM authentication, including connections through foreign data wrappers.

Better SQL Standards Support and Smarter Query Planning

Postgres 18 also improves how it handles data integrity. It introduces new options for not-null constraints, foreign keys, and generated columns, making it easier to build portable applications that work across different database systems. These enhancements are especially helpful for teams that rely on standards-based data management and want to keep things flexible.

The query optimizer, which decides how to run complex database queries, has received significant improvements. It now plans and executes complex queries faster and with less memory. This means less manual tuning for developers and better performance for mixed-use systems that handle both transactions and analytics. These updates help Postgres stay competitive for large-scale data processing.

Postgres 18 also boosts its ecosystem, especially for those running databases in cloud environments like Kubernetes. Extensions can now be loaded from any directory, even network-mounted drives, which simplifies deployment and updates. This is a big step for developers creating new index types or experimenting with advanced analytics. The collaboration with Kubernetes contributors ensures that new extensions are easier to manage, making Postgres more adaptable and scalable.

Looking ahead, Postgres 18 sets a strong foundation for future innovations. Its growing community of contributors means ongoing improvements in analytics, tooling, and performance. For anyone modernizing systems, building real-time data pipelines, or working with AI, this latest version offers a faster, more secure, and more flexible platform than ever before.

Inspired by

• https://www.infoworld.com/article/4062619/the-best-new-features-in-postgres-18.html

Sources

• gmpg.org
• pixabay.com
• postgresql.org
• stackoverflow.co
• enterprisedb.com