PostgreSQL 18 Released
6 hours ago
- #Open Source
- #PostgreSQL
- #Database
- PostgreSQL 18 released with performance improvements and new features.
- New I/O subsystem improves read performance by up to 3×.
- Major-version upgrades are less disruptive with faster upgrade times.
- Virtual generated columns compute values at query time.
- UUIDv7 function improves indexing and read performance for UUIDs.
- OAuth 2.0 authentication support for easier SSO integration.
- New asynchronous I/O (AIO) subsystem enhances throughput.
- Planner statistics now carry over during major version upgrades.
- Enhanced pg_upgrade utility with parallel processing and faster upgrades.
- Skip scan lookups and OR condition optimizations for faster queries.
- Support for ARM NEON and SVE CPU intrinsics for hardware acceleration.
- Virtual generated columns are now the default.
- Temporal constraints added for PRIMARY KEY and UNIQUE constraints.
- New text processing enhancements including PG_UNICODE_FAST collation.
- OAuth authentication and FIPS mode validation introduced.
- Logical replication improvements including parallel streaming.
- Proactive vacuum strategy reduces overhead.
- EXPLAIN ANALYZE now shows more detailed execution statistics.
- Page checksums enabled by default for new databases.
- New PostgreSQL wire protocol version (3.2) introduced.