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