Version 16
of the PostgreSQL database manager has been released.
PostgreSQL 16 contains many new features and enhancements, including:
- Allow parallelization of FULL and internal right OUTER hash joins
- Allow logical replication from standby servers
- Allow logical replication subscribers to apply large transactions in parallel
- Allow monitoring of I/O statistics using the new pg_stat_io view
- Add SQL/JSON constructors and identity functions
- Improve performance of vacuum freezing
- Add support for regular expression matching of user and database
names in pg_hba.conf, and user names in pg_ident.conf
Source: LWN.net – PostgreSQL 16 released