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