From 4d593e6956b387a00e3493c7a3454049c1968058 Mon Sep 17 00:00:00 2001 From: "Jonathan S. Katz" Date: Mon, 12 Sep 2022 17:25:16 -0400 Subject: [PATCH] Update description of recovery prefetch feature Reviewed-by: David Rowley --- releases/15/release.en.md | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/releases/15/release.en.md b/releases/15/release.en.md index 229f6ad..66e9e1a 100644 --- a/releases/15/release.en.md +++ b/releases/15/release.en.md @@ -22,7 +22,7 @@ of all sizes. In this latest release, PostgreSQL improves on its in-memory and on-disk [sorting](https://www.postgresql.org/docs/15/queries-order.html) algorithms, with benchmarks showing speedups of 25% - 400% based on which data types are -sorted. Using `row_number()`, `rank()`, and `count()` as +sorted. Using `row_number()`, `rank()`, `dense_rank()`, and `count()` as [window functions](https://www.postgresql.org/docs/15/functions-window.html) also have performance benefits in PostgreSQL 15. Queries using [`SELECT DISTINCT`](https://www.postgresql.org/docs/15/queries-select-lists.html#QUERIES-DISTINCT) @@ -40,9 +40,9 @@ The performance improvements in PostgreSQL 15 extend to its archiving and backup facilities. PostgreSQL 15 adds support for LZ4 and Zstandard (zstd) [compression to write-ahead log (WAL) files](https://www.postgresql.org/docs/15/runtime-config-wal.html#GUC-WAL-COMPRESSION), which can have both space and performance benefits for certain workloads. On -certain operating systems, PostgreSQL 15 supports the ability to -[prefetch WAL file contents](https://www.postgresql.org/docs/15/runtime-config-wal.html#GUC-RECOVERY-PREFETCH) -to speed up recovery times. PostgreSQL's built-in backup command, +certain operating systems, PostgreSQL 15 adds support to +[prefetch pages referenced in WAL](https://www.postgresql.org/docs/15/runtime-config-wal.html#GUC-RECOVERY-PREFETCH) +to help speed up recovery times. PostgreSQL's built-in backup command, [`pg_basebackup`](https://www.postgresql.org/docs/15/app-pgbasebackup.html), now supports server-side compression of backup files with a choice of gzip, LZ4, and zstd. PostgreSQL 15 includes the ability to use -- 2.39.5