PostgreSQL 16 released

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