<listitem>

<!--

Author: Peter Eisentraut <peter@eisentraut.org>

2020-11-03 [2f70fdb06] Remove deprecated containment operators for built-in typ

Author: Tom Lane <tgl@sss.pgh.pa.us>

2021-03-05 [112d411fb] Remove deprecated containment operators for contrib type

-->

<para>

Remove containment operators @ and ~from contrib modules cube, hstore, intarray, and seg (Justin Pryzby)

Removedeprecatedcontainment operators @ and ~for built-in geometric data types and contrib modules cube, hstore, intarray, and seg (Justin Pryzby)

</para>

<para>

The more consistentcontainment operators&lt;@and @&gt; have beensupported since PostgreSQL 8.2 (year 2006).

The more consistent &lt;@ and @&gt; have beenrecommended for many years.

</para>

</listitem>

<listitem>

<!--

Author:Thomas Munro <tmunro@postgresql.org>

2021-01-29 [514b411a2] Retire pg_standby.

Author:Joe Conway <mail@joeconway.com>

2021-03-31 [b12bd4869] Fix has_column_privilege function corner case

-->

<para>

Remove contrib program pg_standby (Justin Pryzby)

Return false for has_column_privilege() checks on non-existent or dropped columns (Joe Conway)

</para>

<para>

Previously such columns returned an invalid column error.

</para>

</listitem>

<listitem>

<!--

Author: Thomas Munro <tmunro@postgresql.org>

2020-11-03 [cd6f479e7] Add pg_depend.refobjversion.

Author: Peter Eisentraut <peter@eisentraut.org>

2020-11-03 [2f70fdb06] Remove deprecated containment operators for built-in typ

2021-01-29 [514b411a2] Retire pg_standby.

-->

<para>

Remove deprecated containment operators for built-in geometry data types (Justin Pryzby)

</para>

<para>

The more consistent &lt;@ and @&gt; have been recommended for many years.

Remove contrib program pg_standby (Justin Pryzby)

</para>

</listitem>

</para>

</listitem>

<listitem>

<!--

Author: Michael Paquier <michael@paquier.xyz>

2020-09-16 [5423853fe] Avoid retrieval of CHECK constraints and DEFAULT exprs i

-->

<para>

Avoid retrieval of CHECK constraints and DEFAULT exprs in data-only dump (Julien Rouhaud)

</para>

<para>

IS THIS BACKWARD INCOMPATIBLE?

</para>

</listitem>

<listitem>

<!--

Author: Tom Lane <tgl@sss.pgh.pa.us>

-->

<para>

Remove password_encryption's support for boolean values, e.g. true (Peter Eisentraut)

Limit the ways password_encryption can enable md5 hashing (Peter Eisentraut)

</para>

<para>

Previous boolean values enabled md5. Now, only themd5string does this.

Previously on/true/yes/1 values enabled md5. Now, only the string md5 does this.

</para>

</listitem>

-->

<para>

Improve autovacuum's analyze of partitioned tables (Yuzuko Hosoya)

Autovacuum now analyzes partitioned tables (Yuzuko Hosoya)

</para>

<para>

</para>

<para>

The server variablecheck_client_connection_interval allows supporting operating systems, e.g., Linux, to automatically cancel queries by disconnected clients.

The server variableclient_connection_check_interval allows supporting operating systems, e.g., Linux, to automatically cancel queries by disconnected clients.

</para>

</listitem>

<para>

These files were previously retained for debugging purposes; deletion can be disabled with remove_temp_files_after_crash.

</para>

</listitem>

<listitem>

<!--

Author: Peter Geoghegan <pg@bowt.ie>

2021-04-07 [3c3b8a4b2] Truncate line pointer array during VACUUM.

-->

<para>

Deallocate space reserved by trailing unused heap line pointers (Matthias van de Meent, Peter Geoghegan)

</para>

</listitem>

<listitem>

<!--

Author: Noah Misch <noah@leadboat.com>

2021-03-30 [0ff8bbdee] Accept slightly-filled pages for tuples larger than fill

