partitioned tables can be published explicitly causing all partitions

to be automatically published. Addition/removal of partitions from

partitioned tables are automatically added/removed from publications.

The <xref linkend="sql-createpublication"/> option

ancestor's.

The <link linkend="sql-createpublication"><command>CREATE

to partitions are published as their own or theirancestor's.

</para>

</listitem>

<para>

This allows efficient btree indexing of low cardinality columns

by storing duplicate keys only once. Users upgrading

with <xref linkend="pgupgrade"/> will need to use <xref

linkend="sql-reindex"/> to make use of this feature.

by storing duplicate keys only once. Users upgrading with <link

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

will need to use <link

linkend="sql-reindex"><command>REINDEX</command></link> to make use

of this feature.

</para>

</listitem>

-->

<para>

Allow <xref linkend="gist"/> and <xref

linkend="spgist"/> indexes for <link

Allow <link linkend="gist">GiST</link> and <link

linkend="spgist">SP-GiST</link> indexes for <link

linkend="datatype-line">box</link>/point distance lookups (Nikita

Glukhov)

</para>

-->

<para>

Allow <xref linkend="gin"/> indexes to more efficiently handle

<literal>NOT</literal> restrictions (Nikita Glukhov, Alexander

Korotkov, Tom Lane, Julien Rouhaud)

Allow <link linkend="gin"><acronym>GIN</acronym></link> indexes to

more efficiently handle<literal>NOT</literal> restrictions (Nikita

Glukhov, AlexanderKorotkov, Tom Lane, Julien Rouhaud)

</para>

</listitem>

-->

<para>

Allow inserts to trigger <xref linkend="autovacuum"/> activity

(Laurenz Albe, Darafei Praliaskouski)

Allow inserts to trigger <link linkend="autovacuum">autovacuum</link>

activity(Laurenz Albe, Darafei Praliaskouski)

</para>

<para>

-->

<para>

Improve the performance when replaying <xref

linkend="sql-dropdatabase"/> commands when many tablespaces are

in use (Fujii Masao)

Improve the performance when replaying <link

linkend="sql-dropdatabase"><command>DROP DATABASE</command></link>

commands when many tablespaces arein use (Fujii Masao)

</para>

</listitem>

-->

<para>

Improve speed of <xref linkend="storage-toast"/> decompression and

the retrieval of only the leading bytes of <acronym>TOAST</acronym>

Improve speed of <link

linkend="storage-toast"><acronym>TOAST</acronym></link> decompression

and the retrieval of only the leading bytes of <acronym>TOAST</acronym>

values (Binguo Bao, Andrey Borodin)

</para>

-->

<para>

Improve performance of <xref

linkend="sql-listen"/>/<command>NOTIFY</command> (Martijn van

Oosterhout)

Improve performance of <link

linkend="sql-listen"><command>LISTEN</command></link>/<command>NOTIFY</command>

(Martijn vanOosterhout)

</para>

</listitem>

-->

<para>

Improve the efficiency of removing duplicate <xref

linkend="sql-notify"/> events (Tom Lane)

Improve the efficiency of removing duplicate <link

linkend="sql-notify"><command>NOTIFY</command></link> events (Tom Lane)

</para>

</listitem>

-->

<para>

Allow <xref linkend="sql-explain"/>,

<xref linkend="auto-explain"/>, <xref

linkend="autovacuum"/>, and <xref

Allow <link linkend="sql-explain"><command>EXPLAIN</command></link>,

<xref linkend="auto-explain"/>, <link

linkend="autovacuum">autovacuum</link>, and <xref

linkend="pgstatstatements"/> to track <acronym>WAL</acronym> usage

statistics (Kirill Bychik, Julien Rouhaud)

</para>

-->

<para>

Make <xref linkend="sql-vacuum"/> buffer counters 64-bits

Make <link linkend="sql-vacuum">vacuum</link> buffer counters 64-bits

wide to avoid overflow (&Aacute;lvaro Herrera)

</para>

</listitem>

<para>

Add system view <link

linkend="monitoring-stats-dynamic-views-table"><structname>pg_stat_progress_analyze</structname></link>

to report <xref linkend="sql-analyze"/> progress (&Aacute;lvaro

Herrera, Tatsuro Yamada, Vinayak Pokale)

to report <link linkend="sql-analyze">analyze</link> progress

(&Aacute;lvaroHerrera, Tatsuro Yamada, Vinayak Pokale)

</para>

</listitem>

-->

<para>

Allow <xref linkend="sql-vacuum"/> to process indexes in parallel

(Masahiko Sawada, Amit Kapila)

Allow <link linkend="sql-vacuum"><command>VACUUM</command></link>

to process indexes in parallel(Masahiko Sawada, Amit Kapila)

</para>

<para>

-->

<para>

Report planning-time buffer usage in <xref linkend="sql-explain"/>'s

Report planning-time buffer usage in <link

linkend="sql-explain"><command>EXPLAIN</command></link>'s

<literal>BUFFER</literal> output (Julien Rouhaud)

</para>

</listitem>

-->

<para>

Add <xref linkend="sql-altertable"/> clause <literal>DROP

(Peter Eisentraut)

Add <link linkend="sql-altertable"><command>ALTER

to remove generated properties from columns(Peter Eisentraut)

