PostgreSQL 16, the next major update of the open source relational database, has arrived in a beta release, highlighted by enhancements in query execution, logical replication, developer experience, and security.
PostgreSQL 16 Beta 1 was published on May 25. The new release improves query execution with more query parallelism, allowing parallel execution of
RIGHT joins and parallel execution of the
array_agg aggregate functions. PostgreSQL 16 can use incremental sorts in
SELECT DISTINCT queries, and improves performance of concurrent bulk loading of data using
COPY by as much as 300%, the PostgreSQL Development Group said.