# PostgreSQL 9.5 New Features > Alpha 2 source edition · 77 pages · 2015-08-07 --- LLMS index: [llms.txt](/en/llms.txt) ---

WITH EXAMPLES · ENGLISH SOURCE EDITION

Explore the features, SQL examples, and compatibility changes documented by Noriyoshi Shinoda.

Start reading Print this bookOriginal PDF on GitHub
Alpha 22015-08-0777 PDF pages11 chapters
> This book describes the **Alpha 2** source document. Its examples and compatibility notes reflect that snapshot. ## Contents - [1 About This Document](/en/9.5/01-about-this-document/) - [2 New Feature Overview](/en/9.5/02-new-feature-overview/) - [3 Architecture](/en/9.5/03-architecture/) - [4 Utilities](/en/9.5/04-utilities/) - [5 Changes of Parameters](/en/9.5/05-changes-of-parameters/) - [6 Enhancement for SQL Statement](/en/9.5/06-enhancement-for-sql-statement/) - [7 Row Level Security](/en/9.5/07-row-level-security/) - [8 BRIN Index](/en/9.5/08-brin-index/) - [9 Other New Features](/en/9.5/09-other-new-features/) - [10 Bibliography](/en/9.5/10-bibliography/) - [11 Modification History](/en/9.5/11-modification-history/) ## Reference indexes The opening chapter includes the first numbered table, [Table 1](/en/9.5/01-about-this-document/#pg9-5-tbl-1). The indexes below collect the book's other native numbered components.
Tables - [Table 1](/en/9.5/01-about-this-document/#pg9-5-tbl-1) — Version - [Table 2](/en/9.5/01-about-this-document/#pg9-5-tbl-2) — Examples notation - [Table 3](/en/9.5/01-about-this-document/#pg9-5-tbl-3) — Syntax rule - [Table 4](/en/9.5/03-architecture/#pg9-5-tbl-4) — Added system Catalogs - [Table 5](/en/9.5/03-architecture/#pg9-5-tbl-5) — pg\_file\_settings Catalog - [Table 6](/en/9.5/03-architecture/#pg9-5-tbl-6) — pg\_policy Catalog - [Table 7](/en/9.5/03-architecture/#pg9-5-tbl-7) — pg\_policies Catalog - [Table 8](/en/9.5/03-architecture/#pg9-5-tbl-8) — pg\_stat\_ssl Catalog - [Table 9](/en/9.5/03-architecture/#pg9-5-tbl-9) — pg\_transform Catalog - [Table 10](/en/9.5/03-architecture/#pg9-5-tbl-10) — Modified catalogs - [Table 11](/en/9.5/03-architecture/#pg9-5-tbl-11) — Added column to pg\_replication\_slots Catalog - [Table 12](/en/9.5/03-architecture/#pg9-5-tbl-12) — Added column to pg\_settings Catalog - [Table 13](/en/9.5/03-architecture/#pg9-5-tbl-13) — Added columns to pg\_stat\_statements Catalog - [Table 14](/en/9.5/03-architecture/#pg9-5-tbl-14) — Added columns to pg\_tables Catalog - [Table 15](/en/9.5/03-architecture/#pg9-5-tbl-15) — Changed in Contrib modules - [Table 16](/en/9.5/03-architecture/#pg9-5-tbl-16) — Added Hook - [Table 17](/en/9.5/03-architecture/#pg9-5-tbl-17) — Environment variables for OOM Killer support - [Table 18](/en/9.5/04-utilities/#pg9-5-tbl-18) — Command\-line parameters - [Table 19](/en/9.5/04-utilities/#pg9-5-tbl-19) — Added \/ modified backslash command - [Table 20](/en/9.5/05-changes-of-parameters/#pg9-5-tbl-20) — Added Parameters - [Table 21](/en/9.5/05-changes-of-parameters/#pg9-5-tbl-21) — Changed Parameters - [Table 22](/en/9.5/05-changes-of-parameters/#pg9-5-tbl-22) — Parameters the default value of which is changed - [Table 23](/en/9.5/05-changes-of-parameters/#pg9-5-tbl-23) — Alternative parameters for checkpoint\_segments - [Table 24](/en/9.5/06-enhancement-for-sql-statement/#pg9-5-tbl-24) — Executed triggers - [Table 25](/en/9.5/06-enhancement-for-sql-statement/#pg9-5-tbl-25) — Syntax for IMPORT FOREIGN SCHEMA statement - [Table 26](/en/9.5/06-enhancement-for-sql-statement/#pg9-5-tbl-26) — IMPORT FOREIGN SCHEMA statement OPTIONS clause - [Table 27](/en/9.5/06-enhancement-for-sql-statement/#pg9-5-tbl-27) — Information obtaining functions - [Table 28](/en/9.5/06-enhancement-for-sql-statement/#pg9-5-tbl-28) — Return value of pg\_event\_trigger\_table\_rewrite\_reason function - [Table 29](/en/9.5/07-row-level-security/#pg9-5-tbl-29) — Syntax for CREATE POLICY statement - [Table 30](/en/9.5/07-row-level-security/#pg9-5-tbl-30) — Choices for Parameter row\_security - [Table 31](/en/9.5/08-brin-index/#pg9-5-tbl-31) — Functions that have been added to the pageinspect module - [Table 32](/en/9.5/09-other-new-features/#pg9-5-tbl-32) — Data Type
Examples - [Example 1](/en/9.5/03-architecture/#pg9-5-eg-1) — Reload parameter file - [Example 2](/en/9.5/03-architecture/#pg9-5-eg-2) — Join pg\_stat\_replication Catalog and pg\_replication\_slots Catalog - [Example 3](/en/9.5/03-architecture/#pg9-5-eg-3) — Archiving of last segment - [Example 4](/en/9.5/04-utilities/#pg9-5-eg-4) — Error messages on parameter settings - [Example 5](/en/9.5/04-utilities/#pg9-5-eg-5) — Error messages during target instance start - [Example 6](/en/9.5/04-utilities/#pg9-5-eg-6) — Execute pg\_rewind command - [Example 7](/en/9.5/04-utilities/#pg9-5-eg-7) — \-\-jobs parameter’s limit - [Example 8](/en/9.5/04-utilities/#pg9-5-eg-8) — \-\-jobs parameter and processes - [Example 9](/en/9.5/04-utilities/#pg9-5-eg-9) — Setting the pager\_min\_lines - [Example 10](/en/9.5/04-utilities/#pg9-5-eg-10) — \\set ECHO errors - [Example 11](/en/9.5/04-utilities/#pg9-5-eg-11) — Error message - [Example 12](/en/9.5/04-utilities/#pg9-5-eg-12) — \\watch output \\timing information - [Example 13](/en/9.5/04-utilities/#pg9-5-eg-13) — Output of \-latency\-limit parameter - [Example 14](/en/9.5/04-utilities/#pg9-5-eg-14) — Behavior at the specified \-f parameter - [Example 15](/en/9.5/04-utilities/#pg9-5-eg-15) — reindexdb \-v Option - [Example 16](/en/9.5/05-changes-of-parameters/#pg9-5-eg-16) — Setting parameter for each table - [Example 17](/en/9.5/05-changes-of-parameters/#pg9-5-eg-17) — Error by pause\_at\_recovery\_target setting - [Example 18](/en/9.5/06-enhancement-for-sql-statement/#pg9-5-eg-18) — Prepare table and data - [Example 19](/en/9.5/06-enhancement-for-sql-statement/#pg9-5-eg-19) — ON CONFLICT clause samples - [Example 20](/en/9.5/06-enhancement-for-sql-statement/#pg9-5-eg-20) — DO UPDATE clause samples - [Example 21](/en/9.5/06-enhancement-for-sql-statement/#pg9-5-eg-21) — ON CONFLICT Clause and Execution Plan - [Example 22](/en/9.5/06-enhancement-for-sql-statement/#pg9-5-eg-22) — INSERT ON CONLICT statement for the partition table\#1 - [Example 23](/en/9.5/06-enhancement-for-sql-statement/#pg9-5-eg-23) — INSERT ON CONLICT statement for the partition table\#2 - [Example 24](/en/9.5/06-enhancement-for-sql-statement/#pg9-5-eg-24) — Change to UNLOGGED TABLE - [Example 25](/en/9.5/06-enhancement-for-sql-statement/#pg9-5-eg-25) — Change of pg\_class Catalog - [Example 26](/en/9.5/06-enhancement-for-sql-statement/#pg9-5-eg-26) — Execution of the IMPORT FOREIGN SCHEMA statement - [Example 27](/en/9.5/06-enhancement-for-sql-statement/#pg9-5-eg-27) — Behavior that cause an error - [Example 28](/en/9.5/06-enhancement-for-sql-statement/#pg9-5-eg-28) — DEFAULT with Sequence - [Example 29](/en/9.5/06-enhancement-for-sql-statement/#pg9-5-eg-29) — Prepare data and lock tuple - [Example 30](/en/9.5/06-enhancement-for-sql-statement/#pg9-5-eg-30) — SELECT by the other session - [Example 31](/en/9.5/06-enhancement-for-sql-statement/#pg9-5-eg-31) — Create parent table - [Example 32](/en/9.5/06-enhancement-for-sql-statement/#pg9-5-eg-32) — Create child table on the remote instance - [Example 33](/en/9.5/06-enhancement-for-sql-statement/#pg9-5-eg-33) — Create External Tables - [Example 34](/en/9.5/06-enhancement-for-sql-statement/#pg9-5-eg-34) — Check FOREIGN TABLE Definition with INHERITS Clause - [Example 35](/en/9.5/06-enhancement-for-sql-statement/#pg9-5-eg-35) — Check the Execution Plan - [Example 36](/en/9.5/06-enhancement-for-sql-statement/#pg9-5-eg-36) — CURRENT\_USER Clause - [Example 37](/en/9.5/06-enhancement-for-sql-statement/#pg9-5-eg-37) — Preparation of tables - [Example 38](/en/9.5/06-enhancement-for-sql-statement/#pg9-5-eg-38) — Syntax up to PostgreSQL 9\.4 - [Example 39](/en/9.5/06-enhancement-for-sql-statement/#pg9-5-eg-39) — Syntax for PostgreSQL 9\.5 - [Example 40](/en/9.5/06-enhancement-for-sql-statement/#pg9-5-eg-40) — Execution Plan for TABLESAMPLE SYSTEM - [Example 41](/en/9.5/06-enhancement-for-sql-statement/#pg9-5-eg-41) — Execution Plan for TABLESAMPLE BERNOULLI - [Example 42](/en/9.5/06-enhancement-for-sql-statement/#pg9-5-eg-42) — REINDEX SCHEMA statement - [Example 43](/en/9.5/06-enhancement-for-sql-statement/#pg9-5-eg-43) — REINDEX \(VERBOSE\) - [Example 44](/en/9.5/06-enhancement-for-sql-statement/#pg9-5-eg-44) — ROLLUP \(Output the subtotal values for each column c1\) - [Example 45](/en/9.5/06-enhancement-for-sql-statement/#pg9-5-eg-45) — CHECK constraint in the CREATE FOREIGN TABLE statement - [Example 46](/en/9.5/06-enhancement-for-sql-statement/#pg9-5-eg-46) — Execution plan and CHECK constraint - [Example 47](/en/9.5/06-enhancement-for-sql-statement/#pg9-5-eg-47) — Enhance CREATE EVENT TRIGGER statement - [Example 48](/en/9.5/06-enhancement-for-sql-statement/#pg9-5-eg-48) — ASSERT statement - [Example 49](/en/9.5/06-enhancement-for-sql-statement/#pg9-5-eg-49) — Parameter plpgsql\.check\_asserts - [Example 50](/en/9.5/06-enhancement-for-sql-statement/#pg9-5-eg-50) — Add and Replace - [Example 51](/en/9.5/06-enhancement-for-sql-statement/#pg9-5-eg-51) — Delete element - [Example 52](/en/9.5/06-enhancement-for-sql-statement/#pg9-5-eg-52) — Delete elements of the nested structure - [Example 53](/en/9.5/06-enhancement-for-sql-statement/#pg9-5-eg-53) — Replace element - [Example 54](/en/9.5/06-enhancement-for-sql-statement/#pg9-5-eg-54) — Add element \#1 - [Example 55](/en/9.5/06-enhancement-for-sql-statement/#pg9-5-eg-55) — Add element \#2 - [Example 56](/en/9.5/06-enhancement-for-sql-statement/#pg9-5-eg-56) — Formatting jsonb - [Example 57](/en/9.5/06-enhancement-for-sql-statement/#pg9-5-eg-57) — Omit null fields\. - [Example 58](/en/9.5/06-enhancement-for-sql-statement/#pg9-5-eg-58) — Enhancement of generate\_series Function - [Example 59](/en/9.5/07-row-level-security/#pg9-5-eg-59) — Enable Row Level Security to the table - [Example 60](/en/9.5/07-row-level-security/#pg9-5-eg-60) — CREATE POLICY statement - [Example 61](/en/9.5/07-row-level-security/#pg9-5-eg-61) — Effect of the policy - [Example 62](/en/9.5/08-brin-index/#pg9-5-eg-62) — Create the table and store the data - [Example 63](/en/9.5/08-brin-index/#pg9-5-eg-63) — Create index and check - [Example 64](/en/9.5/08-brin-index/#pg9-5-eg-64) — Check the size of files \(storage\) - [Example 65](/en/9.5/08-brin-index/#pg9-5-eg-65) — Execution plan for BTREE index - [Example 66](/en/9.5/08-brin-index/#pg9-5-eg-66) — Execution plan for BRIN index \(default parameter value\) - [Example 67](/en/9.5/08-brin-index/#pg9-5-eg-67) — Execution plan for BRIN index \(pages\_per\_range\=64\) - [Example 68](/en/9.5/08-brin-index/#pg9-5-eg-68) — Execution plan for BRIN index \(pages\_per\_range\=512\) - [Example 69](/en/9.5/08-brin-index/#pg9-5-eg-69) — Example of brin\_page\_items function - [Example 70](/en/9.5/08-brin-index/#pg9-5-eg-70) — Obtain of options information - [Example 71](/en/9.5/09-other-new-features/#pg9-5-eg-71) — Parameter cluster\_name - [Example 72](/en/9.5/09-other-new-features/#pg9-5-eg-72) — Additional sort information - [Example 73](/en/9.5/09-other-new-features/#pg9-5-eg-73) — Log of slave instance connection - [Example 74](/en/9.5/09-other-new-features/#pg9-5-eg-74) — Log of pg\_basebackup command - [Example 75](/en/9.5/09-other-new-features/#pg9-5-eg-75) — search pg\_class catalog
Figures - [Figure 1](/en/9.5/06-enhancement-for-sql-statement/#pg9-5-fig-1) — FOREIGN TABLE INHERIT - [Figure 2](/en/9.5/07-row-level-security/#pg9-5-fig-2) — Access Control by Row Level Security - [Figure 3](/en/9.5/08-brin-index/#pg9-5-fig-3) — Structure of BRIN INDEX
## 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.5-semantic.json) · [About the collection](/en/materials/) --- Section pages: - [About This Document](/en/9.5/01-about-this-document/): Source chapter 1 for PostgreSQL 9.5. - [New Feature Overview](/en/9.5/02-new-feature-overview/): Source chapter 2 for PostgreSQL 9.5. - [Architecture](/en/9.5/03-architecture/): Source chapter 3.1 for PostgreSQL 9.5. - [Utilities](/en/9.5/04-utilities/): Source chapter 3.2 for PostgreSQL 9.5. - [Changes of Parameters](/en/9.5/05-changes-of-parameters/): Source chapter 3.3 for PostgreSQL 9.5. - [Enhancement for SQL Statement](/en/9.5/06-enhancement-for-sql-statement/): Source chapter 3.4 for PostgreSQL 9.5. - [Row Level Security](/en/9.5/07-row-level-security/): Source chapter 3.5 for PostgreSQL 9.5. - [BRIN Index](/en/9.5/08-brin-index/): Source chapter 3.6 for PostgreSQL 9.5. - [Other New Features](/en/9.5/09-other-new-features/): Source chapter 3.7 for PostgreSQL 9.5. - [Bibliography](/en/9.5/10-bibliography/): The source document's bibliography. - [Modification History](/en/9.5/11-modification-history/): The source document's modification history.