<listitem>

<para>

Change <link

Rename <link

linkend="vacuum-progress-reporting"><structname>pg_stat_progress_vacuum</structname></link>

columns <structfield>max_dead_tuples</structfield>

column <structfield>max_dead_tuples</structfield>

to <structfield>max_dead_tuple_bytes</structfield>,

rename <structfield>num_dead_tuples</structfield> to

<structfield>num_dead_item_ids</structfield>, and add

<!--

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

2023-11-17 [f7816aec2] Extract column statistics from CTE references, if possib

-->

<listitem>

<para>

Allow the optimizer to improve <acronym>CTE</acronym> plans by

considering the statistics of columns referenced in earlier row

output clauses (Jian Guo, Tom Lane)

</para>

</listitem>

<!--

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

2024-03-26 [a65724dfa] Propagate pathkeys from CTEs up to the outer query.

-->

<listitem>

<para>

Allow the optimizer to improve <acronym>CTE</acronym> plans by

considering the sort order of columns referenced in earlier row

output clauses (Richard Guo)

considering thestatistics andsort order of columns referenced in earlier row

output clauses (Jian Guo,Richard Guo, Tom Lane)

</para>

</listitem>

</para>

<para>

Remove <literal>IS NOT NULL</literal>queryrestrictions on

Remove <literal>IS NOT NULL</literal> restrictions from queries on

<literal>NOT NULL</literal> columns and eliminate scans on

<literal>NOT NULL</literal> columns if <literal>IS NULL</literal>

is specified.

<listitem>

<para>

Add log messages related to <acronym>WAL</acronym> recovery from

backup (Andres Freund)

backups (Andres Freund)

</para>

</listitem>

<xref linkend="guc-multixact-offset-buffers"/>,

<xref linkend="guc-notify-buffers"/>, <xref

linkend="guc-serializable-buffers"/>, <xref

linkend="guc-subtransaction-buffers"/>, and <xref

linkend="guc-transaction-buffers"/>. commit_timestamp_buffers,

transaction_buffers and subtransaction_buffers scale up

automatically with <xref linkend="guc-shared-buffers"/>.

linkend="guc-subtransaction-buffers"/>, and

<xref linkend="guc-transaction-buffers"/>. <xref

linkend="guc-commit-timestamp-buffers"/>, <xref

linkend="guc-transaction-buffers"/>, and <xref

linkend="guc-subtransaction-buffers"/> scale up automatically with

<xref linkend="guc-shared-buffers"/>.

</para>

</listitem>

</para>

<para>

This allows logical replication to continue quickly

after the upgrade. This only works for old clusters of

<productname>PostgreSQL</productname> version 17 or later.

This allows logical replication to continue

quickly after the upgrade. This only works for old

<productname>PostgreSQL</productname> clusters that are version

17 or later.

</para>

</listitem>

</para>

<para>

The server variable is <xref linkend="guc-standby-slot-names"/>.

Thenewserver variable is <xref linkend="guc-standby-slot-names"/>.

</para>

</listitem>

<listitem>

<para>

Add local I/O block read/write timing statistics to

<command>EXPLAIN</command> (Nazir Bilal Yavuz)

<command>EXPLAIN</command>'s <literal>BUFFERS</literal> output

(Nazir Bilal Yavuz)

</para>

</listitem>

<para>

Command <literal>\dp</literal> now displays <literal>(none)</literal>

for empty privileges; default stilldisplay as empty.

for empty privileges; default stilldisplays as empty.

</para>

</listitem>

<listitem>

<para>

Allow <application>pg_dump</application>, <link

Allow <link

linkend="app-pgdump"><application>pg_dump</application></link>, <link

linkend="app-pg-dumpall"><application>pg_dumpall</application></link>,

and <link

linkend="app-pgrestore"><application>pg_restore</application></link>

linkend="app-pgbasebackup"><application>pg_basebackup</application></link>,

<link

linkend="app-pgchecksums"><application>pg_checksums</application></link>,

<application>pg_dump</application>, <link

linkend="app-pgrewind"><application>pg_rewind</application></link>,

<link linkend="app-pgdump"><application>pg_dump</application></link>,

<linklinkend="app-pgrewind"><application>pg_rewind</application></link>,

and <link

linkend="pgupgrade"><application>pg_upgrade</application></link>.

</para>

<para>

Add <link

linkend="app-pgrestore"><application>pg_restore</application></link>

option <option>--transaction-size</option> to allow objectrestore

option <option>--transaction-size</option> to allow objectrestores

in transaction batches (Tom Lane)

</para>

<listitem>

<para>

Add pgbench command \syncpipeline to allow sending of sync messages

(Anthonin Bonnefoy)

Add pgbench command<literal>\syncpipeline</literal> to allow

sending of sync messages(Anthonin Bonnefoy)

</para>

</listitem>

<listitem>

<para>

Allow pushdown of <literal>EXISTS</literal> and <literal>IN</literal>

subqueries tothe<xref linkend="postgres-fdw"/> foreignserver

subqueries to <xref linkend="postgres-fdw"/> foreignservers

(Alexander Pyhalov)

</para>

</listitem>

<listitem>

<para>

Allow <application><xref linkend="amcheck"/></application> to

check for unique constraint violations (Anastasia Lubennikova,

Pavel Borisov, Maxim Orlov)

</para>

<para>

The <application>pg_amcheck</application> option

<option>--checkunique</option> will check all unique indexes.

Allow <application><xref linkend="amcheck"/></application>

to check for unique constraint violations using new option

<option>--checkunique</option> (Anastasia Lubennikova, Pavel Borisov,

Maxim Orlov)

</para>

</listitem>