-->

<para>

Allow wide tuples to be always added to almost-empty heap pages (John Naylor, Floris van Nee)

</para>

<para>

Previously tuples whose insertion would have exceeded the page's fill factor were instead added to new pages.

</para>

</listitem>

</itemizedlist>

</para>

<para>

This is particularly helpful for reducing index bloat on tablesthat frequently updateindexed columns.

This is particularly helpful for reducing index bloat on tableswhoseindexed columns are frequently updated.

</para>

</listitem>

-->

<para>

Add executor method to cache results from the inner-side of joins (David Rowley)

Add executor method to cache results from the inner-side ofnested loopjoins (David Rowley)

</para>

<para>

-->

<para>

Allow multiple foreigntable scanstobe run in parallel (Robert Haas, Kyotaro Horiguchi, Thomas Munro, Etsuro Fujita)

Allowa query referencingmultiple foreigntablestoperform foreign table scans in parallel (Robert Haas, Kyotaro Horiguchi, Thomas Munro, Etsuro Fujita)

</para>

<para>

-->

<para>

Improve the performance of parallel sequential scans (Thomas Munro, David Rowley)

Improve theI/Operformance of parallel sequential scans (Thomas Munro, David Rowley)

</para>

<para>

<para>

If server variable compute_query_id is enabled, display the hash in pg_stat_activity, EXPLAIN VERBOSE, csvlog, and optionally in log_line_prefix (Julien Rouhaud)

</para>

<para>

A query id computed by an extension will also be displayed.

</para>

</listitem>

<listitem>

<para>

Function pg_stat_reset_replication_slot() resets slot statistics.

THIS IS LOGICAL ONLY, BUT NO "LOGICAL" IN THE NAME? IS "ACTIVITY" THE RIGHT WORD?

</para>

</listitem>

-->

<para>

Allowmore thanthecommonname (CN) to be matched for client certificate authentication (Andrew Dunstan)

Allow thecertificate's distinguishedname (DN) to be matched for client certificate authentication (Andrew Dunstan)

</para>

<para>

</para>

<para>

This allows for faster recovery on systems with many database files and is enabled via recovery_init_sync_method,

By default, Postgres opens and fsyncs every data file at the start of crash recovery.

This new setting, recovery_init_sync_method=syncfs, instead syncs each filesystem used by the database cluster.

This allows for faster recovery on systems with many database files.

</para>

</listitem>

-->

<para>

Allow efficientretrievalofheap rows via tid (Edmund Horner, David Rowley)

Allow efficientheap scanningofa range of tids (Edmund Horner, David Rowley)

</para>

<para>

-->

<para>

Make built-in type coercion functions as leakproof where possible (Tom Lane)

Mark built-in type coercion functions as leakproof where possible (Tom Lane)

</para>

<para>

-->

<para>

Whenusing \e in psql, if the buffer is not modified by the editor, ignore theeditorcontentsand leavethebuffer unchanged (Laurenz Albe)

Whenediting the previous query or a file with psql's \e, or using \ef and \ev, ignore the contentsiftheeditor exits without saving (Laurenz Albe)

</para>

<para>

The \ef and \ev commands also now have this behavior. DOCS SAY BUFFER IS CLEARED.

Previously, such edits would still execute the editor contents.

</para>

</listitem>

-->

<para>

Improve tab completion (Vignesh C,, Michael Paquier, Justin Pryzby, Georgios Kokolatos, Julien Rouhaud, ADD NAMES)

Improve tab completion (Vignesh C, Michael Paquier, Justin Pryzby, Georgios Kokolatos, Julien Rouhaud, ADD NAMES)

</para>

</listitem>

</para>

<para>

Extension pg_stat_statements will need to enable hash computation via the compute_query_id server variable to function properly.

pg_stat_statements cannow use a custom hash computation method.

Extension pg_stat_statements willnowneed to enablequeryhash computation to function properly.

This canbe done by enabling the server variable compute_query_id or by using an extension with a custom hash computation method.

</para>

</listitem>