PostgreSQL 18 – Release Notes
8 hours ago
- #Performance
- #PostgreSQL
- #Database
- PostgreSQL 18 introduces an asynchronous I/O (AIO) subsystem to improve performance for operations like sequential scans and vacuums.
- Optimizer statistics are now retained during pg_upgrade, enhancing database migration processes.
- Support for 'skip scan' lookups allows more efficient use of multicolumn B-tree indexes.
- Virtual generated columns, which compute values during read operations, are now the default.
- OAuth authentication support has been added, expanding security options.
- Enhanced support for RETURNING clauses in INSERT, UPDATE, DELETE, and MERGE commands with OLD and NEW references.
- Introduction of temporal constraints for PRIMARY KEY, UNIQUE, and FOREIGN KEY constraints.
- Data checksums are now enabled by default in initdb, with an option to disable them.
- Changes in time zone abbreviation handling prioritize the current session's settings.
- MD5 password authentication is deprecated, with warnings now issued when used.