PostgreSQL 16 released

Post Syndicated from corbet original https://lwn.net/Articles/944516/

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