Re: PostgreSQL 15 release announcement draft
От | Justin Pryzby |
---|---|
Тема | Re: PostgreSQL 15 release announcement draft |
Дата | |
Msg-id | 20220912193401.GG31833@telsasoft.com обсуждение исходный текст |
Ответ на | Re: PostgreSQL 15 release announcement draft ("Jonathan S. Katz" <jkatz@postgresql.org>) |
Ответы |
Re: PostgreSQL 15 release announcement draft
|
Список | 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
В списке pgsql-hackers по дате отправления: