public inbox for [email protected]  

help / color / mirror / Atom feed

PostgreSQL 15 release announcement draft
7+ messages / 3 participants
[nested] [flat]

* PostgreSQL 15 release announcement draft
@ 2022-08-30 19:59  Jonathan S. Katz <[email protected]>
  0 siblings, 1 reply; 7+ messages in thread

From: Jonathan S. Katz @ 2022-08-30 19:59 UTC (permalink / raw)
  To: PostgreSQL Advocacy <[email protected]>

Hi,

Please see the first draft for the PostgreSQL 15 release announcement. 
This is the announcement that goes out when we ship 15.0.

A few notes on the first draft:

1. I have not put in any links yet -- I want to ensure the document is 
close to being static before I add those in.

2. I have left in a blurb about SQL/JSON while awaiting the decision on 
if the feature is included in v15.

Please provide feedback no later than 2022-09-10 0:00 AoE[1]. After this 
date, we will begin assembling the presskit that includes the translations.

Thanks,

Jonathan

[1] https://en.wikipedia.org/wiki/Anywhere_on_Earth

The PostgreSQL Global Development Group today announced the release of
[PostgreSQL 15](https://www.postgresql.org/docs/15/release-15.html), the latest
version of the world’s [most advanced open source database](https://www.postgresql.org/).

PostgreSQL 15 builds on the performance improvements of recent releases with
noticeable gains for managing workloads in both local and distributed
deployments, including improved sorting. This release improves the developer
experience with the addition of the popular `MERGE` command, and adds more
capabilities for observing the state of the database.

<HOLD FOR QUOTE>

[PostgreSQL](https://www.postgresql.org), an innovative data management system
known for its reliability and robustness, benefits from over 25 years of open
source development from a [global developer community](https://www.postgresql.org/community/)
and has become the preferred open source relational database for organizations
of all sizes.

### Improved Sort Performance and Compression

In this latest release, PostgreSQL improves on its in-memory and on-disk sorting
algorithms, with benchmarks showing speedups of 25% - 400% based on sort types.
Using `row_number()`, `rank()`, and `count()` as window functions also have
performance benefits in PostgreSQL 15, and queries using `SELECT DISTINCT` can
now be executed in parallel.

Building on work from the previous PostgreSQL release for allowing async remote
queries, the PostgreSQL foreign data wrapper, `postgres_fdw`, can now commit
transactions in parallel.

The performance improvements in PostgreSQL 15 extend to its archiving and backup
facilities. PostgreSQL 15 adds support for LZ4 and Zstandard (zstd) compression
to write-ahead log (WAL) files, which can have both space and performance
benefits for certain workloads. On certain operating systems, PostgreSQL 15
supports the ability to prefetch WAL file contents and speed up recovery times.
PostgreSQL's built-in backup command, `pg_basebackup`, now supports server-side
compression of backup files with a choice of gzip, LZ4, and zstd. PostgreSQL 15
includes the ability to use custom modules for archiving, which eliminates the
overhead of using a shell command.

### Expressive Developer Features

PostgreSQL 15 includes the SQL standard `MERGE` command. `MERGE` lets you write
conditional SQL statements that include `INSERT`, `UPDATE`, and `DELETE` actions
within a single statement.

PostgreSQL 15 expands on its support for the SQL/JSON standard, including syntax
for supporting JSON constructors, introspection functions, and the ability to
convert JSON data into a table using the `JSON_TABLE` function.

This latest release adds new functions for using regular expressions to inspect
strings: `regexp_count()`, `regexp_instr()`, `regexp_like()`, and
`regexp_substr()`. PostgreSQL 15 also extends the `range_agg` function to
aggregate `multirange` data types, which were introduced in the previous
release.

PostgreSQL 15 lets user create views that query data using the permissions of
the caller, not the view creator. This option, called `security_invoker`, adds
an additional layer of protection to ensure view callers have the correct
permissions for working with the underlying data.

### More Options with Logical Replication

PostgreSQL 15 provides more flexibility for managing logical replication. This
release introduces row and column filtering for publishers, letting users choose
to replicate a subset of data from a table. PostgreSQL 15 adds features to
simplify conflict management, including the ability to skip replaying a
conflicting transaction and to automatically disable a subscription if an error
is detected. This release also includes support for using two-phase commit (2PC)
with logical replication.

### Logging and Configuration Enhancements

PostgreSQL 15 introduces a new logging format: `jsonlog`. This new format
outputs log data using a defined JSON structure, which allows PostgreSQL logs to
be processed in structured logging systems. This release also adds a new
built-in extension, `pg_walinspect`, that lets users inspect the contents of
write-ahead log files directly from a SQL interface.

PostgreSQL 15 gives database administrators more flexibility in how users can
manage PostgreSQL configuration, adding the ability to grant users permission to
alter server-level configuration parameters. Additionally, users can now search
for information about configuration using the `\dconfig` command from the `psql`
command-line tool.

### Other Notable Changes

PostgreSQL server-level statistics are now collected in shared memory,
eliminating the statistics collector process and writing these stats to disk.
PostgreSQL 15 also revokes the `CREATE` permission from all users except a
database owner from the `public` (or default) schema.

PostgreSQL 15 removes both the long-deprecated "exclusive backup" mode and
support for Python 2 from PL/Python.

### About PostgreSQL

[PostgreSQL](https://www.postgresql.org) is the world's most advanced open
source database, with a global community of thousands of users, contributors,
companies and organizations. Built on over 35 years of engineering, starting at
the University of California, Berkeley, PostgreSQL has continued with an
unmatched pace of development. PostgreSQL's mature feature set not only matches
top proprietary database systems, but exceeds them in advanced database
features, extensibility, security, and stability.

### Links

* [Download](https://www.postgresql.org/download/)
* [Release Notes](https://www.postgresql.org/docs/15/release-15.html)
* [Press Kit](https://www.postgresql.org/about/press/)
* [Security Page](https://www.postgresql.org/support/security/)
* [Versioning Policy](https://www.postgresql.org/support/versioning/)
* [Follow @postgresql on Twitter](https://twitter.com/postgresql)


Attachments:

  [text/plain] release.en.md (5.7K, 2-release.en.md)
  download | inline:
The PostgreSQL Global Development Group today announced the release of
[PostgreSQL 15](https://www.postgresql.org/docs/15/release-15.html), the latest
version of the world’s [most advanced open source database](https://www.postgresql.org/).

PostgreSQL 15 builds on the performance improvements of recent releases with
noticeable gains for managing workloads in both local and distributed
deployments, including improved sorting. This release improves the developer
experience with the addition of the popular `MERGE` command, and adds more
capabilities for observing the state of the database.

<HOLD FOR QUOTE>

[PostgreSQL](https://www.postgresql.org), an innovative data management system
known for its reliability and robustness, benefits from over 25 years of open
source development from a [global developer community](https://www.postgresql.org/community/)
and has become the preferred open source relational database for organizations
of all sizes.

### Improved Sort Performance and Compression

In this latest release, PostgreSQL improves on its in-memory and on-disk sorting
algorithms, with benchmarks showing speedups of 25% - 400% based on sort types.
Using `row_number()`, `rank()`, and `count()` as window functions also have
performance benefits in PostgreSQL 15, and queries using `SELECT DISTINCT` can
now be executed in parallel.

Building on work from the previous PostgreSQL release for allowing async remote
queries, the PostgreSQL foreign data wrapper, `postgres_fdw`, can now commit
transactions in parallel.

The performance improvements in PostgreSQL 15 extend to its archiving and backup
facilities. PostgreSQL 15 adds support for LZ4 and Zstandard (zstd) compression
to write-ahead log (WAL) files, which can have both space and performance
benefits for certain workloads. On certain operating systems, PostgreSQL 15
supports the ability to prefetch WAL file contents and speed up recovery times.
PostgreSQL's built-in backup command, `pg_basebackup`, now supports server-side
compression of backup files with a choice of gzip, LZ4, and zstd. PostgreSQL 15
includes the ability to use custom modules for archiving, which eliminates the
overhead of using a shell command.

### Expressive Developer Features

PostgreSQL 15 includes the SQL standard `MERGE` command. `MERGE` lets you write
conditional SQL statements that include `INSERT`, `UPDATE`, and `DELETE` actions
within a single statement.

PostgreSQL 15 expands on its support for the SQL/JSON standard, including syntax
for supporting JSON constructors, introspection functions, and the ability to
convert JSON data into a table using the `JSON_TABLE` function.

This latest release adds new functions for using regular expressions to inspect
strings: `regexp_count()`, `regexp_instr()`, `regexp_like()`, and
`regexp_substr()`. PostgreSQL 15 also extends the `range_agg` function to
aggregate `multirange` data types, which were introduced in the previous
release.

PostgreSQL 15 lets user create views that query data using the permissions of
the caller, not the view creator. This option, called `security_invoker`, adds
an additional layer of protection to ensure view callers have the correct
permissions for working with the underlying data.

### More Options with Logical Replication

PostgreSQL 15 provides more flexibility for managing logical replication. This
release introduces row and column filtering for publishers, letting users choose
to replicate a subset of data from a table. PostgreSQL 15 adds features to
simplify conflict management, including the ability to skip replaying a
conflicting transaction and to automatically disable a subscription if an error
is detected. This release also includes support for using two-phase commit (2PC)
with logical replication.

### Logging and Configuration Enhancements

PostgreSQL 15 introduces a new logging format: `jsonlog`. This new format
outputs log data using a defined JSON structure, which allows PostgreSQL logs to
be processed in structured logging systems. This release also adds a new
built-in extension, `pg_walinspect`, that lets users inspect the contents of
write-ahead log files directly from a SQL interface.

PostgreSQL 15 gives database administrators more flexibility in how users can
manage PostgreSQL configuration, adding the ability to grant users permission to
alter server-level configuration parameters. Additionally, users can now search
for information about configuration using the `\dconfig` command from the `psql`
command-line tool.

### Other Notable Changes

PostgreSQL server-level statistics are now collected in shared memory,
eliminating the statistics collector process and writing these stats to disk.
PostgreSQL 15 also revokes the `CREATE` permission from all users except a
database owner from the `public` (or default) schema.

PostgreSQL 15 removes both the long-deprecated "exclusive backup" mode and
support for Python 2 from PL/Python.

### About PostgreSQL

[PostgreSQL](https://www.postgresql.org) is the world's most advanced open
source database, with a global community of thousands of users, contributors,
companies and organizations. Built on over 35 years of engineering, starting at
the University of California, Berkeley, PostgreSQL has continued with an
unmatched pace of development. PostgreSQL's mature feature set not only matches
top proprietary database systems, but exceeds them in advanced database
features, extensibility, security, and stability.

### Links

* [Download](https://www.postgresql.org/download/)
* [Release Notes](https://www.postgresql.org/docs/15/release-15.html)
* [Press Kit](https://www.postgresql.org/about/press/)
* [Security Page](https://www.postgresql.org/support/security/)
* [Versioning Policy](https://www.postgresql.org/support/versioning/)
* [Follow @postgresql on Twitter](https://twitter.com/postgresql)

  [application/pgp-signature] OpenPGP_signature (840B, 3-OpenPGP_signature)
  download

^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: PostgreSQL 15 release announcement draft
@ 2022-08-31 10:45  Daniel Westermann (DWE) <[email protected]>
  0 siblings, 1 reply; 7+ messages in thread

From: Daniel Westermann (DWE) @ 2022-08-31 10:45 UTC (permalink / raw)
  To: Jonathan S. Katz <[email protected]>; PostgreSQL Advocacy <[email protected]>

>From: Jonathan S. Katz
>Sent: Tuesday, August 30, 2022 21:59
>To: PostgreSQL Advocacy
>Subject: PostgreSQL 15 release announcement draft

>Hi,
>
>Please see the first draft for the PostgreSQL 15 release announcement.
>This is the announcement that goes out when we ship 15.0.
>
>A few notes on the first draft:
>
>1. I have not put in any links yet -- I want to ensure the document is
>close to being static before I add those in.
>
>2. I have left in a blurb about SQL/JSON while awaiting the decision on
>if the feature is included in v15.

>Please provide feedback no later than 2022-09-10 0:00 AoE[1]. After this
>date, we will begin assembling the presskit that includes the translations.

Thank you, just one remark:

PostgreSQL 15 lets user create views -> PostgreSQL 15 lets users create views ?

>Thanks,
>
>Jonathan

Regards
Daniel


^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: PostgreSQL 15 release announcement draft
@ 2022-09-02 01:11  Jonathan S. Katz <[email protected]>
  parent: Daniel Westermann (DWE) <[email protected]>
  0 siblings, 0 replies; 7+ messages in thread

From: Jonathan S. Katz @ 2022-09-02 01:11 UTC (permalink / raw)
  To: Daniel Westermann (DWE) <[email protected]>; PostgreSQL Advocacy <[email protected]>

On 8/31/22 6:45 AM, Daniel Westermann (DWE) wrote:

> Thank you, just one remark:
> 
> PostgreSQL 15 lets user create views -> PostgreSQL 15 lets users create 
> views ?

Thanks. I've attached an updated version that includes other feedback.

Jonathan

The PostgreSQL Global Development Group today announced the release of
[PostgreSQL 15](https://www.postgresql.org/docs/15/release-15.html), the latest
version of the world’s [most advanced open source database](https://www.postgresql.org/).

PostgreSQL 15 builds on the performance improvements of recent releases with
noticeable gains for managing workloads in both local and distributed
deployments, including improved sorting. This release improves the developer
experience with the addition of the popular `MERGE` command, and adds more
capabilities for observing the state of the database.

<HOLD FOR QUOTE>

[PostgreSQL](https://www.postgresql.org), an innovative data management system
known for its reliability and robustness, benefits from over 25 years of open
source development from a [global developer community](https://www.postgresql.org/community/)
and has become the preferred open source relational database for organizations
of all sizes.

### Improved Sort Performance and Compression

In this latest release, PostgreSQL improves on its in-memory and on-disk sorting
algorithms, with benchmarks showing speedups of 25% - 400% based on which data
types are sorted. Using `row_number()`, `rank()`, and `count()` as window functions
also have performance benefits in PostgreSQL 15, and queries using
`SELECT DISTINCT` can now be executed in parallel.

Building on work from the previous PostgreSQL release for allowing async remote
queries, the PostgreSQL foreign data wrapper, `postgres_fdw`, now supports
asynchronous commits.

The performance improvements in PostgreSQL 15 extend to its archiving and backup
facilities. PostgreSQL 15 adds support for LZ4 and Zstandard (zstd) compression
to write-ahead log (WAL) files, which can have both space and performance
benefits for certain workloads. On certain operating systems, PostgreSQL 15
supports the ability to prefetch WAL file contents and speed up recovery times.
PostgreSQL's built-in backup command, `pg_basebackup`, now supports server-side
compression of backup files with a choice of gzip, LZ4, and zstd. PostgreSQL 15
includes the ability to use custom modules for archiving, which eliminates the
overhead of using a shell command.

### Expressive Developer Features

PostgreSQL 15 includes the SQL standard `MERGE` command. `MERGE` lets you write
conditional SQL statements that include `INSERT`, `UPDATE`, and `DELETE` actions
within a single statement.

This latest release adds new functions for using regular expressions to inspect
strings: `regexp_count()`, `regexp_instr()`, `regexp_like()`, and
`regexp_substr()`. PostgreSQL 15 also extends the `range_agg` function to
aggregate `multirange` data types, which were introduced in the previous
release.

PostgreSQL 15 lets users create views that query data using the permissions of
the caller, not the view creator. This option, called `security_invoker`, adds
an additional layer of protection to ensure that view callers have the correct
permissions for working with the underlying data.

### More Options with Logical Replication

PostgreSQL 15 provides more flexibility for managing logical replication. This
release introduces row and column filtering for publishers, letting users choose
to replicate a subset of data from a table. PostgreSQL 15 adds features to
simplify conflict management, including the ability to skip replaying a
conflicting transaction and to automatically disable a subscription if an error
is detected. This release also includes support for using two-phase commit (2PC)
with logical replication.

### Logging and Configuration Enhancements

PostgreSQL 15 introduces a new logging format: `jsonlog`. This new format
outputs log data using a defined JSON structure, which allows PostgreSQL logs to
be processed in structured logging systems. This release also adds a new
built-in extension, `pg_walinspect`, that lets users inspect the contents of
write-ahead log files directly from a SQL interface.

PostgreSQL 15 gives database administrators more flexibility in how users can
manage PostgreSQL configuration, adding the ability to grant users permission to
alter server-level configuration parameters. Additionally, users can now search
for information about configuration using the `\dconfig` command from the `psql`
command-line tool.

### Other Notable Changes

PostgreSQL server-level statistics are now collected in shared memory,
eliminating both the statistics collector process and periodically writing these
stats to disk.

PostgreSQL 15 also revokes the `CREATE` permission from all users except a
database owner from the `public` (or default) schema.

PostgreSQL 15 removes both the long-deprecated "exclusive backup" mode and
support for Python 2 from PL/Python.

### About PostgreSQL

[PostgreSQL](https://www.postgresql.org) is the world's most advanced open
source database, with a global community of thousands of users, contributors,
companies and organizations. Built on over 35 years of engineering, starting at
the University of California, Berkeley, PostgreSQL has continued with an
unmatched pace of development. PostgreSQL's mature feature set not only matches
top proprietary database systems, but exceeds them in advanced database
features, extensibility, security, and stability.

### Links

* [Download](https://www.postgresql.org/download/)
* [Release Notes](https://www.postgresql.org/docs/15/release-15.html)
* [Press Kit](https://www.postgresql.org/about/press/)
* [Security Page](https://www.postgresql.org/support/security/)
* [Versioning Policy](https://www.postgresql.org/support/versioning/)
* [Follow @postgresql on Twitter](https://twitter.com/postgresql)


Attachments:

  [text/plain] release.en.md (5.5K, 2-release.en.md)
  download | inline:
The PostgreSQL Global Development Group today announced the release of
[PostgreSQL 15](https://www.postgresql.org/docs/15/release-15.html), the latest
version of the world’s [most advanced open source database](https://www.postgresql.org/).

PostgreSQL 15 builds on the performance improvements of recent releases with
noticeable gains for managing workloads in both local and distributed
deployments, including improved sorting. This release improves the developer
experience with the addition of the popular `MERGE` command, and adds more
capabilities for observing the state of the database.

<HOLD FOR QUOTE>

[PostgreSQL](https://www.postgresql.org), an innovative data management system
known for its reliability and robustness, benefits from over 25 years of open
source development from a [global developer community](https://www.postgresql.org/community/)
and has become the preferred open source relational database for organizations
of all sizes.

### Improved Sort Performance and Compression

In this latest release, PostgreSQL improves on its in-memory and on-disk sorting
algorithms, with benchmarks showing speedups of 25% - 400% based on which data
types are sorted. Using `row_number()`, `rank()`, and `count()` as window functions
also have performance benefits in PostgreSQL 15, and queries using
`SELECT DISTINCT` can now be executed in parallel.

Building on work from the previous PostgreSQL release for allowing async remote
queries, the PostgreSQL foreign data wrapper, `postgres_fdw`, now supports
asynchronous commits.

The performance improvements in PostgreSQL 15 extend to its archiving and backup
facilities. PostgreSQL 15 adds support for LZ4 and Zstandard (zstd) compression
to write-ahead log (WAL) files, which can have both space and performance
benefits for certain workloads. On certain operating systems, PostgreSQL 15
supports the ability to prefetch WAL file contents and speed up recovery times.
PostgreSQL's built-in backup command, `pg_basebackup`, now supports server-side
compression of backup files with a choice of gzip, LZ4, and zstd. PostgreSQL 15
includes the ability to use custom modules for archiving, which eliminates the
overhead of using a shell command.

### Expressive Developer Features

PostgreSQL 15 includes the SQL standard `MERGE` command. `MERGE` lets you write
conditional SQL statements that include `INSERT`, `UPDATE`, and `DELETE` actions
within a single statement.

This latest release adds new functions for using regular expressions to inspect
strings: `regexp_count()`, `regexp_instr()`, `regexp_like()`, and
`regexp_substr()`. PostgreSQL 15 also extends the `range_agg` function to
aggregate `multirange` data types, which were introduced in the previous
release.

PostgreSQL 15 lets users create views that query data using the permissions of
the caller, not the view creator. This option, called `security_invoker`, adds
an additional layer of protection to ensure that view callers have the correct
permissions for working with the underlying data.

### More Options with Logical Replication

PostgreSQL 15 provides more flexibility for managing logical replication. This
release introduces row and column filtering for publishers, letting users choose
to replicate a subset of data from a table. PostgreSQL 15 adds features to
simplify conflict management, including the ability to skip replaying a
conflicting transaction and to automatically disable a subscription if an error
is detected. This release also includes support for using two-phase commit (2PC)
with logical replication.

### Logging and Configuration Enhancements

PostgreSQL 15 introduces a new logging format: `jsonlog`. This new format
outputs log data using a defined JSON structure, which allows PostgreSQL logs to
be processed in structured logging systems. This release also adds a new
built-in extension, `pg_walinspect`, that lets users inspect the contents of
write-ahead log files directly from a SQL interface.

PostgreSQL 15 gives database administrators more flexibility in how users can
manage PostgreSQL configuration, adding the ability to grant users permission to
alter server-level configuration parameters. Additionally, users can now search
for information about configuration using the `\dconfig` command from the `psql`
command-line tool.

### Other Notable Changes

PostgreSQL server-level statistics are now collected in shared memory,
eliminating both the statistics collector process and periodically writing these
stats to disk.

PostgreSQL 15 also revokes the `CREATE` permission from all users except a
database owner from the `public` (or default) schema.

PostgreSQL 15 removes both the long-deprecated "exclusive backup" mode and
support for Python 2 from PL/Python.

### About PostgreSQL

[PostgreSQL](https://www.postgresql.org) is the world's most advanced open
source database, with a global community of thousands of users, contributors,
companies and organizations. Built on over 35 years of engineering, starting at
the University of California, Berkeley, PostgreSQL has continued with an
unmatched pace of development. PostgreSQL's mature feature set not only matches
top proprietary database systems, but exceeds them in advanced database
features, extensibility, security, and stability.

### Links

* [Download](https://www.postgresql.org/download/)
* [Release Notes](https://www.postgresql.org/docs/15/release-15.html)
* [Press Kit](https://www.postgresql.org/about/press/)
* [Security Page](https://www.postgresql.org/support/security/)
* [Versioning Policy](https://www.postgresql.org/support/versioning/)
* [Follow @postgresql on Twitter](https://twitter.com/postgresql)

  [application/pgp-signature] OpenPGP_signature (840B, 3-OpenPGP_signature)
  download

^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: PostgreSQL 15 release announcement draft
@ 2022-09-12 16:53  Jonathan S. Katz <[email protected]>
  parent: Jonathan S. Katz <[email protected]>
  0 siblings, 1 reply; 7+ messages in thread

From: Jonathan S. Katz @ 2022-09-12 16:53 UTC (permalink / raw)
  To: PostgreSQL Advocacy <[email protected]>

On 8/30/22 3:59 PM, Jonathan S. Katz wrote:
> we will begin assembling the presskit that includes the translations.

Here is a (penultimate?) draft that includes URLs. Please provide any 
additional feedback no later than 2022-09-14 0:00 AoE. After that, we 
will begin the translation process.

Thanks,

Jonathan


The PostgreSQL Global Development Group today announced the release of
[PostgreSQL 15](https://www.postgresql.org/docs/15/release-15.html), the latest
version of the world’s [most advanced open source database](https://www.postgresql.org/).

PostgreSQL 15 builds on the performance improvements of recent releases with
noticeable gains for managing workloads in both local and distributed
deployments, including improved sorting. This release improves the developer
experience with the addition of the popular
[`MERGE`](https://www.postgresql.org/docs/15/sql-merge.html) command, and adds
more capabilities for observing the state of the database.

<HOLD FOR QUOTE>

[PostgreSQL](https://www.postgresql.org), an innovative data management system
known for its reliability and robustness, benefits from over 25 years of open
source development from a [global developer community](https://www.postgresql.org/community/)
and has become the preferred open source relational database for organizations
of all sizes.

### Improved Sort Performance and Compression

In this latest release, PostgreSQL improves on its in-memory and on-disk
[sorting](https://www.postgresql.org/docs/15/queries-order.html) algorithms,
with benchmarks showing speedups of 25% - 400% based on which data types are
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
[`SELECT DISTINCT`](https://www.postgresql.org/docs/15/queries-select-lists.html#QUERIES-DISTINCT)
can now be
[executed in parallel](https://www.postgresql.org/docs/15/parallel-query.html).

Building on work from the [previous PostgreSQL release](https://www.postgresql.org/about/press/presskit14/)
for allowing async remote queries, the
[PostgreSQL foreign data wrapper](https://www.postgresql.org/docs/15/postgres-fdw.html),
[`postgres_fdw`](https://www.postgresql.org/docs/15/postgres-fdw.html),
now supports
[asynchronous commits](https://www.postgresql.org/docs/15/postgres-fdw.html#id-1.11.7.47.11.7).

The performance improvements in PostgreSQL 15 extend to its archiving and backup
facilities. PostgreSQL 15 adds support for LZ4 and Zstandard (zstd)
[compression to write-ahead log (WAL) files](https://www.postgresql.org/docs/15/runtime-config-wal.html#GUC-WAL-COMPRESSION),
which can have both space and performance benefits for certain workloads. On
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,
[`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
zstd. PostgreSQL 15 includes the ability to use
[custom modules for archiving](https://www.postgresql.org/docs/15/archive-modules.html),
which eliminates the overhead of using a shell command.

### Expressive Developer Features

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.

This latest release adds
[new functions for using regular expressions](https://www.postgresql.org/docs/15/functions-matching.html#FUNCTIONS-POSIX-REGEXP)
to inspect strings: `regexp_count()`, `regexp_instr()`, `regexp_like()`, and
`regexp_substr()`. PostgreSQL 15 also extends the `range_agg` function to
aggregate
[`multirange` data types](https://www.postgresql.org/docs/15/rangetypes.html),
which were introduced in the
[previous release](https://www.postgresql.org/about/press/presskit14/).

PostgreSQL 15 lets users
[create views that query data using the permissions of the caller, not the view creator](https://www.postgresql.org/docs/15/sql-createview.html).
This option, called `security_invoker`, adds an additional layer of protection
to ensure that view callers have the correct permissions for working with the
underlying data.

### More Options with Logical Replication

PostgreSQL 15 provides more flexibility for managing
[logical replication](https://www.postgresql.org/docs/15/logical-replication.html).
This release introduces
[row filtering](https://www.postgresql.org/docs/15/logical-replication-row-filter.html)
and
[column filtering](https://www.postgresql.org/docs/15/sql-createpublication.html)
for
[publishers](https://www.postgresql.org/docs/15/logical-replication-publication.html),
letting users choose to replicate a subset of data from a table. PostgreSQL 15
adds features to simplify
[conflict management](https://www.postgresql.org/docs/15/logical-replication-conflicts.html),
including the ability to skip replaying a conflicting transaction and to
automatically disable a subscription if an error is detected. This release also
includes support for using two-phase commit (2PC) with logical replication.

### Logging and Configuration Enhancements

PostgreSQL 15 introduces a new logging format:
[`jsonlog`](https://www.postgresql.org/docs/15/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-JSONLOG).
This new format outputs log data using a defined JSON structure, which allows
PostgreSQL logs to be processed in structured logging systems. This release also
adds a new built-in extension,
[`pg_walinspect`](https://www.postgresql.org/docs/15/pgwalinspect.html), that
lets users inspect the contents of write-ahead log files directly from a SQL
interface.

PostgreSQL 15 gives database administrators more flexibility in how users can
manage PostgreSQL configuration, adding the ability to grant users permission to
alter server-level configuration parameters. Additionally, users can now search
for information about configuration using the `\dconfig` command from the
[`psql`](https://www.postgresql.org/docs/15/app-psql.html) command-line tool.

### Other Notable Changes

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.

PostgreSQL 15 also
[revokes the `CREATE` permission from all users](https://www.postgresql.org/docs/15/ddl-schemas.html#DDL-SCHEMAS-PATTERNS)
except a database owner from the `public` (or default) schema.

PostgreSQL 15 removes both the long-deprecated "exclusive backup" mode and
support for Python 2 from PL/Python.

### About PostgreSQL

[PostgreSQL](https://www.postgresql.org) is the world's most advanced open
source database, with a global community of thousands of users, contributors,
companies and organizations. Built on over 35 years of engineering, starting at
the University of California, Berkeley, PostgreSQL has continued with an
unmatched pace of development. PostgreSQL's mature feature set not only matches
top proprietary database systems, but exceeds them in advanced database
features, extensibility, security, and stability.

### Links

* [Download](https://www.postgresql.org/download/)
* [Release Notes](https://www.postgresql.org/docs/15/release-15.html)
* [Press Kit](https://www.postgresql.org/about/press/)
* [Security Page](https://www.postgresql.org/support/security/)
* [Versioning Policy](https://www.postgresql.org/support/versioning/)
* [Follow @postgresql on Twitter](https://twitter.com/postgresql)


Attachments:

  [text/plain] release.en.md (7.3K, 2-release.en.md)
  download | inline:
The PostgreSQL Global Development Group today announced the release of
[PostgreSQL 15](https://www.postgresql.org/docs/15/release-15.html), the latest
version of the world’s [most advanced open source database](https://www.postgresql.org/).

PostgreSQL 15 builds on the performance improvements of recent releases with
noticeable gains for managing workloads in both local and distributed
deployments, including improved sorting. This release improves the developer
experience with the addition of the popular
[`MERGE`](https://www.postgresql.org/docs/15/sql-merge.html) command, and adds
more capabilities for observing the state of the database.

<HOLD FOR QUOTE>

[PostgreSQL](https://www.postgresql.org), an innovative data management system
known for its reliability and robustness, benefits from over 25 years of open
source development from a [global developer community](https://www.postgresql.org/community/)
and has become the preferred open source relational database for organizations
of all sizes.

### Improved Sort Performance and Compression

In this latest release, PostgreSQL improves on its in-memory and on-disk
[sorting](https://www.postgresql.org/docs/15/queries-order.html) algorithms,
with benchmarks showing speedups of 25% - 400% based on which data types are
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
[`SELECT DISTINCT`](https://www.postgresql.org/docs/15/queries-select-lists.html#QUERIES-DISTINCT)
can now be
[executed in parallel](https://www.postgresql.org/docs/15/parallel-query.html).

Building on work from the [previous PostgreSQL release](https://www.postgresql.org/about/press/presskit14/)
for allowing async remote queries, the
[PostgreSQL foreign data wrapper](https://www.postgresql.org/docs/15/postgres-fdw.html),
[`postgres_fdw`](https://www.postgresql.org/docs/15/postgres-fdw.html),
now supports
[asynchronous commits](https://www.postgresql.org/docs/15/postgres-fdw.html#id-1.11.7.47.11.7).

The performance improvements in PostgreSQL 15 extend to its archiving and backup
facilities. PostgreSQL 15 adds support for LZ4 and Zstandard (zstd)
[compression to write-ahead log (WAL) files](https://www.postgresql.org/docs/15/runtime-config-wal.html#GUC-WAL-COMPRESSION),
which can have both space and performance benefits for certain workloads. On
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,
[`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
zstd. PostgreSQL 15 includes the ability to use
[custom modules for archiving](https://www.postgresql.org/docs/15/archive-modules.html),
which eliminates the overhead of using a shell command.

### Expressive Developer Features

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.

This latest release adds
[new functions for using regular expressions](https://www.postgresql.org/docs/15/functions-matching.html#FUNCTIONS-POSIX-REGEXP)
to inspect strings: `regexp_count()`, `regexp_instr()`, `regexp_like()`, and
`regexp_substr()`. PostgreSQL 15 also extends the `range_agg` function to
aggregate
[`multirange` data types](https://www.postgresql.org/docs/15/rangetypes.html),
which were introduced in the
[previous release](https://www.postgresql.org/about/press/presskit14/).

PostgreSQL 15 lets users
[create views that query data using the permissions of the caller, not the view creator](https://www.postgresql.org/docs/15/sql-createview.html).
This option, called `security_invoker`, adds an additional layer of protection
to ensure that view callers have the correct permissions for working with the
underlying data.

### More Options with Logical Replication

PostgreSQL 15 provides more flexibility for managing
[logical replication](https://www.postgresql.org/docs/15/logical-replication.html).
This release introduces
[row filtering](https://www.postgresql.org/docs/15/logical-replication-row-filter.html)
and
[column filtering](https://www.postgresql.org/docs/15/sql-createpublication.html)
for
[publishers](https://www.postgresql.org/docs/15/logical-replication-publication.html),
letting users choose to replicate a subset of data from a table. PostgreSQL 15
adds features to simplify
[conflict management](https://www.postgresql.org/docs/15/logical-replication-conflicts.html),
including the ability to skip replaying a conflicting transaction and to
automatically disable a subscription if an error is detected. This release also
includes support for using two-phase commit (2PC) with logical replication.

### Logging and Configuration Enhancements

PostgreSQL 15 introduces a new logging format:
[`jsonlog`](https://www.postgresql.org/docs/15/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-JSONLOG).
This new format outputs log data using a defined JSON structure, which allows
PostgreSQL logs to be processed in structured logging systems. This release also
adds a new built-in extension,
[`pg_walinspect`](https://www.postgresql.org/docs/15/pgwalinspect.html), that
lets users inspect the contents of write-ahead log files directly from a SQL
interface.

PostgreSQL 15 gives database administrators more flexibility in how users can
manage PostgreSQL configuration, adding the ability to grant users permission to
alter server-level configuration parameters. Additionally, users can now search
for information about configuration using the `\dconfig` command from the
[`psql`](https://www.postgresql.org/docs/15/app-psql.html) command-line tool.

### Other Notable Changes

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.

PostgreSQL 15 also
[revokes the `CREATE` permission from all users](https://www.postgresql.org/docs/15/ddl-schemas.html#DDL-SCHEMAS-PATTERNS)
except a database owner from the `public` (or default) schema.

PostgreSQL 15 removes both the long-deprecated "exclusive backup" mode and
support for Python 2 from PL/Python.

### About PostgreSQL

[PostgreSQL](https://www.postgresql.org) is the world's most advanced open
source database, with a global community of thousands of users, contributors,
companies and organizations. Built on over 35 years of engineering, starting at
the University of California, Berkeley, PostgreSQL has continued with an
unmatched pace of development. PostgreSQL's mature feature set not only matches
top proprietary database systems, but exceeds them in advanced database
features, extensibility, security, and stability.

### Links

* [Download](https://www.postgresql.org/download/)
* [Release Notes](https://www.postgresql.org/docs/15/release-15.html)
* [Press Kit](https://www.postgresql.org/about/press/)
* [Security Page](https://www.postgresql.org/support/security/)
* [Versioning Policy](https://www.postgresql.org/support/versioning/)
* [Follow @postgresql on Twitter](https://twitter.com/postgresql)

  [application/pgp-signature] OpenPGP_signature (840B, 3-OpenPGP_signature)
  download

^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: PostgreSQL 15 release announcement draft
@ 2022-09-12 17:18  Alvaro Herrera <[email protected]>
  parent: Jonathan S. Katz <[email protected]>
  0 siblings, 1 reply; 7+ messages in thread

From: Alvaro Herrera @ 2022-09-12 17:18 UTC (permalink / raw)
  To: Jonathan S. Katz <[email protected]>; +Cc: PostgreSQL Advocacy <[email protected]>

On 2022-Sep-12, Jonathan S. Katz wrote:

> ### More Options with Logical Replication
> 
> PostgreSQL 15 provides more flexibility for managing
> [logical replication](https://www.postgresql.org/docs/15/logical-replication.html).
> This release introduces
> [row filtering](https://www.postgresql.org/docs/15/logical-replication-row-filter.html)
> and
> [column filtering](https://www.postgresql.org/docs/15/sql-createpublication.html)
> for
> [publishers](https://www.postgresql.org/docs/15/logical-replication-publication.html),
> letting users choose to replicate a subset of data from a table. PostgreSQL 15
> adds features to simplify
> [conflict management](https://www.postgresql.org/docs/15/logical-replication-conflicts.html),
> including the ability to skip replaying a conflicting transaction and to
> automatically disable a subscription if an error is detected. This release also
> includes support for using two-phase commit (2PC) with logical replication.

We avoid the term "column filtering" here; we talk about column lists.
Maybe it could be "This release introduces row filtering for publishers
and the ability to specify an optional column list for each table".
Also, there are docs to this feature:
https://www.postgresql.org/docs/devel/logical-replication-col-lists.html

> ### Logging and Configuration Enhancements
> 
> PostgreSQL 15 introduces a new logging format:
> [`jsonlog`](https://www.postgresql.org/docs/15/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-JSONLOG).
> This new format outputs log data using a defined JSON structure, which allows
> PostgreSQL logs to be processed in structured logging systems. This release also
> adds a new built-in extension,
> [`pg_walinspect`](https://www.postgresql.org/docs/15/pgwalinspect.html), that
> lets users inspect the contents of write-ahead log files directly from a SQL
> interface.

It's very strange to have jsonlog and pg_walinspect in the same
paragraph.  Also, pg_walinspect isn't either logging or configuration.
Maybe put it under "other notable changes"?

-- 
Álvaro Herrera        Breisgau, Deutschland  —  https://www.EnterpriseDB.com/





^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: PostgreSQL 15 release announcement draft
@ 2022-09-12 19:24  Jonathan S. Katz <[email protected]>
  parent: Alvaro Herrera <[email protected]>
  0 siblings, 1 reply; 7+ messages in thread

From: Jonathan S. Katz @ 2022-09-12 19:24 UTC (permalink / raw)
  To: Alvaro Herrera <[email protected]>; +Cc: PostgreSQL Advocacy <[email protected]>

On 9/12/22 1:18 PM, Alvaro Herrera wrote:
> On 2022-Sep-12, Jonathan S. Katz wrote:
> 
>> ### More Options with Logical Replication
>>
>> PostgreSQL 15 provides more flexibility for managing
>> [logical replication](https://www.postgresql.org/docs/15/logical-replication.html).
>> This release introduces
>> [row filtering](https://www.postgresql.org/docs/15/logical-replication-row-filter.html)
>> and
>> [column filtering](https://www.postgresql.org/docs/15/sql-createpublication.html)
>> for
>> [publishers](https://www.postgresql.org/docs/15/logical-replication-publication.html),
>> letting users choose to replicate a subset of data from a table. PostgreSQL 15
>> adds features to simplify
>> [conflict management](https://www.postgresql.org/docs/15/logical-replication-conflicts.html),
>> including the ability to skip replaying a conflicting transaction and to
>> automatically disable a subscription if an error is detected. This release also
>> includes support for using two-phase commit (2PC) with logical replication.
> 
> We avoid the term "column filtering" here; we talk about column lists.
> Maybe it could be "This release introduces row filtering for publishers
> and the ability to specify an optional column list for each table".

I can update this -- will do so in the next pass.

> Also, there are docs to this feature:
> https://www.postgresql.org/docs/devel/logical-replication-col-lists.html

Are they backpatched? They don't appear to be here, and a quick scan of 
REL_15_STABLE doesn't seem to show them:

https://www.postgresql.org/docs/15/logical-replication.html

> 
>> ### Logging and Configuration Enhancements
>>
>> PostgreSQL 15 introduces a new logging format:
>> [`jsonlog`](https://www.postgresql.org/docs/15/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-JSONLOG).
>> This new format outputs log data using a defined JSON structure, which allows
>> PostgreSQL logs to be processed in structured logging systems. This release also
>> adds a new built-in extension,
>> [`pg_walinspect`](https://www.postgresql.org/docs/15/pgwalinspect.html), that
>> lets users inspect the contents of write-ahead log files directly from a SQL
>> interface.
> 
> It's very strange to have jsonlog and pg_walinspect in the same
> paragraph.  Also, pg_walinspect isn't either logging or configuration.
> Maybe put it under "other notable changes"?

Agree that it's strange to put them together. That said, WAL is a form 
of logging (and a very important one at that ;)

I'm fine with pushing it into "other notable changes". Will update with 
another draft later.

Jonathan



Attachments:

  [application/pgp-signature] OpenPGP_signature (840B, 2-OpenPGP_signature)
  download

^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: PostgreSQL 15 release announcement draft
@ 2022-09-12 19:55  Jonathan S. Katz <[email protected]>
  parent: Jonathan S. Katz <[email protected]>
  0 siblings, 0 replies; 7+ messages in thread

From: Jonathan S. Katz @ 2022-09-12 19:55 UTC (permalink / raw)
  To: Alvaro Herrera <[email protected]>; +Cc: PostgreSQL Advocacy <[email protected]>; Justin Pryzby <[email protected]>; Peter Eisentraut <[email protected]>

On 9/12/22 3:24 PM, Jonathan S. Katz wrote:

> I can update this -- will do so in the next pass.

I've made changes per the feedback from you, Peter, & Justin.

>> Also, there are docs to this feature:
>> https://www.postgresql.org/docs/devel/logical-replication-col-lists.html
> 
> Are they backpatched? They don't appear to be here, and a quick scan of 
> REL_15_STABLE doesn't seem to show them:
> 
> https://www.postgresql.org/docs/15/logical-replication.html

I did a better scan and saw it was backpatched here, post Beta 4 tag[1]. 
I captured the link in the docs, but will double-check once RC1 is out.

Please review and let me know your thoughts.

Thanks,

Jonathan

[1] 
https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=25996a82a44629bdedeae73b36c37ee35b37e...

The PostgreSQL Global Development Group today announced the release of
[PostgreSQL 15](https://www.postgresql.org/docs/15/release-15.html), the latest
version of the world’s [most advanced open source database](https://www.postgresql.org/).

PostgreSQL 15 builds on the performance improvements of recent releases with
noticeable gains for managing workloads in both local and distributed
deployments, including improved sorting. This release improves the developer
experience with the addition of the popular
[`MERGE`](https://www.postgresql.org/docs/15/sql-merge.html) command, and adds
more capabilities for observing the state of the database.

<HOLD FOR QUOTE>

[PostgreSQL](https://www.postgresql.org), an innovative data management system
known for its reliability and robustness, benefits from over 25 years of open
source development from a [global developer community](https://www.postgresql.org/community/)
and has become the preferred open source relational database for organizations
of all sizes.

### Improved Sort Performance and Compression

In this latest release, PostgreSQL improves on its in-memory and on-disk
[sorting](https://www.postgresql.org/docs/15/queries-order.html) algorithms,
with benchmarks showing speedups of 25% - 400% based on which data types are
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. Queries using
[`SELECT DISTINCT`](https://www.postgresql.org/docs/15/queries-select-lists.html#QUERIES-DISTINCT)
can now be
[executed in parallel](https://www.postgresql.org/docs/15/parallel-query.html).

Building on work from the [previous PostgreSQL release](https://www.postgresql.org/about/press/presskit14/)
for allowing async remote queries, the
[PostgreSQL foreign data wrapper](https://www.postgresql.org/docs/15/postgres-fdw.html),
[`postgres_fdw`](https://www.postgresql.org/docs/15/postgres-fdw.html),
now supports
[asynchronous commits](https://www.postgresql.org/docs/15/postgres-fdw.html#id-1.11.7.47.11.7).

The performance improvements in PostgreSQL 15 extend to its archiving and backup
facilities. PostgreSQL 15 adds support for LZ4 and Zstandard (zstd)
[compression to write-ahead log (WAL) files](https://www.postgresql.org/docs/15/runtime-config-wal.html#GUC-WAL-COMPRESSION),
which can have both space and performance benefits for certain workloads. On
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)
to speed up recovery times. PostgreSQL's built-in backup command,
[`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
zstd. PostgreSQL 15 includes the ability to use
[custom modules for archiving](https://www.postgresql.org/docs/15/archive-modules.html),
which eliminates the overhead of using a shell command.

### Expressive Developer Features

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 can include `INSERT`,
`UPDATE`, and `DELETE` actions within a single statement.

This latest release adds
[new functions for using regular expressions](https://www.postgresql.org/docs/15/functions-matching.html#FUNCTIONS-POSIX-REGEXP)
to inspect strings: `regexp_count()`, `regexp_instr()`, `regexp_like()`, and
`regexp_substr()`. PostgreSQL 15 also extends the `range_agg` function to
aggregate
[`multirange` data types](https://www.postgresql.org/docs/15/rangetypes.html),
which were introduced in the
[previous release](https://www.postgresql.org/about/press/presskit14/).

PostgreSQL 15 lets users
[create views that query data using the permissions of the caller, not the view creator](https://www.postgresql.org/docs/15/sql-createview.html).
This option, called `security_invoker`, adds an additional layer of protection
to ensure that view callers have the correct permissions for working with the
underlying data.

### More Options with Logical Replication

PostgreSQL 15 provides more flexibility for managing
[logical replication](https://www.postgresql.org/docs/15/logical-replication.html).
This release introduces
[row filtering](https://www.postgresql.org/docs/15/logical-replication-row-filter.html)
and
[column lists](https://www.postgresql.org/docs/15/logical-replication-col-lists.html)
for
[publishers](https://www.postgresql.org/docs/15/logical-replication-publication.html),
letting users choose to replicate a subset of data from a table. PostgreSQL 15
adds features to simplify
[conflict management](https://www.postgresql.org/docs/15/logical-replication-conflicts.html),
including the ability to skip replaying a conflicting transaction and to
automatically disable a subscription if an error is detected. This release also
includes support for using two-phase commit (2PC) with logical replication.

### Logging and Configuration Enhancements

PostgreSQL 15 introduces a new logging format:
[`jsonlog`](https://www.postgresql.org/docs/15/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-JSONLOG).
This new format outputs log data using a defined JSON structure, which allows
PostgreSQL logs to be processed in structured logging systems.

This release gives database administrators more flexibility in how users can
manage PostgreSQL configuration, adding the ability to grant users permission to
alter server-level configuration parameters. Additionally, users can now search
for information about configuration using the `\dconfig` command from the
[`psql`](https://www.postgresql.org/docs/15/app-psql.html) command-line tool.

### Other Notable Changes

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.

PostgreSQL 15 makes it possible to make an
[ICU collation](https://www.postgresql.org/docs/15/collation.html) the default
collation for a cluster or an individual database.

This release also
adds a new built-in extension,
[`pg_walinspect`](https://www.postgresql.org/docs/15/pgwalinspect.html), that
lets users inspect the contents of write-ahead log files directly from a SQL
interface.

PostgreSQL 15 also
[revokes the `CREATE` permission from all users](https://www.postgresql.org/docs/15/ddl-schemas.html#DDL-SCHEMAS-PATTERNS)
except a database owner from the `public` (or default) schema.

PostgreSQL 15 removes both the long-deprecated "exclusive backup" mode and
support for Python 2 from PL/Python.

### About PostgreSQL

[PostgreSQL](https://www.postgresql.org) is the world's most advanced open
source database, with a global community of thousands of users, contributors,
companies and organizations. Built on over 35 years of engineering, starting at
the University of California, Berkeley, PostgreSQL has continued with an
unmatched pace of development. PostgreSQL's mature feature set not only matches
top proprietary database systems, but exceeds them in advanced database
features, extensibility, security, and stability.

### Links

* [Download](https://www.postgresql.org/download/)
* [Release Notes](https://www.postgresql.org/docs/15/release-15.html)
* [Press Kit](https://www.postgresql.org/about/press/)
* [Security Page](https://www.postgresql.org/support/security/)
* [Versioning Policy](https://www.postgresql.org/support/versioning/)
* [Follow @postgresql on Twitter](https://twitter.com/postgresql)


Attachments:

  [text/plain] release.en.md (7.5K, 2-release.en.md)
  download | inline:
The PostgreSQL Global Development Group today announced the release of
[PostgreSQL 15](https://www.postgresql.org/docs/15/release-15.html), the latest
version of the world’s [most advanced open source database](https://www.postgresql.org/).

PostgreSQL 15 builds on the performance improvements of recent releases with
noticeable gains for managing workloads in both local and distributed
deployments, including improved sorting. This release improves the developer
experience with the addition of the popular
[`MERGE`](https://www.postgresql.org/docs/15/sql-merge.html) command, and adds
more capabilities for observing the state of the database.

<HOLD FOR QUOTE>

[PostgreSQL](https://www.postgresql.org), an innovative data management system
known for its reliability and robustness, benefits from over 25 years of open
source development from a [global developer community](https://www.postgresql.org/community/)
and has become the preferred open source relational database for organizations
of all sizes.

### Improved Sort Performance and Compression

In this latest release, PostgreSQL improves on its in-memory and on-disk
[sorting](https://www.postgresql.org/docs/15/queries-order.html) algorithms,
with benchmarks showing speedups of 25% - 400% based on which data types are
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. Queries using
[`SELECT DISTINCT`](https://www.postgresql.org/docs/15/queries-select-lists.html#QUERIES-DISTINCT)
can now be
[executed in parallel](https://www.postgresql.org/docs/15/parallel-query.html).

Building on work from the [previous PostgreSQL release](https://www.postgresql.org/about/press/presskit14/)
for allowing async remote queries, the
[PostgreSQL foreign data wrapper](https://www.postgresql.org/docs/15/postgres-fdw.html),
[`postgres_fdw`](https://www.postgresql.org/docs/15/postgres-fdw.html),
now supports
[asynchronous commits](https://www.postgresql.org/docs/15/postgres-fdw.html#id-1.11.7.47.11.7).

The performance improvements in PostgreSQL 15 extend to its archiving and backup
facilities. PostgreSQL 15 adds support for LZ4 and Zstandard (zstd)
[compression to write-ahead log (WAL) files](https://www.postgresql.org/docs/15/runtime-config-wal.html#GUC-WAL-COMPRESSION),
which can have both space and performance benefits for certain workloads. On
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)
to speed up recovery times. PostgreSQL's built-in backup command,
[`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
zstd. PostgreSQL 15 includes the ability to use
[custom modules for archiving](https://www.postgresql.org/docs/15/archive-modules.html),
which eliminates the overhead of using a shell command.

### Expressive Developer Features

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 can include `INSERT`,
`UPDATE`, and `DELETE` actions within a single statement.

This latest release adds
[new functions for using regular expressions](https://www.postgresql.org/docs/15/functions-matching.html#FUNCTIONS-POSIX-REGEXP)
to inspect strings: `regexp_count()`, `regexp_instr()`, `regexp_like()`, and
`regexp_substr()`. PostgreSQL 15 also extends the `range_agg` function to
aggregate
[`multirange` data types](https://www.postgresql.org/docs/15/rangetypes.html),
which were introduced in the
[previous release](https://www.postgresql.org/about/press/presskit14/).

PostgreSQL 15 lets users
[create views that query data using the permissions of the caller, not the view creator](https://www.postgresql.org/docs/15/sql-createview.html).
This option, called `security_invoker`, adds an additional layer of protection
to ensure that view callers have the correct permissions for working with the
underlying data.

### More Options with Logical Replication

PostgreSQL 15 provides more flexibility for managing
[logical replication](https://www.postgresql.org/docs/15/logical-replication.html).
This release introduces
[row filtering](https://www.postgresql.org/docs/15/logical-replication-row-filter.html)
and
[column lists](https://www.postgresql.org/docs/15/logical-replication-col-lists.html)
for
[publishers](https://www.postgresql.org/docs/15/logical-replication-publication.html),
letting users choose to replicate a subset of data from a table. PostgreSQL 15
adds features to simplify
[conflict management](https://www.postgresql.org/docs/15/logical-replication-conflicts.html),
including the ability to skip replaying a conflicting transaction and to
automatically disable a subscription if an error is detected. This release also
includes support for using two-phase commit (2PC) with logical replication.

### Logging and Configuration Enhancements

PostgreSQL 15 introduces a new logging format:
[`jsonlog`](https://www.postgresql.org/docs/15/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-JSONLOG).
This new format outputs log data using a defined JSON structure, which allows
PostgreSQL logs to be processed in structured logging systems.

This release gives database administrators more flexibility in how users can
manage PostgreSQL configuration, adding the ability to grant users permission to
alter server-level configuration parameters. Additionally, users can now search
for information about configuration using the `\dconfig` command from the
[`psql`](https://www.postgresql.org/docs/15/app-psql.html) command-line tool.

### Other Notable Changes

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.

PostgreSQL 15 makes it possible to make an
[ICU collation](https://www.postgresql.org/docs/15/collation.html) the default
collation for a cluster or an individual database.

This release also
adds a new built-in extension,
[`pg_walinspect`](https://www.postgresql.org/docs/15/pgwalinspect.html), that
lets users inspect the contents of write-ahead log files directly from a SQL
interface.

PostgreSQL 15 also
[revokes the `CREATE` permission from all users](https://www.postgresql.org/docs/15/ddl-schemas.html#DDL-SCHEMAS-PATTERNS)
except a database owner from the `public` (or default) schema.

PostgreSQL 15 removes both the long-deprecated "exclusive backup" mode and
support for Python 2 from PL/Python.

### About PostgreSQL

[PostgreSQL](https://www.postgresql.org) is the world's most advanced open
source database, with a global community of thousands of users, contributors,
companies and organizations. Built on over 35 years of engineering, starting at
the University of California, Berkeley, PostgreSQL has continued with an
unmatched pace of development. PostgreSQL's mature feature set not only matches
top proprietary database systems, but exceeds them in advanced database
features, extensibility, security, and stability.

### Links

* [Download](https://www.postgresql.org/download/)
* [Release Notes](https://www.postgresql.org/docs/15/release-15.html)
* [Press Kit](https://www.postgresql.org/about/press/)
* [Security Page](https://www.postgresql.org/support/security/)
* [Versioning Policy](https://www.postgresql.org/support/versioning/)
* [Follow @postgresql on Twitter](https://twitter.com/postgresql)

  [application/pgp-signature] OpenPGP_signature (840B, 3-OpenPGP_signature)
  download

^ permalink  raw  reply  [nested|flat] 7+ messages in thread

end of thread, other threads:[~2022-09-12 19:55 UTC | newest]

Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-08-30 19:59 PostgreSQL 15 release announcement draft Jonathan S. Katz <[email protected]>
2022-09-12 16:53 ` Jonathan S. Katz <[email protected]>
2022-09-12 17:18   ` Alvaro Herrera <[email protected]>
2022-09-12 19:24     ` Jonathan S. Katz <[email protected]>
2022-09-12 19:55       ` Jonathan S. Katz <[email protected]>
2022-08-31 10:45 Re: PostgreSQL 15 release announcement draft Daniel Westermann (DWE) <[email protected]>
2022-09-02 01:11 ` Jonathan S. Katz <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox