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; open)
• CommitFest 35 (2021-11-01 - 2021-11-30; closed)
• CommitFest 34 (2021-09-01 - 2021-09-30; closed)
• 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)

Partitioning changes

• foreign key triggers now created for partitioned tables as well as their partitions (commit f4566345)

SQL changes

Modified:

• ALTER PUBLICATION
  • syntax FOR ALL TABLES IN SCHEMA added (commit 5a283246)
• ALTER SUBSCRIPTION
  • parameter two_phase added (commit a8fd13ca)
• ALTER TABLE
  • ALTER TABLE ... SET ACCESS METHOD syntax added (commit b0483263)
  • foreign key ON DELETE SET ... actions can be provided with an explicit column list (commit d6f96ed9)
• CREATE PUBLICATION
  • syntax FOR ALL TABLES IN SCHEMA added (commit 5a283246)
• CREATE SUBSCRIPTION
  • parameter two_phase added (commit a8fd13ca)
• CREATE TABLE
  • foreign key ON DELETE SET ... actions can be provided with an explicit column list (commit d6f96ed9)
• SELECT
  • paralllel DISTINCT support added (commit 22c4e88e)
• SET
  • a WARNING will be emitted when setting a non-existing setting with a prefix reserved by an extension (commit 75d22069)

System catalog changes

Tables

Modified:

• pg_constraint
  • column confdelsetcols added (commit d6f96ed9)
• pg_database
  • column datlastsysoid removed (commit ab4fd4f8)
• pg_subscription
  • column subtwophasestate added (commit a8fd13ca)

Views

Added:

• pg_stat_subscription_workers (commit 8d74fc96)

System function changes

Added:

• pg_ls_logicalsnapdir() (commit 1922d7c6)
• pg_ls_logicalmapdir() (commit 1922d7c6)
• pg_ls_replslotdir() (commit 1922d7c6)
• regexp_count() (commit 64243370)
• regexp_instr() (commit 64243370)
• regexp_like() (commit 64243370)
• regexp_substr() (commit 64243370)

Modified:

• pg_log_backend_memory_contexts()
  • non-superusers can be granted execution permissions (commit f0b051e3)
• pg_size_bytes()
  • able to convert sizes in petabytes (commit ca2e4472)
• pg_size_pretty()
  • able to output sizes in petabytes (commit ca2e4472)
• pg_stat_reset_single_table_counters()
  • now able to reset statistics for cluster-wide shared tables (commit e0426784)
• regexp_replace()
  • starting position (parameter start) and match position (parameter N) added (commit 64243370)

Configuration changes

Added:

• allow_in_place_tablespaces (commit 7170f215)
• shared_memory_size (commit bd178805)
• shared_memory_size_in_huge_pages (commit 43c1c4f6)

Modified:

• log_autovacuum_min_duration
  • default changed from -1 to 10m (commit 64da07c4)
• log_checkpoints
  • default value changed to on (commit 64da07c4)
• log_destination
  • option jsonlog added (dc686681)

Users / roles

• pg_checkpointer default role added (commit 4168a474)

Replication changes

Logical replication

• support for prepared transactions added (commit a8fd13ca)
• support for for streaming prepared transactions added (commit 63cf61cd)
• support for publishing all tables of a schema added (commit 5a283246)

Replication protocol

• TWO_PHASE option added to CREATE_REPLICATION_SLOT (commit cda03cfe)

Core utilities

• pg_basebackup
  • new COPY subprotocol implemented (commit cc333f32)
  • option --compress extended to accept a compression method and an optional compression level (commit 5c649fe1)
  • option -t/--target added (commit 3500ccc3)
• pg_dump
  • option --no-table-access-method added (commit 21586288)
  • support for dumping from versions older than PostgreSQL 9.2 removed (commit 30e7c175)
  • option --no-synchronized-snapshots removed (commit 2a712066)
• pg_dumpall
  • option --no-table-access-method added (commit 21586288)
  • support for dumping from versions older than PostgreSQL 9.2 removed (commit 30e7c175)
• pg_receivewal
  • option --compression-method added (commit d62bcc8b)
  • support for LZ4 compression added (commit babbbb59)
• pg_recvlogical
  • option --two-phase added (commit cda03cfe)
• pg_restore
  • option --no-table-access-method added (commit 21586288)

Server utilities

• pg_resetwal
  • option -u/--oldest-transaction-id added (commit 74cf7d46)
• pg_upgrade
  • option -N/--no-sync added (commit 3d5ffccb)
  • relfilenodes and tablespace OIDs preserved (commit 9a974cbc)
  • support for upgrading from versions older than PostgreSQL 9.2 removed (commit e469f0aa)
• pg_waldump
  • option --rmgr can be specified multiple times (commit c8bf5098)
  • stats summary now emitted on receipt of SIGINT (commit f2c52eeb)

psql

• new environment variable PSQL_WATCH_PAGER for setting a pager for psql's \watch command (commit 7c09d279)
• \getenv slash command added (commit 33d3eead)
• \lo_list/\dl now display large objects' ACLs when the + option is provided (commit 328dfbda)
• support for versions before PostgreSQL 9.2 removed (commit cf0cab86)

Contrib modules

• btree_gist
  • bool opclass added to allow creating GiST indexes on boolean columns (commit 57e3c516)
• 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)
  • postgres_fdw.application_name can include escape sequences (commit 6e0cb3de)
  • report warning when timeout expiration occurs while retrieving a query result (commit 815d61fc)