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
