Learn extra at:
- Centralizing credential administration
- Enabling scalable, role-based entry management
- Strengthening safety posture with standards-based authentication
Postgres 18 additionally contains further safety enhancements. This model deprecates MD5 and permits SCRAM authentication in new places, together with connections to different databases through overseas information wrappers, strengthening safety throughout distributed environments.
Advancing SQL requirements: Extra flexibility for contemporary purposes
Postgres 18 introduces new enhancements for NOT NULL constraints, overseas keys, and digital generated columns, bettering information 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 vital 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 adjustments, however current releases have reversed that development. In Postgres 18, builders will see: