PostgreSQL 18 Released
5 hours ago
- #SQL
- #PostgreSQL
- #Database
- PostgreSQL 18 introduces an asynchronous I/O (AIO) subsystem to improve performance for operations like sequential scans and vacuums.
- New features include virtual generated columns, OAuth authentication support, and temporal constraints for PRIMARY KEY, UNIQUE, and FOREIGN KEY.
- Enhancements in pg_upgrade include retaining optimizer statistics and parallel processing of database checks.
- Performance improvements include better handling of many partitions, incremental sorts for merge joins, and SIMD processing for JSON strings.
- Security updates include deprecation of MD5 password authentication and new OAuth authentication method.
- New system views and functions for monitoring I/O, WAL, and memory usage, including pg_aios and pg_stat_io.
- SQL and PL/pgSQL enhancements like OLD/NEW support in RETURNING clauses and regex functions with named arguments.
- Libpq and psql updates include new connection parameters, pipeline query support, and expanded mode for list commands.
- Extension improvements include pg_stat_statements tracking for SET values and new functions in pgcrypto.
- Compatibility changes include removal of support for OpenSSL versions older than 1.1.1 and HPPA/PA-RISC architecture.