Postgres 18 is now available with over 200 changes, but the standout feature is its new asynchronous I/O subsystem.
Performance Gains of 2-3x
The async I/O capability delivers performance improvements of 2 to 3 times faster, depending on workload intensity during disk-memory transfers. This feature frees up CPU cycles for other tasks, enabling parallel query processing and background operations without touching application code.
Benefits include:
- Faster query responses
- Better hardware utilization
- Improved application stability
Enhanced Security Features
Postgres 18 strengthens security with:
- OAuth authentication - simplifies integration with centralized identity platforms
- Retired MD5 - the obsolete hash is finally deprecated
- Expanded SCRAM support - available in more authentication scenarios
Developer-Friendly Improvements
- Kubernetes flexibility: Extensions can now load from any user-specified directory, including network-mounted drives.
- Query optimizer upgrade: Delivers faster execution for complex queries with reduced memory consumption.
