PostgreSQL 9.5

Major features

  • INSERTs which would generate constraint conflicts can be turned into UPDATEs or ignored ("UPSERT") (commit 168d5805)
  • GROUP BY analysis features GROUPING SETS, CUBE and ROLLUP
  • row level security (RLS) added (commit 491c029d)
  • replication origins for logical decoding (commit 5aa23504)
  • Block Range Indexes (BRIN) (initial commit 7516f525)
  • Performance improvements for sorting and for multi-CPU machines

SQL changes

Added:

Modified:

Backend changes

General

  • errors messages
    • possible matches for mistyped column names will be suggested, if found (commit e529cd4f)
  • Event triggers
    • table_rewrite event added (commit 618c9430)

Hooks

Following hooks added:

Source configuration

  • option --enable-cassert added (commit 3bdcf6a5)

System catalogue changes

Tables

Added:

Modified:

  • pg_authid
    • column rolcatupdate removed (commit bb8582ab)
    • column rolbypassrls added (commit 491c029d)
  • pg_proc
    • column protrftypes added (commit cac76582)
  • pg_seclabel
    • definition of provider column in index pg_seclabel_object_index changed to use text_pattern_ops (commit 0b28ea79)
    • columns provider and label set to NOT NULL (commit 82a532b3)
  • pg_shseclabel
    • definition of provider column in index pg_shseclabel_object_index changed to use text_pattern_ops (commit 0b28ea79)
    • columns provider and label set to NOT NULL (commit 82a532b3)

Views

Added:

Modified:

System functions

Added:

Modified:

Data types

  • regnamespace added as an OID alias for namespaces (initial commit cb9fa802)
  • regrole added as an OID alias for roles (commit 0c90f676)

Configuration changes

Added:

Modified:

Removed:

Replication changes

General

Configuration

Added:

Removed:

Procedural language changes

General:

Foreign data wrapper changes

Server utilities

Added:

Modified:

Core utilities

Modified:

psql changes

The following is a list of significant changes to psql:

Contrib modules

Added:

Modified:

Removed:

Testing

Test modules

From this release, the new source directory src/test/modules/ contains a number of test modules (implemented as extensions and/or SQL tests). Some test modules formerly existed as contrib modules.

Added:

Modified:

Pre-release test versions

Initial commit marking the start of PostgreSQL 9.5 development is ab76208e (2014-06-09).