# PostgreSQL 13 New Features

> GA source edition · 81 pages · 2020-09-27

---

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/13/">Print this book</a><a href="https://github.com/nori-shinoda/documents/blob/1773200c5362476c4a549222b7d17fa91f546cae/postgresql13_ga_new_features_en_20200927-1.pdf">Original PDF on GitHub</a></div></div>

<div class="feature-source-note"><span class="feature-edition-badge">GA</span><span>2020-09-27</span><span>81 PDF pages</span><span>9 chapters</span></div>

## Contents

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

## Reference indexes

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

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

- [Table 1](/en/13/01-about/#pg13-tbl-1) — Version
- [Table 2](/en/13/01-about/#pg13-tbl-2) — Examples notation
- [Table 3](/en/13/01-about/#pg13-tbl-3) — Syntax rules
- [Table 4](/en/13/02-summary/#pg13-tbl-4) — Changing default settings
- [Table 5](/en/13/03-architecture/#pg13-tbl-5) — Added system catalogs
- [Table 6](/en/13/03-architecture/#pg13-tbl-6) — Dropped catalog
- [Table 7](/en/13/03-architecture/#pg13-tbl-7) — Dropped views in information\_schema schema
- [Table 8](/en/13/03-architecture/#pg13-tbl-8) — System catalogs with columns added
- [Table 9](/en/13/03-architecture/#pg13-tbl-9) — System catalogs with columns dropped
- [Table 10](/en/13/03-architecture/#pg13-tbl-10) — System catalog with changed output tuples
- [Table 11](/en/13/03-architecture/#pg13-tbl-11) — pg\_shmem\_allocations catalog
- [Table 12](/en/13/03-architecture/#pg13-tbl-12) — pg\_stat\_progress\_analyze catalog
- [Table 13](/en/13/03-architecture/#pg13-tbl-13) — pg\_stat\_progress\_basebackup catalog
- [Table 14](/en/13/03-architecture/#pg13-tbl-14) — pg\_stat\_slru catalog
- [Table 15](/en/13/03-architecture/#pg13-tbl-15) — Functions that use 64\-bit transaction IDs
- [Table 16](/en/13/03-architecture/#pg13-tbl-16) — Added abstract data types
- [Table 17](/en/13/03-architecture/#pg13-tbl-17) — Added wait events
- [Table 18](/en/13/03-architecture/#pg13-tbl-18) — Wait event that has been renamed
- [Table 19](/en/13/03-architecture/#pg13-tbl-19) — channel\_binding parameter values
- [Table 20](/en/13/04-sql/#pg13-tbl-20) — Attributes that can be changed
- [Table 21](/en/13/04-sql/#pg13-tbl-21) — Added format pattern
- [Table 22](/en/13/04-sql/#pg13-tbl-22) — null\_value\_treatment parameter value
- [Table 23](/en/13/05-configuration/#pg13-tbl-23) — Added parameters
- [Table 24](/en/13/05-configuration/#pg13-tbl-24) — Changed parameters
- [Table 25](/en/13/05-configuration/#pg13-tbl-25) — Parameters that default value has been changed
- [Table 26](/en/13/06-utilities/#pg13-tbl-26) — pg\_verifybackup command option
- [Table 27](/en/13/06-utilities/#pg13-tbl-27) — Added command
- [Table 28](/en/13/07-modules/#pg13-tbl-28) — Added columns
- [Table 29](/en/13/07-modules/#pg13-tbl-29) — Added columns
- [Table 30](/en/13/07-modules/#pg13-tbl-30) — Modified columns

</details>

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

- [Example 1](/en/13/02-summary/#pg13-eg-1) — CSV log \(part\)
- [Example 2](/en/13/02-summary/#pg13-eg-2) — Default prompt
- [Example 3](/en/13/02-summary/#pg13-eg-3) — Execute the to\_date function
- [Example 4](/en/13/02-summary/#pg13-eg-4) — Partition key with pseudo\-types
- [Example 5](/en/13/02-summary/#pg13-eg-5) — PostgreSQL 12 behavior
- [Example 6](/en/13/02-summary/#pg13-eg-6) — PostgreSQL 13 behavior
- [Example 7](/en/13/03-architecture/#pg13-eg-7) — Refer pg\_shmem\_allocations catalog
- [Example 8](/en/13/03-architecture/#pg13-eg-8) — Refer pg\_stat\_progress\_analyze catalog
- [Example 9](/en/13/03-architecture/#pg13-eg-9) — Refer pg\_stat\_progress\_basebackup catalog
- [Example 10](/en/13/03-architecture/#pg13-eg-10) — Refer pg\_stat\_slru catalog
- [Example 11](/en/13/03-architecture/#pg13-eg-11) — Execute to\_regcollation function
- [Example 12](/en/13/03-architecture/#pg13-eg-12) — Disk\-based hash aggregation
- [Example 13](/en/13/03-architecture/#pg13-eg-13) — Incremental sort
- [Example 14](/en/13/03-architecture/#pg13-eg-14) — backup\_manifest file
- [Example 15](/en/13/03-architecture/#pg13-eg-15) — Manifest file for backup in tar file format
- [Example 16](/en/13/03-architecture/#pg13-eg-16) — pg\_verifybackup command
- [Example 17](/en/13/03-architecture/#pg13-eg-17) — Add partitioned table to PUBLICATION
- [Example 18](/en/13/03-architecture/#pg13-eg-18) — Non\-partitioned table on SUBSCRIPTION side
- [Example 19](/en/13/03-architecture/#pg13-eg-19) — CREATE TRIGGER statement for a partitioned table
- [Example 20](/en/13/03-architecture/#pg13-eg-20) — Partitiond column expression
- [Example 21](/en/13/03-architecture/#pg13-eg-21) — Log output for Autovacuum
- [Example 22](/en/13/03-architecture/#pg13-eg-22) — Shared memory key\-value
- [Example 23](/en/13/03-architecture/#pg13-eg-23) — plpgsql\.control file contents
- [Example 24](/en/13/03-architecture/#pg13-eg-24) — CREATE EXTENSION statement executed by a general user
- [Example 25](/en/13/03-architecture/#pg13-eg-25) — Information on automatically created replication slots
- [Example 26](/en/13/03-architecture/#pg13-eg-26) — Text search languages
- [Example 27](/en/13/04-sql/#pg13-eg-27) — ALTER NO DEPENDS ON statement
- [Example 28](/en/13/04-sql/#pg13-eg-28) — ALTER STATISTICS SET STATISTICS statement
- [Example 29](/en/13/04-sql/#pg13-eg-29) — ALTER TABLE DROP EXPRESSION statement
- [Example 30](/en/13/04-sql/#pg13-eg-30) — ALTER TABLE SET STORAGE statement
- [Example 31](/en/13/04-sql/#pg13-eg-31) — ALTER TYPE SET statement
- [Example 32](/en/13/04-sql/#pg13-eg-32) — Rename view column name
- [Example 33](/en/13/04-sql/#pg13-eg-33) — Specify LOCALE clause
- [Example 34](/en/13/04-sql/#pg13-eg-34) — B\-Tree index deduplication
- [Example 35](/en/13/04-sql/#pg13-eg-35) — Effect of index deduplication
- [Example 36](/en/13/04-sql/#pg13-eg-36) — Specifying additional attributes for tables
- [Example 37](/en/13/04-sql/#pg13-eg-37) — Specify maintenance\_io\_concurrency attribute
- [Example 38](/en/13/04-sql/#pg13-eg-38) — DROP DATABASE statement
- [Example 39](/en/13/04-sql/#pg13-eg-39) — EXPLAIN \(ANALYZE\, BUFFERS\) statement
- [Example 40](/en/13/04-sql/#pg13-eg-40) — EXPLAIN \(BUFFERS\) statement
- [Example 41](/en/13/04-sql/#pg13-eg-41) — Output of the EXPLAIN ANALYZE statement \(JIT\)
- [Example 42](/en/13/04-sql/#pg13-eg-42) — Output of the EXPLAIN ANALYZE statement \(Sort\)
- [Example 43](/en/13/04-sql/#pg13-eg-43) — EXPLAIN \(ANALYZE\, WAL\) statement
- [Example 44](/en/13/04-sql/#pg13-eg-44) — INSERT OVERRIDING USER VALUE statement
- [Example 45](/en/13/04-sql/#pg13-eg-45) — datetime method
- [Example 46](/en/13/04-sql/#pg13-eg-46) — MAX\(pg\_lsn\) function
- [Example 47](/en/13/04-sql/#pg13-eg-47) — Extracting values from ROW expressions
- [Example 48](/en/13/04-sql/#pg13-eg-48) — SELECT FETCH FIRST WITH TIES statement
- [Example 49](/en/13/04-sql/#pg13-eg-49) — PARALLEL specification of VACUUM statement
- [Example 50](/en/13/04-sql/#pg13-eg-50) — Operator \&lt\;\-\&gt\;
- [Example 51](/en/13/04-sql/#pg13-eg-51) — gen\_random\_uuid function
- [Example 52](/en/13/04-sql/#pg13-eg-52) — Date format
- [Example 53](/en/13/04-sql/#pg13-eg-53) — min\_scale\, trim\_scale function
- [Example 54](/en/13/04-sql/#pg13-eg-54) — jsonb\_set\_lax function
- [Example 55](/en/13/04-sql/#pg13-eg-55) — gcd\, lcm function
- [Example 56](/en/13/04-sql/#pg13-eg-56) — is normalized syntax
- [Example 57](/en/13/04-sql/#pg13-eg-57) — is normalized syntax
- [Example 58](/en/13/05-configuration/#pg13-eg-58) — backtrace\_functions parameter
- [Example 59](/en/13/06-utilities/#pg13-eg-59) — dropdb \-\-force option
- [Example 60](/en/13/06-utilities/#pg13-eg-60) — pg\_basebackup \-\-\-no\-estimate\-size option
- [Example 61](/en/13/06-utilities/#pg13-eg-61) — pg\_dump \-\-include\-foreign\-data option
- [Example 62](/en/13/06-utilities/#pg13-eg-62) — ALTER DEPENDS ON EXTENSION statement
- [Example 63](/en/13/06-utilities/#pg13-eg-63) — pg\_rewind command
- [Example 64](/en/13/06-utilities/#pg13-eg-64) — pg\_verifybackup command
- [Example 65](/en/13/06-utilities/#pg13-eg-65) — pg\_verifybackup command with error
- [Example 66](/en/13/06-utilities/#pg13-eg-66) — pg\_verifybackup command with error
- [Example 67](/en/13/06-utilities/#pg13-eg-67) — \\dAc command
- [Example 68](/en/13/06-utilities/#pg13-eg-68) — \\g command
- [Example 69](/en/13/06-utilities/#pg13-eg-69) — \\warn command
- [Example 70](/en/13/06-utilities/#pg13-eg-70) — \\e command
- [Example 71](/en/13/06-utilities/#pg13-eg-71) — \\d command
- [Example 72](/en/13/06-utilities/#pg13-eg-72) — PROMPT2 variable value
- [Example 73](/en/13/06-utilities/#pg13-eg-73) — reindexdb \-\-jobs option
- [Example 74](/en/13/06-utilities/#pg13-eg-74) — vacuumdb \-\-parallel option
- [Example 75](/en/13/06-utilities/#pg13-eg-75) — \-\-help option
- [Example 76](/en/13/07-modules/#pg13-eg-76) — pg\_file\_sync function
- [Example 77](/en/13/07-modules/#pg13-eg-77) — log\_wal parameter
- [Example 78](/en/13/07-modules/#pg13-eg-78) — ABSVAL attribute
- [Example 79](/en/13/07-modules/#pg13-eg-79) — information on the ltree data type
- [Example 80](/en/13/07-modules/#pg13-eg-80) — heap\_tuple\_infomask\_flags function
- [Example 81](/en/13/07-modules/#pg13-eg-81) — Output of bt\_metap function
- [Example 82](/en/13/07-modules/#pg13-eg-82) — Output of bt\_page\_items function
- [Example 83](/en/13/07-modules/#pg13-eg-83) — Refer the pg\_stat\_statements view
- [Example 84](/en/13/07-modules/#pg13-eg-84) — Create USER MAPPING object without a password
- [Example 85](/en/13/07-modules/#pg13-eg-85) — Creation of external table by general user and error
- [Example 86](/en/13/07-modules/#pg13-eg-86) — Setting to allow password omission
- [Example 87](/en/13/07-modules/#pg13-eg-87) — bool\_plperl extension

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

---

Section pages:

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