- Centralization of credential management
- Permit scalable control of role -based access
- Strengthening the attitude of security by means of verification based on standards
Postgres 18 also includes further security improvements. This version depreciates the MD5 and allows you to verify the depressions in new locations, including connecting to other databases through foreign data packaging, which strengthens protection across distributed mixes.
Strengthening SQL standards: Greater flexibility for modern applications
Postgres 18 introduces new improvements for non -zero restrictions, foreign keys and virtual columns, improves data integrity, and give developers more options in creating that need to run on multiple database platforms. These updates make it easier to use Postgres as the basis for standard-important applications for teams that want portability and long-term maintenance.
Improvement of Optimizer: smarter queries planning with a smaller tuning developer
For many years, the Optimizer of Postgres Query Optimizer has only seen modest changes, but the recent edition has turned this trend. In Postgres 18, developers will see: