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