PostgreSQL 14

PostgreSQL 14 is the future development version of PostgreSQL.

Development work for PostgreSQL 14 began in June 2020 (commit d10b19e2). It is likely to be released in late 2021.

CommitFests

Following CommitFests are for PostgreSQL 14 code submissions:

• CommitFest 32 (2021-03-01 - 2021-03-31; future)
• CommitFest 31 (2021-01-01 - 2021-01-31; future)
• CommitFest 30 (2020-11-01 - 2020-11-30; open)
• CommitFest 29 (2020-09-01 - 2020-09-30; closed)
• CommitFest 28 (2020-07-01 - 2020-07-31; closed)

SQL changes

Modified:

• AS - most keywords to be used as column labels without requiring AS (commit 06a7c315)
• ALTER ROLE
  • CURRENT_ROLE now also accepted in place of a user name (commit 45b98057)
• ALTER USER
  • CURRENT_ROLE now also accepted in place of a user name (commit 45b98057)
• CREATE LANGUAGE
  • obsolete option to specify the language name as a single-quoted string removed (commit 5333e014)
• CREATE TRIGGER
  • OR REPLACE option added (commit 92bf7e2d)
• REINDEX
  • support for partitioned tables and indexes added (commit a6642b3a)

Backend changes

• enhanced COPY performance through improved buffering (commit 0a0727cc)
• improvements in snapshot scalability to handle larger number of connections (commits 5788e258, 1f51c17c, 941697c3, 73487a60, 623a9ba7, 07f32fcd, and dc7420c2)
• stored procedures now support OUT parameters (commit 2453ea14)

System catalogue changes

Views

Added:

• pg_backend_memory_contexts (commit 3e98c0ba)
• pg_stat_replication_slots  (commit 98681675)
• pg_stat_wal (commit 8d9a9359)

Modified:

• pg_prepared_statements
  • column generic_plans added (commit d05b172a)
  • column custom_plans added (commit d05b172a)

System function changes

Added:

• pg_relation_check_pages() (commit f2b88396) feature withdrawn
• pg_stat_reset_replication_slot() (commit 98681675)
• string_to_table() (commit 66f16306)

Modified:

• split_part()
  • support for negative indexes added (commit ec0294fb)

Configuration changes

Modified:

• log_line_prefix
  • %P parameter added to show the parallel group leader (commit b8fdee7d)
• password_encryption
  • default changed from md5 to scram-sha-256 (commit c7eab0e9)
  • legacy values on/true/yes/1 as aliases for md5 no longer valid (commit c7eab0e9)

psql changes

• \di, \dm and \dt commands now display access method name (commit 07f386ed)

Server utilities

Modified:

• pg_waldump
  • contents of logical messages will now also be included in the output (commit 9f1cf97b)

Core utilities

Modified:

• vacuumdb
  • option --no-index-cleanup added (commit 9550ea30)
  • option --no-truncate added (commit 9550ea30)

Contrib modules

Added:

• old_snapshot (commit aecf5ee2)
• pg_surgery (commit 34a947ca)
• bool_perlu (commit 36058a3c)

Modified:

• intarray
  • <@ operator removed from GiST operator classes (commit 20e7e1fe)
• pg_stat_statements
  • now tracks the total number of rows retrieved or affected by CREATE TABLE AS, SELECT INTO, CREATE MATERIALIZED VIEW and FETCH commands (commit 6023b7ea)
  • now tracks the total number of rows processed by REFRESH MATERIALIZED VIEW (commit b62e6056)

Testing

Test modules

Added:

• PL/Sample (commit adbe62d0)