public inbox for [email protected]  

help / color / mirror / Atom feed

From: Justin Pryzby <[email protected]>
To: Jonathan S. Katz <[email protected]>
Cc: [email protected]
Subject: Re: PostgreSQL 14 Beta 1 release announcement draft
Date: Mon, 17 May 2021 12:24:10 -0500
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>

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

view thread (12+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: PostgreSQL 14 Beta 1 release announcement draft
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox