From 3b5151bf42b22467b3a801df70556daa9d7e8617 Mon Sep 17 00:00:00 2001 From: "Jonathan S. Katz" Date: Wed, 22 Sep 2021 10:23:37 -0400 Subject: [PATCH] Incorporated feedback on PG 14 press release Reviewed-by: Laurenz Albe Reviewed-by: Justin Pryzby --- releases/14/release.en.md | 28 +++++++++++++--------------- 1 file changed, 13 insertions(+), 15 deletions(-) diff --git a/releases/14/release.en.md b/releases/14/release.en.md index 1504206..b9a425f 100644 --- a/releases/14/release.en.md +++ b/releases/14/release.en.md @@ -41,8 +41,8 @@ multiranges, and other data types can be extended to use multirange support. PostgreSQL 14 provides a significant throughput boost on workloads that use many connections, with some benchmarks showing a 2x speedup. This release continues -on the recent improvements the overall management of B-tree indexes by reducing -index bloat on tables with [frequently updated indexes](https://www.postgresql.org/docs/14/btree-implementation.html#BTREE-DELETION). +on the recent improvements to the overall management of B-tree indexes by +reducing index bloat on tables with [frequently updated indexes](https://www.postgresql.org/docs/14/btree-implementation.html#BTREE-DELETION). PostgreSQL 14 introduces the ability to [pipeline queries](https://www.postgresql.org/docs/14/libpq-pipeline-mode.html) to a database, which can significantly improve performance over high latency @@ -60,9 +60,9 @@ PostgreSQL 14 also adds several other performance enhancements to the logical decoding system that powers logical replication. [Foreign data wrappers](https://www.postgresql.org/docs/14/sql-createforeigndatawrapper.html), -used to work with federated workloads across PostgreSQL and other databases, can -now leverage query parallelism in PostgreSQL 14. This release implements this -ability in the [`postgres_fdw`](https://www.postgresql.org/docs/14/postgres-fdw.html), +which are used for working with federated workloads across PostgreSQL and other +databases, can now leverage query parallelism in PostgreSQL 14. This release +implements this ability in the [`postgres_fdw`](https://www.postgresql.org/docs/14/postgres-fdw.html), the foreign data wrapper that interfaces with other PostgreSQL databases. In addition to supporting query parallelism, `postgres_fdw` can now also bulk @@ -72,14 +72,13 @@ directive. ### Administration and Observability -PostgreSQL 14 extends its performance gains to its [vacuuming](https://www.postgresql.org/docs/14/routine-vacuuming.html) -system. This release includes optimizations for reducing overhead from B-trees -indexes and now allows autovacuum to analyze partitioned tables and propagate -information to its parents. [`ANALYZE`](https://www.postgresql.org/docs/14/sql-analyze.html), -used to collect database statistics, now runs significantly faster in -PostgreSQL 14 due to its own performance improvements. +PostgreSQL 14 extends its performance gains to the [vacuuming](https://www.postgresql.org/docs/14/routine-vacuuming.html) +system, including optimizations for reducing overhead from B-Trees. +[`ANALYZE`](https://www.postgresql.org/docs/14/sql-analyze.html), used to +collect database statistics, now runs significantly faster in PostgreSQL 14 due +to its own performance improvements. -The choice of compression for PostgreSQL's [TOAST](https://www.postgresql.org/docs/14/storage-toast.html) +Compression for PostgreSQL's [TOAST](https://www.postgresql.org/docs/14/storage-toast.html) system, which is used to store larger data like blocks of text or geometries, can [now be configured](https://www.postgresql.org/docs/14/runtime-config-client.html#GUC-DEFAULT-TOAST-COMPRESSION). PostgreSQL 14 adds LZ4 compression for TOAST columns while retaining support for @@ -107,9 +106,8 @@ to execute parallel queries. Additionally, queries that use nested loop joins may see performance benefits through additional caching that is added in PostgreSQL 14. -The [extended systems](https://www.postgresql.org/docs/14/planner-stats.html#PLANNER-STATS-EXTENDED) -includes many improvements in PostgreSQL 14, including the ability to apply -extend statistics on expressions. Additionally, +[Extended statistics](https://www.postgresql.org/docs/14/planner-stats.html#PLANNER-STATS-EXTENDED) +can now be used in PostgreSQL 14 for expressions. Additionally, [window functions](https://www.postgresql.org/docs/14/functions-window.html) can now benefit from incremental sorts, a feature that was introduced in [PostgreSQL 13](https://www.postgresql.org/about/news/postgresql-13-released-2077/). -- 2.39.5