</para>

</listitem>

-->

<para>

Add <xref linkend="sql-alterview"/> syntax to rename view columns

(Fujii Masao)

Add <link linkend="sql-alterview"><command>ALTER VIEW</command></link>

syntax to rename view columns(Fujii Masao)

</para>

<para>

-->

<para>

Add <xref linkend="sql-altertype"/> options useful for extensions,

like <acronym>TOAST</acronym> and I/O functions control (Tomas

Vondra, Tom Lane)

Add <link linkend="sql-altertype"><command>ALTER TYPE</command></link>

options useful for extensions,like <acronym>TOAST</acronym> and I/O

functions control (TomasVondra, Tom Lane)

</para>

</listitem>

-->

<para>

Add <xref linkend="sql-createdatabase"/> <literal>LOCALE</literal>

option (Peter Eisentraut)

Add <link linkend="sql-createdatabase"><command>CREATE

DATABASE</command></link> <literal>LOCALE</literal> option (Peter

Eisentraut)

</para>

<para>

-->

<para>

Allow <xref linkend="sql-dropdatabase"/> to disconnect users so

drop succeeds (Pavel Stehule, Amit Kapila)

Allow <link linkend="sql-dropdatabase"><command>DROP

DATABASE</command></link> to disconnect users so drop succeeds (Pavel

Stehule, Amit Kapila)

</para>

<para>

</sect3>

<sect3>

<title><xref linkend="plpgsql"/></title>

<title><link linkend="plpgsql">PL/pgSQL</link></title>

<itemizedlist>

</para>

<para>

A new tool <application><xref

linkend="app-pgverifybackup"/></application> can verify backups.

A new tool <link

linkend="app-pgverifybackup"><application>pg_verifybackup</application>"</link>

can verify backups.

</para>

</listitem>

-->

<para>

Have <application><xref

linkend="app-pgbasebackup"/></application> estimate the

total backup size by default (Fujii Masao)

Have <link

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

estimate thetotal backup size by default (Fujii Masao)

</para>

<para>

-->

<para>

Add <application><xref linkend="app-pgrewind"/></application>

Add <link

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

option to configure standbys (Paul Guo, Jimmy Yih, Ashwin Agrawal)

</para>

<para>

This matches <application><xref

linkend="app-pgbasebackup"/></application>'s

This matches <link

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

<option>--write-recovery-conf</option> option.

</para>

</listitem>

-->

<para>

Increase <xref linkend="sql-prepare-transaction"/> information

reported by <application>pg_waldump</application> (Fujii Masao)

Increase <link linkend="sql-prepare-transaction"><command>PREPARE

TRANSACTION</command></link> information reported by

<application>pg_waldump</application> (Fujii Masao)

</para>

</listitem>

-->

<para>

Add <application><xref linkend="pgwaldump"/></application>

option <option>--quiet</option> to suppress non-error output

(Andres Freund, Robert Haas)

Add <link

linkend="pgwaldump"><application>pg_waldump</application></link>

option <option>--quiet</option> to suppress non-error output (Andres

Freund, Robert Haas)

</para>

</listitem>

-->

<para>

Allow <application><xref linkend="app-pgdump"/></application>

Allow <link

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

<option>--include-foreign-data</option> to dump data from foreign

servers (Luis Carril)

</para>

-->

<para>

Allow vacuum commands run by <application><xref

linkend="app-vacuumdb"/></application> to operate in parallel mode

Allow vacuum commands run by <link

linkend="app-vacuumdb">vacuumdb</link> to operate in parallel mode

(Masahiko Sawada)

</para>

-->

<para>

Allow <application><xref linkend="app-reindexdb"/></application>

to operate inparallel (Julien Rouhaud)

Allow <link linkend="app-reindexdb">reindexdb</link> to operate in

parallel (Julien Rouhaud)

</para>

<para>

-->

<para>

Allow <application><xref linkend="app-dropdb"/></application>

to force disconnectionsso the drop succeeds (Pavel Stehule)

Allow <link linkend="app-dropdb">dropdb</link> to force disconnections

so the drop succeeds (Pavel Stehule)

</para>

<para>

<para>

Remove <option>--adduser</option> and <option>--no-adduser</option>

from <application><xref linkend="app-createuser"/></application> (Alexander

from <link linkend="app-createuser">createuser</link> (Alexander

Lakhin)

</para>

-->

<para>

Use the directory of the <application><xref

linkend="pgupgrade"/></application> binary

as the default new 'bindir' location when running

Use the directory of the <link

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

binaryas the default new 'bindir' location when running

<application>pg_upgrade</application> (Daniel Gustafsson)

</para>

</listitem>

-->

<para>

Add <xref linkend="sql-truncate"/> command hook (Yuli Khodorkovskiy)

Add <link linkend="sql-truncate"><command>TRUNCATE</command></link>

command hook (Yuli Khodorkovskiy)

</para>

</listitem>

</para>

<para>

Specifically, allow <xref linkend="sql-alterusermapping"/> to set

Specifically, allow <link linkend="sql-alterusermapping"><command>ALTER

USER MAPPING</command></link> to set

<literal>password_required</literal> to false. Care must still be

taken to avoid non-superusers from using superuser credentials to

connect to the foreign server.