# New Feature Overview

> Source chapter 2 for PostgreSQL 9.5.

---

LLMS index: [llms.txt](/en/llms.txt)

---

<div class="feature-source-note"><span class="feature-edition-badge">Alpha 2</span><span><strong>Source pages:</strong> PDF 6-8</span><span><a href="https://github.com/nori-shinoda/documents/blob/1773200c5362476c4a549222b7d17fa91f546cae/postgresql95_alpha2_new_feature_en_20150807-1.pdf">Original PDF on GitHub</a></span></div>

<p class="feature-page-marker" id="pgfeat-9-5-summary-pdf-page-6">PDF page 6</p>

PostgreSQL 9.5 has many new features and improvements.

### 2.1 Improve Performance {#pg9-5-2-1-improve-performance}

Performance has been improved in the following part:

#### Use 128-bit integer for the aggregate functions {#pg9-5-p6-use-128-bit-integer-for-the-aggregate-functions}

#### Index-Only Scan on the GiST index {#pg9-5-p6-index-only-scan-on-the-gist-index}

#### Lock reduction for BTree index {#pg9-5-p6-lock-reduction-for-btree-index}

#### Improve performance of the CRC calculation algorithm {#pg9-5-p6-improve-performance-of-the-crc-calculation-algorithm}

#### Improve performance for sort of text and numeric data type {#pg9-5-p6-improve-performance-for-sort-of-text-and-numeric-data-type}

#### Improve performance for KNN-GiST {#pg9-5-p6-improve-performance-for-knn-gist}

#### Aggressive update of the local xmin {#pg9-5-p6-aggressive-update-of-the-local-xmin}

#### Abbreviated Keys {#pg9-5-p6-abbreviated-keys}

#### and so forth {#pg9-5-p6-and-so-forth}

### 2.2 Added Features {#pg9-5-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) {#pg9-5-p6-row-level-security-3-5}

#### BRIN Index (3.6) {#pg9-5-p6-brin-index-3-6}

#### WAL compression at the Full Page Write (3.3.1) {#pg9-5-p6-wal-compression-at-the-full-page-write-3-3-1}

#### Process name and the database cluster corresponding (3.7.1) {#pg9-5-p6-process-name-and-the-database-cluster-corresponding-3-7-1}

#### Pg_rewind command (3.2.1) {#pg9-5-p6-pg-rewind-command-3-2-1}

#### Improvement the various utilities (3.2) {#pg9-5-p6-improvement-the-various-utilities-3-2}

#### Added Contrib modules (3.1.5) {#pg9-5-p6-added-contrib-modules-3-1-5}

#### Add information for EXPLAIN statement (3.7.2) {#pg9-5-p6-add-information-for-explain-statement-3-7-2}

#### Output log regarding replication command (3.7.3) {#pg9-5-p6-output-log-regarding-replication-command-3-7-3}

#### Standby Actions (3.3.5) {#pg9-5-p6-standby-actions-3-3-5}

#### ASSERT statement on PL/pgSQL (3.4.14) {#pg9-5-p6-assert-statement-on-pl-pgsql-3-4-14}

#### Split parameters checkpoint_segments (3.3.4) {#pg9-5-p6-split-parameters-checkpoint-segments-3-3-4}

#### and so forth {#pg9-5-p6-and-so-forth-2}

### 2.3 SQL Improvements {#pg9-5-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) {#pg9-5-p6-insert-on-conflict-3-4-1}

<p class="feature-page-marker" id="pgfeat-9-5-summary-pdf-page-7">PDF page 7</p>

#### ALTER TABLE SET UNLOGGED (3.4.2) {#pg9-5-p7-alter-table-set-unlogged-3-4-2}

#### IMPORT FOREIGN SCHEMA (3.4.3) {#pg9-5-p7-import-foreign-schema-3-4-3}

#### SEELECT SKIP LOCKED (3.4.4) {#pg9-5-p7-seelect-skip-locked-3-4-4}

#### CREATE FOREIGN TABLE INHERITS (3.4.5) {#pg9-5-p7-create-foreign-table-inherits-3-4-5}

#### ALTER USER CURRENT_USER (3.4.6) {#pg9-5-p7-alter-user-current-user-3-4-6}

#### UPDATE SET enhancement (3.4.7) {#pg9-5-p7-update-set-enhancement-3-4-7}

#### TABLESAMPLE (3.4.8) {#pg9-5-p7-tablesample-3-4-8}

#### REINDEX SCHEMA (3.4.9) {#pg9-5-p7-reindex-schema-3-4-9}

#### REINDEX VERBOSE (3.4.10) {#pg9-5-p7-reindex-verbose-3-4-10}

#### GROUPING SETS, CUBE and ROLLUP (3.4.11) {#pg9-5-p7-grouping-sets-cube-and-rollup-3-4-11}

#### Add jsonb operators (3.4.12) {#pg9-5-p7-add-jsonb-operators-3-4-12}

#### CREATE POLICY (3.5) {#pg9-5-p7-create-policy-3-5}

#### CREATE FOREIGN TABLE (CHECK) (3.4.15) {#pg9-5-p7-create-foreign-table-check-3-4-15}

#### CREATE EVENT TRIGGER enhancement (3.4.16) {#pg9-5-p7-create-event-trigger-enhancement-3-4-16}

#### CREATE | ALTER | COMMENT ON TRANSFORM {#pg9-5-p7-create-alter-comment-on-transform}

#### CREATE | ALTER DATABASE ALLOW_CONNECTIONS {#pg9-5-p7-create-alter-database-allow-connections}

#### CREATE | ALTER DATABASE IS_TEMPLATE {#pg9-5-p7-create-alter-database-is-template}

#### Add IF NOT EXISTS Clause for some statement {#pg9-5-p7-add-if-not-exists-clause-for-some-statement}

#### and so forth {#pg9-5-p7-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](http://www.postgresql.org/docs/9.5/static/release-9-5.html)).

<p class="feature-page-marker" id="pgfeat-9-5-summary-pdf-page-8">PDF page 8</p>

## 3 New Feature Details {#pg9-5-3-new-feature-details}