PostgreSQL 12

Minor version releases

Major features

SQL changes

Modified:

General changes

Optimizer

  • most-common-value statistics option for statistic objects added (commit 7300a699)

Performance

Partitioning changes

Compatibility changes

  • OIDs are no longer be available as row-level attributes; the OID column on system catalogue tables has become an ordinary column
  • recovery.conf items have been integrated into the main PostgreSQL configuration file structure (commit 2dedf4d9)
  • jit now on by default

Backend changes

System catalogue changes

Tables

General

Added:

Modified:

Views

Added:

Modified:

System functions

Added:

Changed:

  • pg_config()
    • function behavior marked as stable (previously: immutable; commit 290e3b77)

Data types

Added:

Removed:

Configuration changes

Added:

Modified:

Removed:

Vacuum changes

Replication changes

Replication slots

  • Replication slots (both physical and logical) can now be copied (commit 49f06d79)

Replication configuration changes

recovery.conf items have been integrated into the main PostgreSQL configuration file structure (commit 2dedf4d9).

Server utilities

Added:

Modified:

Core utilties

Modified:

psql changes

  • \dP command to list partitioned tables and indexes added (commit 1c5d9270)
  • CSV table output mode added (commit aa2ba50c)
  • link to online manual page displayed in psql's \help output (commit 27f3dea6)

Contrib modules

Modified:

Removed:

Source code

  • C99 support required (commit d9dd406f)

Testing

Test modules

Added:

Pre-release test versions