Skip to content

PostgreSQL 9.5–19 · With examples

PG Features

PostgreSQL release features, explained with SQL, examples, and compatibility notes. Explore the original documents by Noriyoshi Shinoda, one release at a time.

12 releases · 1,085 source pages

By Noriyoshi Shinoda

The shelf, indexed

Compare releases without losing the source

Read the original chapters, with source page markers, tables, and worked examples.

12editionsPostgreSQL 9.5 through 19editions
1085source pagesSelected English PDFssource pages
401tables389 numbered tables + 12 historiestables
1222numbered examplesSQL, shell, and terminal sessionsnumbered examples

Browse by release

The PostgreSQL feature line

Choose a release to read the original feature document. PostgreSQL 19 uses the Beta 1 source.

Alpha 2 · 2015-08-07 · 77 pages

PostgreSQL 9.5

Architecture, utilities, parameters, SQL, row-level security, BRIN, and other new features.

Read edition

Beta 1 · 2016-06-06 · 53 pages

PostgreSQL 9.6

Parallel scans, wait statistics, foreign data wrappers, synchronous standbys, and security.

Read edition

Beta 1 · 2017-05-22 · 101 pages

PostgreSQL 10

Native partitioning, logical replication, parallel query, monitoring, and utility changes.

Read edition

GA · 2018-10-22 · 87 pages

PostgreSQL 11

Parallel query, partitioned tables, logical replication, PL/pgSQL, and contrib modules.

Read edition

GA · 2019-10-11 · 88 pages

PostgreSQL 12

The nine-chapter source edition covering architecture, SQL, configuration, utilities, and modules.

Read edition

GA · 2020-09-27 · 81 pages

PostgreSQL 13

A preserved release document with native contents, examples, tables, links, and source pages.

Read edition

GA · 2021-10-01 · 88 pages

PostgreSQL 14

Query, replication, configuration, utility, and contrib changes from the selected GA document.

Read edition

GA · 2022-10-14 · 73 pages

PostgreSQL 15

The compact GA edition for reading PostgreSQL 15 changes in the original chapter order.

Read edition

GA · 2023-09-19 · 98 pages

PostgreSQL 16

Feature topics, worked examples, tables, source links, and change history in one book.

Read edition

GA · 2024-09-30 · 108 pages

PostgreSQL 17

A full release shelf entry with the same stable OINK navigation and component indexes.

Read edition

GA · 2026-02-19 · 109 pages

PostgreSQL 18

Asynchronous I/O, OAuth SASL, virtual generated columns, planner work, and new utilities.

Read edition

Beta 1 · 2026-06-06 · 122 pages

PostgreSQL 19

Score-based autovacuum, SQL and planner changes, utilities, and contrib modules. Beta 1 remains a snapshot.

Read edition
Author
Noriyoshi Shinoda

GitHub · Source repository

Noriyoshi Shinoda

Author of the PostgreSQL New Features With Examples source documents. His release notes, examples, tables, and publication details anchor this reading shelf.

Visit profile

Start with the release you needUse the book menu in the top navigation, or open a version below and follow its source chapters, examples, and page markers.