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
  • Block Range Indexes (BRIN) (initial commit 7516f525)
  • Performance improvements for sorting and for multi-CPU machines

SQL changes

Added:

Modified:

Backend changes

General

Hooks

Following hooks added:

System catalogue changes

Tables

Added:

Modified:

Views

Added:

Modified:

System functions

Added:

  • pg_last_committed_xact() (commit 73c986ad)
  • pg_xact_commit_timestamp() (commit 73c986ad)

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:

  • AsciiDoc output mode added (commit 9d9991c8)
  • prompt option %l added, which displays the current statement line number (commit 51bb7956)
  • \pset option pager_min_lines added (commit 7655f4cc)
  • unicode  column, header, and border linestyle controls added  (commit a2dabf0e)
  • basic tab completion support for SET search_path (commit bd409519)
  • \db+ shows tablespace size in PostgreSQL 9.2 and later (commit ee80f043)

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: