Re: PostgreSQL 15 release announcement draft

From: Justin Pryzby <pryzby(at)telsasoft(dot)com>
To: "Jonathan S(dot) Katz" <jkatz(at)postgresql(dot)org>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: PostgreSQL 15 release announcement draft
Date: 2022-09-12 19:34:01
Message-ID: 20220912193401.GG31833@telsasoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Sep 12, 2022 at 12:52:49PM -0400, Jonathan S. Katz wrote:
> sorted. Using `row_number()`, `rank()`, and `count()` as
> [window functions](https://www.postgresql.org/docs/15/functions-window.html)
> also have performance benefits in PostgreSQL 15, and queries using

Remove "using" ?

> 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)
> and speed up recovery times. PostgreSQL's built-in backup command,

s/and/to/ ?

> [`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

s/with/and/ ?

> PostgreSQL 15 includes the SQL standard
> [`MERGE`](https://www.postgresql.org/docs/15/sql-merge.html) command.
> `MERGE` lets you write conditional SQL statements that include `INSERT`,
> `UPDATE`, and `DELETE` actions within a single statement.

maybe "include combinations of INSERT, UPDATE and DELETE ..."

> PostgreSQL
> [server-level statistics](https://www.postgresql.org/docs/15/monitoring-stats.html)
> are now collected in shared memory, eliminating both the statistics collector
> process and periodically writing this data to disk.

and *the need to* periodically write this data to disk ?

--
Justin

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2022-09-12 19:39:28 Re: Splitting up guc.c
Previous Message Jonathan S. Katz 2022-09-12 19:26:17 Re: PostgreSQL 15 release announcement draft