PostgreSQL 16 released

Version 16of 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 databasenames in pg_hba.conf, and user names in pg_ident.conf