# PostgreSQL 15 New Features

> GA source edition · 73 pages · 2022-10-14

---

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/">Start reading <span aria-hidden="true">→</span></a><a href="/en/_print/15/">Print this book</a><a href="https://github.com/nori-shinoda/documents/blob/1773200c5362476c4a549222b7d17fa91f546cae/postgresql15_ga_new_features_en_20221014-1.pdf">Original PDF on GitHub</a></div></div>

<div class="feature-source-note"><span class="feature-edition-badge">GA</span><span>2022-10-14</span><span>73 PDF pages</span><span>9 chapters</span></div>

## Contents

- [1 About This Document](/en/15/01-about/)
- [2 New Features Summary](/en/15/02-summary/)
- [3 Architecture](/en/15/03-architecture/)
- [4 SQL Statements](/en/15/04-sql/)
- [5 Configuration Parameters](/en/15/05-configuration/)
- [6 Utilities](/en/15/06-utilities/)
- [7 Contrib Modules](/en/15/07-modules/)
- [8 URL List](/en/15/08-url-list/)
- [9 Change History](/en/15/09-change-history/)

## Reference indexes

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

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

- [Table 1](/en/15/01-about/#pg15-tbl-1) — Version
- [Table 2](/en/15/01-about/#pg15-tbl-2) — Examples notation
- [Table 3](/en/15/01-about/#pg15-tbl-3) — Syntax rules
- [Table 4](/en/15/02-summary/#pg15-tbl-4) — Function name change
- [Table 5](/en/15/03-architecture/#pg15-tbl-5) — Added system catalogs and views
- [Table 6](/en/15/03-architecture/#pg15-tbl-6) — System catalogs\/views with additional columns
- [Table 7](/en/15/03-architecture/#pg15-tbl-7) — System catalogs\/views with columns removed
- [Table 8](/en/15/03-architecture/#pg15-tbl-8) — System catalogs\/views with modified output
- [Table 9](/en/15/03-architecture/#pg15-tbl-9) — Pg\_ident\_file\_mappings catalog
- [Table 10](/en/15/03-architecture/#pg15-tbl-10) — Pg\_parameter\_acl catalog
- [Table 11](/en/15/03-architecture/#pg15-tbl-11) — Pg\_publication\_namespace catalog
- [Table 12](/en/15/03-architecture/#pg15-tbl-12) — Pg\_stat\_recovery\_prefetch view
- [Table 13](/en/15/03-architecture/#pg15-tbl-13) — Pg\_stat\_subscription\_stats view
- [Table 14](/en/15/03-architecture/#pg15-tbl-14) — Added Wait Events
- [Table 15](/en/15/04-sql/#pg15-tbl-15) — Added functions
- [Table 16](/en/15/04-sql/#pg15-tbl-16) — Added\/changed functions
- [Table 17](/en/15/05-configuration/#pg15-tbl-17) — Added parameters
- [Table 18](/en/15/05-configuration/#pg15-tbl-18) — Modified Parameters
- [Table 19](/en/15/05-configuration/#pg15-tbl-19) — Parameters with default values changed
- [Table 20](/en/15/05-configuration/#pg15-tbl-20) — Removed parameter
- [Table 21](/en/15/06-utilities/#pg15-tbl-21) — \-\-Target option settings
- [Table 22](/en/15/06-utilities/#pg15-tbl-22) — \-\-Compress option settings
- [Table 23](/en/15/06-utilities/#pg15-tbl-23) — Added options
- [Table 24](/en/15/07-modules/#pg15-tbl-24) — Available parameters
- [Table 25](/en/15/07-modules/#pg15-tbl-25) — Added column
- [Table 26](/en/15/07-modules/#pg15-tbl-26) — Added column
- [Table 27](/en/15/07-modules/#pg15-tbl-27) — Provided functions
- [Table 28](/en/15/07-modules/#pg15-tbl-28) — Available escape sequences

</details>

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

- [Example 1](/en/15/02-summary/#pg15-eg-1) — Access privileges to the PUBLIC schema
- [Example 2](/en/15/02-summary/#pg15-eg-2) — Execute online backup
- [Example 3](/en/15/02-summary/#pg15-eg-3) — Behavior of PostgreSQL 14
- [Example 4](/en/15/02-summary/#pg15-eg-4) — Behavior of PostgreSQL 15
- [Example 5](/en/15/02-summary/#pg15-eg-5) — Behavior of PostgreSQL 14
- [Example 6](/en/15/02-summary/#pg15-eg-6) — Behavior of PostgreSQL 15
- [Example 7](/en/15/02-summary/#pg15-eg-7) — Behavior of PostgreSQL 14
- [Example 8](/en/15/02-summary/#pg15-eg-8) — Behavior of PostgreSQL 15
- [Example 9](/en/15/02-summary/#pg15-eg-9) — Python 2 only environment
- [Example 10](/en/15/02-summary/#pg15-eg-10) — Execute date\_bin function
- [Example 11](/en/15/02-summary/#pg15-eg-11) — Execute the array\_to\_tsvector function
- [Example 12](/en/15/03-architecture/#pg15-eg-12) — Reference to pg\_ident\_file\_mapping view\.
- [Example 13](/en/15/03-architecture/#pg15-eg-13) — Reference to pg\_publication\_namespace catalog
- [Example 14](/en/15/03-architecture/#pg15-eg-14) — Reference to pg\_stat\_subscription\_stats view
- [Example 15](/en/15/03-architecture/#pg15-eg-15) — Grant pg\_read\_all\_stats role
- [Example 16](/en/15/03-architecture/#pg15-eg-16) — Column specific replication
- [Example 17](/en/15/03-architecture/#pg15-eg-17) — UPDATE statement failure
- [Example 18](/en/15/03-architecture/#pg15-eg-18) — Specify WHERE clause
- [Example 19](/en/15/03-architecture/#pg15-eg-19) — WHERE clause without replica identity
- [Example 20](/en/15/03-architecture/#pg15-eg-20) — Specify the MUTABLE function
- [Example 21](/en/15/03-architecture/#pg15-eg-21) — \\d command
- [Example 22](/en/15/03-architecture/#pg15-eg-22) — Specify IN SCHEMA clause
- [Example 23](/en/15/03-architecture/#pg15-eg-23) — Specify the SKIP clause
- [Example 24](/en/15/03-architecture/#pg15-eg-24) — Execute CREATE SUBSCRIPTION statement
- [Example 25](/en/15/03-architecture/#pg15-eg-25) — Parallel query for SELECT DISTINCT
- [Example 26](/en/15/03-architecture/#pg15-eg-26) — WAL compression settings
- [Example 27](/en/15/03-architecture/#pg15-eg-27) — Specify the Archive Library
- [Example 28](/en/15/03-architecture/#pg15-eg-28) — Execute initdb command
- [Example 29](/en/15/03-architecture/#pg15-eg-29) — Execute CREATE DATABASE statement
- [Example 30](/en/15/03-architecture/#pg15-eg-30) — List databases
- [Example 31](/en/15/03-architecture/#pg15-eg-31) — Shared memory for Statistics information
- [Example 32](/en/15/03-architecture/#pg15-eg-32) — GiST index creation for BOOK type
- [Example 33](/en/15/03-architecture/#pg15-eg-33) — Grant pg\_checkpoint role
- [Example 34](/en/15/03-architecture/#pg15-eg-34) — Check WAL resource manager
- [Example 35](/en/15/03-architecture/#pg15-eg-35) — Hook definition \(src\/include\/catalog\/objectaccess\.h\)
- [Example 36](/en/15/03-architecture/#pg15-eg-36) — Hook definition \(src\/include\/miscadmin\.h\)
- [Example 37](/en/15/04-sql/#pg15-eg-37) — Negative number for NUMERIC
- [Example 38](/en/15/04-sql/#pg15-eg-38) — Refresh collation version
- [Example 39](/en/15/04-sql/#pg15-eg-39) — Execute ALTER TABLE statement
- [Example 40](/en/15/04-sql/#pg15-eg-40) — Text Format and Header
- [Example 41](/en/15/04-sql/#pg15-eg-41) — Header check
- [Example 42](/en/15/04-sql/#pg15-eg-42) — Clustering of partition tables
- [Example 43](/en/15/04-sql/#pg15-eg-43) — COLLATION\_VERSION の指定
- [Example 44](/en/15/04-sql/#pg15-eg-44) — Specify STRATEGY clause
- [Example 45](/en/15/04-sql/#pg15-eg-45) — Specify OID clause
- [Example 46](/en/15/04-sql/#pg15-eg-46) — ON Specify DELETE SET NULL clause
- [Example 47](/en/15/04-sql/#pg15-eg-47) — Create UNIQUE INDEX with NULLS DISTINCT clause
- [Example 48](/en/15/04-sql/#pg15-eg-48) — UNIQUE constraint
- [Example 49](/en/15/04-sql/#pg15-eg-49) — Create UNLOGGED SEQUENCE
- [Example 50](/en/15/04-sql/#pg15-eg-50) — Security\_invoker option
- [Example 51](/en/15/04-sql/#pg15-eg-51) — Output of temporary file I\/O time
- [Example 52](/en/15/04-sql/#pg15-eg-52) — Execute GRANT ALTER SYSTEM statement
- [Example 53](/en/15/04-sql/#pg15-eg-53) — Execute MERGE statement
- [Example 54](/en/15/04-sql/#pg15-eg-54) — Execute MERGE statement and WITH clause
- [Example 55](/en/15/04-sql/#pg15-eg-55) — Execute VACUUM VERBOSE statement
- [Example 56](/en/15/04-sql/#pg15-eg-56) — Get Logical Replication information
- [Example 57](/en/15/04-sql/#pg15-eg-57) — Execution of regular expression functions
- [Example 58](/en/15/04-sql/#pg15-eg-58) — Execution of the unnest function
- [Example 59](/en/15/04-sql/#pg15-eg-59) — Execution of the pg\_size\_pretty function
- [Example 60](/en/15/04-sql/#pg15-eg-60) — Execution of the starts\_with function
- [Example 61](/en/15/04-sql/#pg15-eg-61) — Execution of the pg\_settings\_get\_flags function
- [Example 62](/en/15/04-sql/#pg15-eg-62) — Specify \&\#x27\;of\&\#x27\;\, \&\#x27\;tzh\&\#x27\;\, \&\#x27\;tzm\&\#x27\;
- [Example 63](/en/15/04-sql/#pg15-eg-63) — Execute the poly\_distance function
- [Example 64](/en/15/05-configuration/#pg15-eg-64) — Create In place tablespace
- [Example 65](/en/15/05-configuration/#pg15-eg-65) — JSON format log file
- [Example 66](/en/15/05-configuration/#pg15-eg-66) — Output error
- [Example 67](/en/15/06-utilities/#pg15-eg-67) — For Zstandard compression
- [Example 68](/en/15/06-utilities/#pg15-eg-68) — Execute the \\dconfig command
- [Example 69](/en/15/06-utilities/#pg15-eg-69) — Execute the \\getenv command
- [Example 70](/en/15/06-utilities/#pg15-eg-70) — Output the large object access privilege
- [Example 71](/en/15/06-utilities/#pg15-eg-71) — Database name qualification
- [Example 72](/en/15/06-utilities/#pg15-eg-72) — Specify the compression method
- [Example 73](/en/15/06-utilities/#pg15-eg-73) — Specify \-\-two\-phase option
- [Example 74](/en/15/06-utilities/#pg15-eg-74) — Specify the \-\-compress option
- [Example 75](/en/15/06-utilities/#pg15-eg-75) — Command output
- [Example 76](/en/15/07-modules/#pg15-eg-76) — Sequence checking
- [Example 77](/en/15/07-modules/#pg15-eg-77) — Header match check
- [Example 78](/en/15/07-modules/#pg15-eg-78) — Execute the pg\_get\_wal\_stats function
- [Example 79](/en/15/07-modules/#pg15-eg-79) — Specify application name
- [Example 80](/en/15/07-modules/#pg15-eg-80) — Specify parallel\_commit option
- [Example 81](/en/15/07-modules/#pg15-eg-81) — Pushed CASE expression

</details>

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



</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/pg15-semantic.json) · [About the collection](/en/materials/)

---

Section pages:

- [About This Document](/en/15/01-about/): Purpose, audience, scope, software versions, notation, and responsibility statement.
- [New Features Summary](/en/15/02-summary/): The source document's overview of the release, benefits, and incompatibilities.
- [Architecture](/en/15/03-architecture/): Architecture, catalogs, replication, execution, I/O, roles, and server internals.
- [SQL Statements](/en/15/04-sql/): SQL syntax, data types, functions, optimizer behavior, and worked examples.
- [Configuration Parameters](/en/15/05-configuration/): Added, modified, removed, and default-value changes for configuration parameters.
- [Utilities](/en/15/06-utilities/): Changes to configure, initdb, backup, restore, upgrade, psql, and maintenance tools.
- [Contrib Modules](/en/15/07-modules/): Changes to contrib extensions and the modules covered by the source document.
- [URL List](/en/15/08-url-list/): The external references and release links listed by the source PDF.
- [Change History](/en/15/09-change-history/): The source document's revision history.