# About This Document

> Source chapter 1 for PostgreSQL 11.

---

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

---

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

<p class="feature-page-marker" id="pgfeat-11-about-pdf-page-5">PDF page 5</p>

### 1.1 Purpose {#pg11-1-1-purpose}

The purpose of this document is to provide information of the major new features of PostgreSQL 11.

### 1.2 Audience {#pg11-1-2-audience}

This document is written for engineers who already have knowledge of PostgreSQL, such as installation, basic management, etc.

### 1.3 Scope {#pg11-1-3-scope}

This document describes the major difference between PostgreSQL 10 (10.4) and PostgreSQL 11 (11.0). As a general rule, this document examines the features of behavior change. This document does not describe and verify all new features. In particular, the following new features are not included.

#### Bug fix {#pg11-p5-bug-fix}

#### Performance improvement by changing internal behavior {#pg11-p5-performance-improvement-by-changing-internal-behavior}

#### Improvement of regression test {#pg11-p5-improvement-of-regression-test}

#### Operability improvement by psql command tab input {#pg11-p5-operability-improvement-by-psql-command-tab-input}

#### Improvement of pgbench command {#pg11-p5-improvement-of-pgbench-command}

#### Improvement of documentation, modify typo in the source code {#pg11-p5-improvement-of-documentation-modify-typo-in-the-source-code}

#### Refactoring without a change in behavior {#pg11-p5-refactoring-without-a-change-in-behavior}

### 1.4 Software Version {#pg11-1-4-software-version}

The contents of this document have been verified for the following versions and platforms.

**Table 1.** Version

| Software | Version |
| --- | --- |
| PostgreSQL | PostgreSQL 10.4 (for comparison) PostgreSQL 11 (11.0) (October 15, 2018 21:15:55) |
| Operating System | Red Hat Enterprise Linux 7 Update 4 (x86-64) |
| Configure option | --with-llvm --with-python --with-perl |

<p class="feature-page-marker" id="pgfeat-11-about-pdf-page-6">PDF page 6</p>

### 1.5 Question, comment and Responsibility {#pg11-1-5-question-comment-and-responsibility}

The contents of this document are not an official opinion of Hewlett-Packard Enterprise Japan Co, Ltd. The author and affiliation company do not take any responsibility for the problem caused by the mistake of contents. If you have any comments for this document, please contact to Noriyoshi Shinoda

```text
(noriyoshi.shinoda@hpe.com) Hewlett-Packard Enterprise Japan Co, Ltd.
```

### 1.6 Notation {#pg11-1-6-notation}

This document contains examples of the execution of the command or SQL statement. Execution examples are described according to the following rules:

**Table 2.** Examples notation

| Notation | Description |
| --- | --- |
| # | Shell prompt for Linux root user |
| $ | Shell prompt for Linux general user |
| Bold | User input string |
| postgres=# | psql command prompt for PostgreSQL administrator |
| postgres=> | psql command prompt for PostgreSQL general user |
| Underline | Important output items |

The syntax is described in the following rules:

**Table 3.** Syntax rules

| Notation | Description |
| --- | --- |
| Italic | Replaced by the name of the object which users use, or the other syntax |
| [ ] | Indicate that it can be omitted |
| { A \| B } | Indicate that it is possible to select A or B |
| … | General syntax, it is the same as the previous version |