"Centralizing credential management Enabling scalable, role-based access control Strengthening security posture with standards-based authentication Postgres 18 also includes additional security enhancements. This version deprecates MD5 and enables SCRAM authentication in new locations, including connections to other databases via foreign data wrappers, strengthening protection across distributed environments. Advancing SQL standards: More flexibility for modern applications Postgres 18 introduces new enhancements for NOT NULL constraints, foreign keys, and virtual generated columns, improving data integrity"
"and giving developers more options when building applications that need to run across multiple database platforms. These updates make it easier to use Postgres as the foundation for standards-based applications-an important advantage for teams that want portability and long-term maintainability. Optimizer improvements: Smarter query planning with less developer tuning For many years, the Postgres query optimizer saw only modest changes, but recent releases have reversed that trend. In Postgres 18, developers will see:"
Postgres 18 centralizes credential management and enables scalable, role-based access control while strengthening authentication through standards-based methods. MD5 authentication is deprecated and SCRAM authentication is enabled in additional locations, including foreign data wrapper connections, improving security across distributed environments. SQL standard advancements include enhancements to NOT NULL constraints, foreign keys, and virtual generated columns to improve data integrity and portability across database platforms. Optimizer improvements aim to deliver smarter query planning with reduced need for developer tuning, continuing a trend of more significant optimizer development in recent releases.
Read at InfoWorld
Unable to calculate read time
Collection
[
|
...
]