Date: Mon, 17 May 2021 12:24:10 -0500
From: Justin Pryzby <pryzby@telsasoft.com>
To: "Jonathan S. Katz" <jkatz@postgresql.org>
Cc: pgsql-advocacy@lists.postgresql.org
Subject: Re: PostgreSQL 14 Beta 1 release announcement draft
Message-ID: <20210517172410.GH373@telsasoft.com>
References: <f82ccf97-d02c-0974-27b8-e0f5e4c1de02@postgresql.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <f82ccf97-d02c-0974-27b8-e0f5e4c1de02@postgresql.org>
User-Agent: Mutt/1.9.4 (2018-02-28)
Archived-At: 
 <https://www.postgresql.org/message-id/20210517172410.GH373%40telsasoft.com>
Precedence: bulk

On Mon, May 17, 2021 at 10:15:56AM -0400, Jonathan S. Katz wrote:
> This release has significant improvements in transaction throughput in
> PostgreSQL systems that have large numbers of connections to the database,
> regardless if they are active or idle.

regardless of whether
(I think)

> indexes. [GiST indexes](https://www.postgresql.org/docs/14/indexes-types.html#INDEXES-TYPE-GIST)
> can now use pre-sorted data during their build process, allowing both for faster
> index creation and smaller indexes.

Instead of "use pre-sorted" I think it should say "can now pre-sort.."

> [SP-GiST indexes](https://www.postgresql.org/docs/14/indexes-types.html#INDEXES-TYPE-SPGIST)
> now support [covering indexes](https://www.postgresql.org/docs/14/indexes-index-only-scans.html)
> that allow users to add additional, nonsearchable columns to the index through
> the `INCLUDE` clause.

*in the index

> PostgreSQL 14. This new release adds more capabilities to [extended statistics](https://www.postgresql.org/docs/14/planner-stats.html),
> which can now be used on [expressions](https://www.postgresql.org/docs/14/view-pg-stats-ext-exprs.html).

can be *created on expressions

> PostgreSQL has supported compression on its "oversized data" columns (i.e. the
> [TOAST](https://www.postgresql.org/docs/14/storage-toast.html) system) for
> decades, but this release adds the ability to now choose to use
> [LZ4 compression](https://www.postgresql.org/docs/14/sql-createtable.html) on
> tables.

say "on TOAST tables", otherwise it sounds like what's new is "tables"
rather than "LZ4".

> PostgreSQL 14 includes numerous improvements on what information can be
> monitored, including the ability to track progress on `COPY` using the
> [`pg_stat_progress_copy`](https://www.postgresql.org/docs/14/progress-reporting.html#COPY-PROGRESS-REPORTING)
> view. This release lets WAL activity be tracked from the [`pg_stat_wal`](https://www.postgresql.org/docs/14/monitoring-stats.html#MONITORING-PG-STAT-WAL-VIEW)

"allows WAL activity to be tracked"

> The [`REINDEX`](https://www.postgresql.org/docs/14/sql-reindex.html) command in

in *PostgreSQL 14

> of waiting for them to be completed. The [`ALTER SUBSCRIPTION`](https://www.postgresql.org/docs/14/sql-altersubscription.html)
> makes it easier to add/remove publications using the new `ADD/DROP PUBLICATION`]
> syntax.

missing "command"

> PostgreSQL 14 now adds a general subscripting framework for retrieving

remove "now"

As usual, Erik already reported half of my typos ;)

-- 
Justin