- 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 allows SCRAM authentication in new places, together with connections to different databases through international knowledge 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, bettering knowledge integrity and giving builders extra choices when constructing purposes that must 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:
