From 9cf244960bd41fdacf83d73fd5b7f9b1d0012128 Mon Sep 17 00:00:00 2001 From: "Jonathan S. Katz" Date: Wed, 23 Aug 2023 13:53:14 -0400 Subject: [PATCH] Revisions to PostgreSQL 16 release Reviewed-by: jian he Reviewed-by: David Rowley Reviewed-by: Daniel Gustafsson Reviewed-by: Dave Cramer --- releases/16/release.en.md | 20 ++++++++++---------- 1 file changed, 10 insertions(+), 10 deletions(-) diff --git a/releases/16/release.en.md b/releases/16/release.en.md index 01ace6f..b36edb6 100644 --- a/releases/16/release.en.md +++ b/releases/16/release.en.md @@ -1,12 +1,12 @@ September 14, 2023 - The PostgreSQL Global Development Group today announced the -release of PostgreSQL 16, the latest version of the world’s most advanced open +release of PostgreSQL 16, the latest version of the world's most advanced open source database. PostgreSQL 16 raises its performance, with notable improvements to query parallelism, bulk data loading, and logical replication. There are many features in this release for developers and administrators alike, including more SQL/JSON syntax, new monitoring stats for your workloads, and greater flexibility in -defining access control rules for large scale workloads. +defining access control rules for management of policies across large fleets. @@ -20,9 +20,9 @@ for organizations of all sizes. PostgreSQL 16 improves the performance of existing PostgreSQL functionality through new query planner optimizations. In this latest release, the query planner can parallelize `FULL` and `RIGHT` joins, utilize incremental sorts for -`SELECT DISTINCT` queries, and execute window functions more efficiently. It -also introduces `RIGHT` and `OUTER` "anti-joins", which enable users to identify -rows not present in a joined table. +`SELECT DISTINCT` queries, and optimize window function executions so they +execute more efficiently. It also introduces `RIGHT` and `OUTER` "anti-joins", +which enable users to identify rows not present in a joined table. This release includes improvements for bulk loading using `COPY` in both single and concurrent operations, with tests showing up to a 300% performance @@ -80,10 +80,10 @@ the impact of your I/O operations on your system. PostgreSQL 16 helps simplify how you can analyze this data with the new pg_stat_io view, which tracks key I/O statistics such as shared_buffer hits and I/O latency. -Additionally, this release adds a new field to the pg_stat_all_tables view, -capturing a timestamp representing when a table or index was last scanned. +Additionally, this release adds a new field to the `pg_stat_all_tables` view +that records a timestamp representing when a table or index was last scanned. PostgreSQL also makes auto_explain more readable by logging values passed into -parameterized statements, and improves accuracy of pg_stat_activity’s +parameterized statements, and improves accuracy of pg_stat_activity's normalization algorithm. ### Access Control & Security @@ -97,7 +97,7 @@ This release adds several security-oriented client connection parameters, including require_auth, which allows clients to specify which authentication parameters they are willing to accept from a server, and `sslrootcert="system"`, which indicates that PostgreSQL should use the trusted certificate authority -(CA) store provided by the client’s operating system. Additionally, the release +(CA) store provided by the client's operating system. Additionally, the release adds support for Kerberos credential delegation, allowing extensions such as `postgres_fdw` and `dblink` to use authenticated credentials to connect to trusted services. @@ -134,7 +134,7 @@ resources: There are several ways you can download PostgreSQL 16, including: -* The [Official Downloads](https://www.postgresql.org/download/) page, with contains installers and tools for [Windows](https://www.postgresql.org/download/windows/), [Linux](https://www.postgresql.org/download/), [macOS](https://www.postgresql.org/download/macosx/), and more. +* The [Official Downloads](https://www.postgresql.org/download/) page, with contains installers and tools for [Windows](https://www.postgresql.org/download/windows/), [Linux](https://www.postgresql.org/download/linux/), [macOS](https://www.postgresql.org/download/macosx/), and more. * [Source Code](https://www.postgresql.org/ftp/source/v16.0) Other tools and extensions are available on the -- 2.39.5