PostgreSQL 12

Minor version releases

Major features

SQL changes

General:

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 commit tag must have valid commit value (provided: 49f06d79ef831ffa333f908f6d3debdb654292414))

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