PostgreSQL 15

PostgreSQL 15 is the future development version of PostgreSQL, likely to be released in late 2022.

Initial commit marking the start of PostgreSQL 15 development is 596b5af1 (2021-06-28).

CommitFests

Following CommitFests are for PostgreSQL 15 code submissions:

• CommitFest 37 (2022-03-01 - 2021-03-31; future)
• CommitFest 36 (2022-01-01 - 2022-01-31; future)
• CommitFest 35 (2021-11-01 - 2021-11-30; ope)
• CommitFest 34 (2021-09-01 - 2021-09-30; in progress)
• CommitFest 33 (2021-07-01 - 2021-07-31; closed)

Backend changes

General

• the background writer and checkpointer will now also run during crash recovery (commit 7ff23c6d)

postmaster

• option --forkboot renamed to --forkaux (commit 50017f77)
• CREATE privilege on the public schema is now always revoked by default from PUBLIC, and it is now owned by pg_database_owner role (commit b073c3cc)

Data type changes

• NUMERIC scale can be negative or greater than precision (commit 085f931f)

SQL changes

Modified:

• ALTER SUBSCRIPTION
  • parameter two_phase added (commit a8fd13ca)
• ALTER TABLE
  • ALTER TABLE ... SET ACCESS METHOD syntax added (commit b0483263)
• CREATE SUBSCRIPTION
  • parameter two_phase added (commit a8fd13ca)
• SELECT
  • parallle DISTINCT support added (commit 22c4e88e)

System catalog changes

Modified:

• pg_subscription
  • column subtwophasestate added (commit a8fd13ca)

System function changes

Modified:

• pg_stat_reset_single_table_counters()
  • now able to reset statistics for cluster-wide shared tables (commit e0426784)

Configuration changes

Added:

• shared_memory_size (commit bd178805)

Replication changes

Logical replication

• support for prepared transactions added (commit a8fd13ca)
• support for for streaming transactions added (commit 63cf61cd)

Replication protocol

• TWO_PHASE option added to CREATE_REPLICATION_SLOT (commit cda03cfe)

System functions

Added:

• regexp_count() (commit 64243370)
• regexp_instr() (commit 64243370)
• regexp_like() (commit 64243370)
• regexp_substr() (commit 64243370)

Modified:

• pg_size_bytes()
  • able to convert sizes in petabytes (commit ca2e4472)
• pg_size_pretty()
  • able to output sizes in petabytes (commit ca2e4472)
• regexp_replace()
  • starting position (parameter start) and match position (parameter N) added (commit 64243370)

Core utilities

• pg_recvlogical
  • option --two-phase added (commit cda03cfe)

Server utilities

• pg_resetwal
  • option -u/--oldest-transaction-id added (commit 74cf7d46)
• pg_waldump
  • option --rmgr can be specified multiple times (commit c8bf5098)

psql

• new environment variable PSQL_WATCH_PAGER for setting a pager for psql's \watch command (commit 7c09d279)

Contrib modules

• postgres_fdw
  • CASE expressions can be pushed to the remote server (commit 5d44fff0)
  • remote connection's application_name can be set via GUC postgres_fdw.application_name (commit 449ab635)