- Centralizing credential administration
- Enabling scalable, role-based entry management
- Strengthening safety posture with standards-based authentication
Postgres 18 additionally consists of further 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 purposes
Postgres 18 introduces new enhancements for NOT NULL constraints, international keys, and digital generated columns, enhancing information integrity and giving builders extra choices when constructing purposes that have to run throughout a number of database platforms. These updates make it simpler to make use of Postgres as the muse for standards-based purposes—an essential 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: