<formalpara>

<title>Release date:</title>

<para>2020-05-03</para>

<para>2020-XX-XX, CURRENT AS OF 2020-05-03</para>

</formalpara>

<sect2>

</para>

<para>

These triggers cannot change the destination partition.

These triggers"cannot changewhich partition isthe destination.

</para>

</listitem>

-->

<para>

Allow incremental sorting (James Coleman, Alexander Korotkov)

Implement incremental sorting (James Coleman, Alexander Korotkov)

</para>

<para>

If a result is already sorted by several keys, this allows for batch sorting of additional trailing keys because the previous keys are already equal. This is controlled by enable_incrementalsort.

If a result is already sorted by severalleadingkeys, this allows for batch sorting of additional trailing keys because the previous keys are already equal. This is controlled by enable_incrementalsort.

</para>

</listitem>

</para>

<para>

Previously, hash aggregation wasnot used if it was expected to use more than work_mem memory. This is controlled by enable_hashagg_disk.

Previously, hash aggregation wasavoided if it was expected to use more than work_mem memory. This is controlled by enable_hashagg_disk.

</para>

</listitem>

</para>

<para>

This new behaviorsets pages as all-visible,allowing for index-only scans, and reduces the work necessary when the table needs to be frozen.

This new behaviorallows pagesto be setas all-visible,which then allows index-only scans, and reduces the work necessary when the table needs to be frozen.

</para>

</listitem>

</para>

<para>

Thisis controlled by GUC wal_skip_threshold.

The WAL write amount where this happensis controlled by wal_skip_threshold.

</para>

</listitem>

-->

<para>

Improve the performanceof replay ofDROP DATABASE commandsthat usemany tablespaces (Fujii Masao)

Improve the performancewhen replayingDROP DATABASE commandswhenmany tablespaces are in use (Fujii Masao)

</para>

</listitem>

-->

<para>

Improve performance for truncation of verylarger relations (Kirk Jamison)

Improve performance for truncation of verylarge relations (Kirk Jamison)

</para>

</listitem>

</para>

<para>

Previously, server restart was required to change primary_conninfo and primary_slot_name.

Previously,aserver restart was required to change primary_conninfo and primary_slot_name.

</para>

</listitem>

-->

<para>

Fix bugs in ALTER TABLEwhere later clauses overlap changes made by earlier clauses in the same command (Tom Lane)

Fix bugs in ALTER TABLEwhen later clauses overlap changes made by earlier clauses in the same command (Tom Lane)

</para>

</listitem>

</para>

<para>

The new function, jsonb_set_lax(), allows null new values to either set the specified key to JSON null, delete the key, raise exception, or ignore operation.

The new function, jsonb_set_lax(), allows null new values to either set the specified key to JSON null, delete the key, raise exception, or ignoretheoperation.

IS 'return_target' CLEAR?

</para>

</para>

<para>

Thismakes \gx equivalent to\g (expanded=on).

Thisallows syntax like\g (expand=on), which is equivalent to \gx.

</para>

</listitem>

</para>

<para>

This isenable using the -c/--restore-target-wal option.

This isenabled using the -c/--restore-target-wal option.

</para>

</listitem>

</para>

<para>

These long-supported options for this are called --superuser and --no-superuser.

The long-supported options for this are called --superuser and --no-superuser.

</para>

</listitem>