Skip to content

2 New Feature Overview

Source chapter 2 for PostgreSQL 9.5.
Alpha 2Source pages: PDF 6-8Original PDF on GitHub

PDF page 6

PostgreSQL 9.5 has many new features and improvements.

2.1 Improve Performance

Performance has been improved in the following part:

Use 128-bit integer for the aggregate functions

Index-Only Scan on the GiST index

Lock reduction for BTree index

Improve performance of the CRC calculation algorithm

Improve performance for sort of text and numeric data type

Improve performance for KNN-GiST

Aggressive update of the local xmin

Abbreviated Keys

and so forth

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.

Row Level Security (3.5)

BRIN Index (3.6)

WAL compression at the Full Page Write (3.3.1)

Process name and the database cluster corresponding (3.7.1)

Pg_rewind command (3.2.1)

Improvement the various utilities (3.2)

Added Contrib modules (3.1.5)

Add information for EXPLAIN statement (3.7.2)

Output log regarding replication command (3.7.3)

Standby Actions (3.3.5)

ASSERT statement on PL/pgSQL (3.4.14)

Split parameters checkpoint_segments (3.3.4)

and so forth

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.

INSERT ON CONFLICT (3.4.1)

PDF page 7

ALTER TABLE SET UNLOGGED (3.4.2)

IMPORT FOREIGN SCHEMA (3.4.3)

SEELECT SKIP LOCKED (3.4.4)

CREATE FOREIGN TABLE INHERITS (3.4.5)

ALTER USER CURRENT_USER (3.4.6)

UPDATE SET enhancement (3.4.7)

TABLESAMPLE (3.4.8)

REINDEX SCHEMA (3.4.9)

REINDEX VERBOSE (3.4.10)

GROUPING SETS, CUBE and ROLLUP (3.4.11)

Add jsonb operators (3.4.12)

CREATE POLICY (3.5)

CREATE FOREIGN TABLE (CHECK) (3.4.15)

CREATE EVENT TRIGGER enhancement (3.4.16)

CREATE | ALTER | COMMENT ON TRANSFORM

CREATE | ALTER DATABASE ALLOW_CONNECTIONS

CREATE | ALTER DATABASE IS_TEMPLATE

Add IF NOT EXISTS Clause for some statement

and so forth

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

PDF page 8

3 New Feature Details