<listitem>

<para>

<link linkend="logicaldecoding">Logical decoding</link> allows database

changes to be streamed out in customizable format

changes to be streamed out inacustomizable format

</para>

</listitem>

</para>

</listitem>

<listitem>

<para>

<command>DISCARD ALL</> now also discards the state of sequences.

</para>

</listitem>

</itemizedlist>

</sect2>

</para>

<para>

<!-- FIXME: drop? -->

This was added so views that select from a table with zero columns

can be dumped correctly.

</para>

</para>

<para>

<!-- FIXME: compatibility break entry? -->

<command>DISCARD ALL</> will now also discard such information.

</para>

</listitem>

AGGREGATE</></link> to supply the size of the aggregate's

transition state data (Hadi Moshayedi)

</para>

<para>

This allows the optimizer to better estimate how much memory will be

used by aggregates.

</para>

</listitem>

</itemizedlist>

<listitem>

<para>

Allowthechangingofforeign key constraint via <link

Allow changing foreign key constraintdeferrability via <link

linkend="SQL-ALTERTABLE"><command>ALTER TABLE</></link>

... <literal>ALTER CONSTRAINT</> (Simon Riggs)

</para>

<listitem>

<para>

Fully-implement the <link

Fullyimplement the <link

linkend="datatype-line"><type>line</></link> data type (Peter

Eisentraut)

</para>

<para>

Add function <link

linkend="functions-admin-dblocation"><function>pg_filenode_relation()</></link>

to allow for more efficientfilenode to relationlookups (Andres

to allow for more efficientlookup of relationnames from filenodes (Andres

Freund)

</para>

</listitem>

</listitem>

<listitem>

<!-- FIXME -->

<para>

Allow polymorphic aggregates to have non-polymorphic state data

types ? (Tom Lane)

types (Tom Lane)

</para>

<para>

This allows the declaration of aggregates like the built-in

aggregate <function>array_agg()</> in SQL.

</para>

</listitem>

<listitem>

<para>

Allow field wrapping to <application>psql</>'s "extended" mode

Add ability to wrap long lines in <application>psql</>'s

<literal>expanded</> mode by using <command>\pset format wrapped</>

(Sergey Muraviov)

</para>

</listitem>

<listitem>

<para>

Add <link linkend="pgprewarm"><application>pg_prewarm</></link>

to preload relation data into the shared buffer cache (Robert Haas)

extension to preload relation data into the shared buffer cache

(Robert Haas)

</para>

<para>

<listitem>

<para>

Addlogging oftrigger execution to <link

Addoption to includetrigger execution time to <link

linkend="auto-explain"><application>auto_explain</></link>

(Horiguchi Kyotaro)

</para>

<listitem>

<para>

Improve indexing of <link

linkend="pgtrgm"><application>pg_trgm</></link> values to

discourage indexing whitespace (Alexander Korotkov)

Improve <link linkend="pgtrgm"><application>pg_trgm</>'s</link>

generation of trigrams for indexed regular expression searches by

discouraging the indexing of trigrams containing whitespace (Alexander

Korotkov)

</para>

</listitem>

<listitem>

<para>

Allow pgbench to process script files of any line length (Sawada

Allow<application>pgbench</> to process script files of any line length (Sawada

Masahiko)

</para>

<listitem>

<para>

Add <application>pg_bench</> option (<option>--rate</>) to control

Add <application>pgbench</> option (<option>--rate</>) to control

the transaction rate (Fabien Coelho)

</para>

</listitem>

<listitem>

<para>

Add <option>--progress</> output option to pgbench (Fabien Coelho)

Add <option>--progress</> output option to<application>pgbench</> (Fabien Coelho)

</para>

</listitem>

<listitem>

<para>

Add long options to pgbench (Fabien Coelho)

Add long options to<application>pgbench</> (Fabien Coelho)

</para>

</listitem>