2 New Feature Overview

PDF page 6

PostgreSQL 9.6 has many new features and improvements.

2.1 Improve Performance

Performance has been improved in the following part:

Use quicksort to external sort

Estimate accuracy improvement of the GROUP BY clause

Use a foreign key to the predicted join

Writing performance improvement such as checkpoint and bgwriter

The execution of the Index Only Scan with

partial indexes

Speed up CREATE INDEX CONCURRENTLY statement

And so force

2.2 Added Features

The major additional features are listed below. The number in parentheses is the number of the chapter in this document for details.

Parallel Seq Scan (3.5)

Monitoring Wait Stats (3.6)

Enhancement of FOREIGN DATA WRAPPER object (3.7)

Synchronous replication with multiple synchronous standby servers (3.8)

Avoid Full-Table Vacuum (3.1.4)

Snapshot Too Old implementation by configurable timeout (3.3.1)

Improvement of various Contrib module (3.1.3)

Improvement of various utilities (3.2)

Catalog for Activity of WAL receiver (3.1.1)

Generic WAL Records

Non-exclusive base online backup (3.4.7)

And so force

PDF page 7

2.3 SQL Improvements

The following SQL statements are newly supported. The number in parentheses is the number of the chapter in this document for details.

COPY enhancement (3.4.1)

ALTER TABLE ADD COLUMN enhancement (3.4.2)

ALTER TABLESPACE SET enhancement (3.4.3)

CREATE EXTENSION enhancement (3.4.4)

ALTER OPERATOR enhancement (3.4.5)

CREATE / ALTER FUNCTION PARALLEL SAFE / UNSAFE (3.5)

CREATE ACCESS METHOD statement added

CREATE TABLE … LIKE enhancement

Added functions (3.4.6 / 3.4.7)

And so force

Other new features are described in the PostgreSQL 9.6 Beta Documentation Appendix E. Release Notes (http://www.postgresql.org/docs/9.6/static/release-9-6.html).

PDF page 8

3 New Feature Details