Skip to content

1 About This Document

Source chapter 1 for PostgreSQL 10.
Beta 1Source pages: PDF 6-7Original PDF on GitHub

PDF page 6

1.1 Purpose

The purpose of this document is to provide information of the major new features of PostgreSQL 10, the Beta 1 version being published.

1.2 Audience

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

1.3 Scope

This document describes the major difference between PostgreSQL 9.6 and PostgreSQL 10 Beta 1. As a general rule, this document examines the functions that users can see when they see changes. It does not describe and verify all new features. In particular, the following new functions are not included.

  • Bug fix

  • Performance improvement by changing internal behavior

  • Improvement of regression test

  • Operability improvement by psql command tab input

  • Improvement of pgbench command (partly described)

  • Improve documentation, modify typo in the sources

1.4 Software Version

This document is being verified for the following versions and platforms.

SoftwareVersions
PostgreSQLPostgreSQL 9.6.3 (for comparison) PostgreSQL 10 Beta 1 (May 15, 2017 21:27:43)
Operating SystemRed Hat Enterprise Linux 7 Update 1 (x86-64)
Table 1 Version

1.5 Question, Comment, and Responsibility

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

PDF page 7

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:

NotationDescription
#Shell prompt for Linux root user
$Shell prompt for Linux general user
boldUser input string
postgres=#psql command prompt for PostgreSQL administrator
postgres=>psql command prompt for PostgreSQL general user
underlineImportant output items
Table 2 Examples notation

The syntax is described in the following rules:

NotationDescription
ItalicReplaced by the name of the object which users use, or the other syntax
[ ABC ]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
Table 3 Syntax rules