Re: PostgreSQL 15 Beta 1 release announcement draft - Mailing list pgsql-hackers

From Justin Pryzby
Subject Re: PostgreSQL 15 Beta 1 release announcement draft
Date
Msg-id 20220514192658.GV19626@telsasoft.com
Whole thread Raw
In response to PostgreSQL 15 Beta 1 release announcement draft  ("Jonathan S. Katz" <jkatz@postgresql.org>)
Responses Re: PostgreSQL 15 Beta 1 release announcement draft
List pgsql-hackers
On Sat, May 14, 2022 at 02:52:35PM -0400, Jonathan S. Katz wrote:
> PostgreSQL 15 is made generally available, thouh some details of the release can

though

> a SQL standard command for conditionally perform write operations (`INSERT`,

performing

> he [`range_agg`](https://www.postgresql.org/docs/15/functions-aggregate.html)

The

> PostgreSQL system and [TOAST](https://www.postgresql.org/docs/15/storage-toast.html)
> tables, used for storing data that is larger than a single page (8kB), can now
> utilize
> [index deduplication](https://www.postgresql.org/docs/15/btree-implementation.html#BTREE-DEDUPLICATION)
> and benefit from smaller indexes and faster lookups.

IMO this doesn't need to be listed.

> `pg_basebackup` client can now also decompress backups that use LZ4 an Zstandard

and

> Write-ahead log (WAL) files can now be compressed using both LZ4 an Zstandard

and

> configuration parameter. Additionally, PostgreSQL 15 also adds the
> [`recovery_prefetch`](https://www.postgresql.org/docs/15/runtime-config-wal.html#GUC-RECOVERY-PREFETCH)

remove "the" or add "option" ?

> PostgreSQL 15 makes it possible to skip applying changes using the
> [`ALTER SUBSCRIPTION ... SKIP`](https://www.postgresql.org/docs/15/sql-altersubscription.html).

add "command".

> PostgreSQL 15 introduces the
> [`jsonlog` format for
logging](https://www.postgresql.org/docs/15/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-JSONLOG).This allows
PostgreSQLlogs to be consumed by many programs
 
> that perform structured logging aggregation and analysis. PostgreSQL 15 now by

log aggregation?

> default logs checkpoints and slow autovacuum operations.

> PostgreSQL 15 adds support for
> "[security invoker views](https://www.postgresql.org/docs/15/sql-createview.html)",
> which users the privileges of the user executing the query instead of the user

uses



pgsql-hackers by date:

Previous
From: "Jonathan S. Katz"
Date:
Subject: PostgreSQL 15 Beta 1 release announcement draft
Next
From: Ranier Vilela
Date:
Subject: Avoid unecessary MemSet call (src/backend/utils/cache/relcache.c)