- Centralizing credential administration
- Enabling scalable, role-based entry management
- Strengthening safety posture with standards-based authentication
Postgres 18 additionally consists of extra safety enhancements. This model deprecates MD5 and permits SCRAM authentication in new areas, together with connections to different databases by way of international information wrappers, strengthening safety throughout distributed environments.
Advancing SQL requirements: Extra flexibility for contemporary functions
Postgres 18 introduces new enhancements for NOT NULL constraints, international keys, and digital generated columns, bettering information integrity and giving builders extra choices when constructing functions that must run throughout a number of database platforms. These updates make it simpler to make use of Postgres as the inspiration for standards-based functions—an necessary benefit for groups that need portability and long-term maintainability.
Optimizer enhancements: Smarter question planning with much less developer tuning
For a few years, the Postgres question optimizer noticed solely modest modifications, however latest releases have reversed that pattern. In Postgres 18, builders will see:
