PostgreSQL 9.6

Major features

  • Parallel execution of sequential scans, joins and aggregates
  • VACUUM FREEZE avoids unnecessary page scans
  • synchronous replication can use multiple standby servers for increased reliability
  • full text search able to search for phrases (multiple adjacent words)
  • postgres_fdw supports remote joins, sorts, UPDATEs, and DELETEs

SQL changes

Modified:

Performance changes

Backend changes

Storage parameters

Added:

Hooks

Following hook added:

System catalogue changes

Tables

Added:

Modified:

Views

Added:

Modified:

System function changes

Added:

Modified

Vacuum changes

Configuration changes

Added:

Modified:

Full text search changes

  • Phrase full text search via the <-> operator added (commit bb140506)

Foreign data wrapper changes

  • UPDATE or DELETE commands can be executed entirely on the remote server (commit 0bf3ae88)
  • remote foreign joins performed only when the affected tables will be accessed under the same role ID (commit 45639a05)

Users/roles

Server utilities

Modified:

  • initdb
    • speed up by using only one backend for post-bootstrap steps (commit c4a8812c)
  • pg_rewind
    • supports resynchronisation with a lower target timeline (commit e50cda78)

Core utilities

Modified:

  • pg_basebackup
    • option --slot added to reserve a replication slot before the backup is started (commit 0dc848b0)
  • pg_restore
    • option -t/--table now matches all types of relations (commit 5671aaca)
    • option --strict-names added (commit d0242602)

psql changes

  • support for multiple and mixed -c and -f options added (commit d5563d7d)
  • \crosstabview added which prints the results of a query in a cross-tabulated display (initial commit c09b18f2)
  • \errverbose command added which shows the last server error at full verbosity (commit 3cc38ca7)
  • \ev and \sv commands added for editing/showing view definitions (commit 8eb6407a)
  • \gexec command added which executes a query and re-submits the result(s) as new queries (commit 2bbe9112)
  • tab completion now considers the entire query, not just the current line (commit d854118c)
  • prompt option %p added, which displays the PID of the connected backend (commit 275f05c9)
  • display of the CONTEXT field of messages can be controlled by the new variable SHOW_CONTEXT (commit 0426f349)

Contrib modules

Added:

Modified:

Testing

Test modules

Added: