# PostgreSQL 9.6 New Features

> Beta 1 source edition · 53 pages · 2016-06-06

---

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

---

<div class="feature-book-intro"><p class="feature-book-kicker">WITH EXAMPLES · ENGLISH SOURCE EDITION</p><p>Explore the features, SQL examples, and compatibility changes documented by <a href="https://github.com/nori-shinoda">Noriyoshi Shinoda</a>.</p><div class="feature-book-actions"><a class="feature-read-button" href="01-about-this-document/">Start reading <span aria-hidden="true">→</span></a><a href="/en/_print/9.6/">Print this book</a><a href="https://github.com/nori-shinoda/documents/blob/1773200c5362476c4a549222b7d17fa91f546cae/postgresql96_beta1_new_features_en_20160606-1.pdf">Original PDF on GitHub</a></div></div>

<div class="feature-source-note"><span class="feature-edition-badge">Beta 1</span><span>2016-06-06</span><span>53 PDF pages</span><span>13 chapters</span></div>

> This book describes the **Beta 1** source document. Its examples and compatibility notes reflect that snapshot.

## Contents

- [1 About This Document](/en/9.6/01-about-this-document/)
- [2 New Feature Overview](/en/9.6/02-new-feature-overview/)
- [3 Architecture](/en/9.6/03-architecture/)
- [4 Utilities](/en/9.6/04-utilities/)
- [5 Changes of Parameters](/en/9.6/05-changes-of-parameters/)
- [6 Enhancement for SQL Statement](/en/9.6/06-enhancement-for-sql-statement/)
- [7 Parallel Seq Scan](/en/9.6/07-parallel-seq-scan/)
- [8 Monitoring Wait Stats](/en/9.6/08-monitoring-wait-stats/)
- [9 Enhancement of FOREIGN DATA WRAPPER](/en/9.6/09-enhancement-of-foreign-data-wrapper/)
- [10 Multiple Synchronous Standby Servers](/en/9.6/10-multiple-synchronous-standby-servers/)
- [11 Security](/en/9.6/11-security/)
- [12 Bibliography](/en/9.6/12-bibliography/)
- [13 Modification History](/en/9.6/13-modification-history/)

## Reference indexes

The opening chapter includes the first numbered table, [Table 1](/en/9.6/01-about-this-document/#pg9-6-tbl-1). The indexes below collect the book's other native numbered components.

<details class="feature-index"><summary>Tables</summary>

- [Table 1](/en/9.6/01-about-this-document/#pg9-6-tbl-1) — Version
- [Table 2](/en/9.6/01-about-this-document/#pg9-6-tbl-2) — Examples notation
- [Table 3](/en/9.6/01-about-this-document/#pg9-6-tbl-3) — Syntax rule
- [Table 4](/en/9.6/03-architecture/#pg9-6-tbl-4) — Added system Catalogs
- [Table 5](/en/9.6/03-architecture/#pg9-6-tbl-5) — pg\_config Catalog
- [Table 6](/en/9.6/03-architecture/#pg9-6-tbl-6) — pg\_stat\_wal\_receiver Catalog
- [Table 7](/en/9.6/03-architecture/#pg9-6-tbl-7) — pg\_stat\_progress\_vacuum Catalog
- [Table 8](/en/9.6/03-architecture/#pg9-6-tbl-8) — pg\_init\_privs Catalog
- [Table 9](/en/9.6/03-architecture/#pg9-6-tbl-9) — Modified catalogs
- [Table 10](/en/9.6/03-architecture/#pg9-6-tbl-10) — Added column to pg\_replication\_slots Catalog
- [Table 11](/en/9.6/03-architecture/#pg9-6-tbl-11) — Added columns to pg\_stat\_activity Catalog
- [Table 12](/en/9.6/03-architecture/#pg9-6-tbl-12) — Added column to pg\_proc Catalog
- [Table 13](/en/9.6/03-architecture/#pg9-6-tbl-13) — Added columns to pg\_aggregate Catalog
- [Table 14](/en/9.6/03-architecture/#pg9-6-tbl-14) — Columns of pg\_am Catalog
- [Table 15](/en/9.6/03-architecture/#pg9-6-tbl-15) — Changed in Contrib modules
- [Table 16](/en/9.6/03-architecture/#pg9-6-tbl-16) — Functions in the pg\_visibility module
- [Table 17](/en/9.6/04-utilities/#pg9-6-tbl-17) — Added and modified backslash commands
- [Table 18](/en/9.6/05-changes-of-parameters/#pg9-6-tbl-18) — Added Parameters
- [Table 19](/en/9.6/05-changes-of-parameters/#pg9-6-tbl-19) — Changed Parameters
- [Table 20](/en/9.6/05-changes-of-parameters/#pg9-6-tbl-20) — Parameters the default value of which is changed
- [Table 21](/en/9.6/06-enhancement-for-sql-statement/#pg9-6-tbl-21) — Added functions
- [Table 22](/en/9.6/07-parallel-seq-scan/#pg9-6-tbl-22) — Related parameters for parallel processing
- [Table 23](/en/9.6/07-parallel-seq-scan/#pg9-6-tbl-23) — The output of the EXPLAIN statement
- [Table 24](/en/9.6/07-parallel-seq-scan/#pg9-6-tbl-24) — Major PARALLEL UNSAFE standard functions
- [Table 25](/en/9.6/07-parallel-seq-scan/#pg9-6-tbl-25) — Major RESTRICTED PARALLEL SAFE standard functions
- [Table 26](/en/9.6/08-monitoring-wait-stats/#pg9-6-tbl-26) — The value of wait\_event\_type column

</details>

<details class="feature-index"><summary>Examples</summary>

- [Example 1](/en/9.6/03-architecture/#pg9-6-eg-1) — Query for pg\_config Catalog
- [Example 2](/en/9.6/03-architecture/#pg9-6-eg-2) — Query for pg\_stat\_wal\_receiver Catalog
- [Example 3](/en/9.6/03-architecture/#pg9-6-eg-3) — Query for pg\_stat\_progress\_vacuum Catalog
- [Example 4](/en/9.6/03-architecture/#pg9-6-eg-4) — fetch\_size option
- [Example 5](/en/9.6/03-architecture/#pg9-6-eg-5) — Executed SQL statement \(from log file\)
- [Example 6](/en/9.6/03-architecture/#pg9-6-eg-6) — Specify extensions option
- [Example 7](/en/9.6/03-architecture/#pg9-6-eg-7) — pg\_visibility module
- [Example 8](/en/9.6/03-architecture/#pg9-6-eg-8) — Creating a bloom module and the execution plan
- [Example 9](/en/9.6/03-architecture/#pg9-6-eg-9) — Execution of heap\_page\_items function
- [Example 10](/en/9.6/04-utilities/#pg9-6-eg-10) — Specifying the prompt
- [Example 11](/en/9.6/04-utilities/#pg9-6-eg-11) — Reference of the VIEW definition
- [Example 12](/en/9.6/04-utilities/#pg9-6-eg-12) — Executes the output result
- [Example 13](/en/9.6/04-utilities/#pg9-6-eg-13) — \\watch and \\pset title
- [Example 14](/en/9.6/04-utilities/#pg9-6-eg-14) — Specify the \-\-slot option
- [Example 15](/en/9.6/05-changes-of-parameters/#pg9-6-eg-15) — Automatic termination of the idle transaction
- [Example 16](/en/9.6/05-changes-of-parameters/#pg9-6-eg-16) — Change of SYSLOG output
- [Example 17](/en/9.6/05-changes-of-parameters/#pg9-6-eg-17) — Parameter log\_line\_prefix
- [Example 18](/en/9.6/05-changes-of-parameters/#pg9-6-eg-18) — Parameter wal\_level
- [Example 19](/en/9.6/06-enhancement-for-sql-statement/#pg9-6-eg-19) — Specify the DELETE statement to COPY statement
- [Example 20](/en/9.6/06-enhancement-for-sql-statement/#pg9-6-eg-20) — No RETURNING clause error
- [Example 21](/en/9.6/06-enhancement-for-sql-statement/#pg9-6-eg-21) — ALTER TABLE ADD COLUMN IF NOT EXISTS statement
- [Example 22](/en/9.6/06-enhancement-for-sql-statement/#pg9-6-eg-22) — Enhancement of the ALTER TABLESPACE statement
- [Example 23](/en/9.6/06-enhancement-for-sql-statement/#pg9-6-eg-23) — CREATE EXTENSION CASCADE statement
- [Example 24](/en/9.6/06-enhancement-for-sql-statement/#pg9-6-eg-24) — Function jsonb\_insert
- [Example 25](/en/9.6/06-enhancement-for-sql-statement/#pg9-6-eg-25) — num\_nulls \/ num\_nonnulls functions
- [Example 26](/en/9.6/06-enhancement-for-sql-statement/#pg9-6-eg-26) — current\_setting function
- [Example 27](/en/9.6/06-enhancement-for-sql-statement/#pg9-6-eg-27) — Execute pg\_control\_init function
- [Example 28](/en/9.6/06-enhancement-for-sql-statement/#pg9-6-eg-28) — Execute pg\_control\_checkpoint function
- [Example 29](/en/9.6/06-enhancement-for-sql-statement/#pg9-6-eg-29) — Execute pg\_control\_recovery function
- [Example 30](/en/9.6/06-enhancement-for-sql-statement/#pg9-6-eg-30) — pg\_current\_xlog\_flush\_location function
- [Example 31](/en/9.6/06-enhancement-for-sql-statement/#pg9-6-eg-31) — parse\_ident function
- [Example 32](/en/9.6/06-enhancement-for-sql-statement/#pg9-6-eg-32) — pg\_size\_bytes function
- [Example 33](/en/9.6/06-enhancement-for-sql-statement/#pg9-6-eg-33) — pg\_blocking\_pids function
- [Example 34](/en/9.6/06-enhancement-for-sql-statement/#pg9-6-eg-34) — pg\_start\_backup \/ pg\_stop\_backup functions
- [Example 35](/en/9.6/07-parallel-seq-scan/#pg9-6-eg-35) — Execution plan of parallel processing\.
- [Example 36](/en/9.6/07-parallel-seq-scan/#pg9-6-eg-36) — Execution plan of parallel processing
- [Example 37](/en/9.6/07-parallel-seq-scan/#pg9-6-eg-37) — The difference of the execution plan by the use of PARALLEL UNSAFE function
- [Example 38](/en/9.6/07-parallel-seq-scan/#pg9-6-eg-38) — User\-defined functions and PARALLEL SAFE
- [Example 39](/en/9.6/07-parallel-seq-scan/#pg9-6-eg-39) — The part of create\_parallel\_paths function
- [Example 40](/en/9.6/08-monitoring-wait-stats/#pg9-6-eg-40) — Waiting by two LOCK TABLE IN EXCLUSIVE statements
- [Example 41](/en/9.6/08-monitoring-wait-stats/#pg9-6-eg-41) — Waiting by SELECT FOR UPDATE statement and UPDATE statement
- [Example 42](/en/9.6/09-enhancement-of-foreign-data-wrapper/#pg9-6-eg-42) — Sort Push\-down
- [Example 43](/en/9.6/09-enhancement-of-foreign-data-wrapper/#pg9-6-eg-43) — DELETE statement in PostgreSQL 9\.5
- [Example 44](/en/9.6/09-enhancement-of-foreign-data-wrapper/#pg9-6-eg-44) — DELETE statement in PostgreSQL 9\.6
- [Example 45](/en/9.6/09-enhancement-of-foreign-data-wrapper/#pg9-6-eg-45) — Join Push\-down
- [Example 46](/en/9.6/10-multiple-synchronous-standby-servers/#pg9-6-eg-46) — Multiple synchronous standby server replication
- [Example 47](/en/9.6/11-security/#pg9-6-eg-47) — Role names starting from \&quot\;pg\_\&quot\;

</details>

<details class="feature-index"><summary>Figures</summary>

- [Figure 1](/en/9.6/07-parallel-seq-scan/#pg9-6-fig-1) — Parallel Seq Scan \/ Parallel Aggregate

</details>

## Source edition



The source chapter order, wording, examples, and publication credits are retained.
PDF page markers link the reading edition to the original document.
[Source identity and coverage](/sources/pg9.6-semantic.json) · [About the collection](/en/materials/)

---

Section pages:

- [About This Document](/en/9.6/01-about-this-document/): Source chapter 1 for PostgreSQL 9.6.
- [New Feature Overview](/en/9.6/02-new-feature-overview/): Source chapter 2 for PostgreSQL 9.6.
- [Architecture](/en/9.6/03-architecture/): Source chapter 3.1 for PostgreSQL 9.6.
- [Utilities](/en/9.6/04-utilities/): Source chapter 3.2 for PostgreSQL 9.6.
- [Changes of Parameters](/en/9.6/05-changes-of-parameters/): Source chapter 3.3 for PostgreSQL 9.6.
- [Enhancement for SQL Statement](/en/9.6/06-enhancement-for-sql-statement/): Source chapter 3.4 for PostgreSQL 9.6.
- [Parallel Seq Scan](/en/9.6/07-parallel-seq-scan/): Source chapter 3.5 for PostgreSQL 9.6.
- [Monitoring Wait Stats](/en/9.6/08-monitoring-wait-stats/): Source chapter 3.6 for PostgreSQL 9.6.
- [Enhancement of FOREIGN DATA WRAPPER](/en/9.6/09-enhancement-of-foreign-data-wrapper/): Source chapter 3.7 for PostgreSQL 9.6.
- [Multiple Synchronous Standby Servers](/en/9.6/10-multiple-synchronous-standby-servers/): Source chapter 3.8 for PostgreSQL 9.6.
- [Security](/en/9.6/11-security/): Source chapter 3.9 for PostgreSQL 9.6.
- [Bibliography](/en/9.6/12-bibliography/): The source document's bibliography.
- [Modification History](/en/9.6/13-modification-history/): The source document's modification history.