<listitem>

<para>

Remove system column pg_class.reltoastidxid (Michael Paquier)

Use the last specified recovery_target if multiple are specified (Heikki Linnakangas)

</para>

</listitem>

<listitem>

<para>

</para>

</listitem>

<listitem>

<para>

Improve SSL renegotiation handling (&Aacute;lvaro Herrera)

Allow background workers to be dynamically registered, started and terminated (Robert Haas)

</para>

</listitem>

<listitem>

<para>

During immediate shutdown, send uncatchable termination signals to child processes that have not already shutdown (MauMau,

&Aacute;lvaro Herrera)

worker_spi_launch() in worker_spi shows an example of its use.

</para>

</listitem>

<listitem>

<para>

This reduces the likelihoodoforphaned child processes after postmaster shutdown.

Allow dynamic allocationofshared memory segments (Robert Haas, Amit Kapila)

</para>

</listitem>

<listitem>

<para>

Improverandomness of the database system identifier (Tom Lane)

ImproveSSL renegotiation handling (&Aacute;lvaro Herrera)

</para>

</listitem>

<listitem>

<para>

Allow background workers to be dynamically started and terminated (Robert Haas)

During immediate shutdown, send uncatchable termination signals to child processes that have not already shutdown (MauMau,

&Aacute;lvaro Herrera)

</para>

<para>

worker_spi_launch() in worker_spi shows an example if its use.

This reduces the likelihood of orphaned child processes after postmaster shutdown.

</para>

</listitem>

<listitem>

<para>

Allow dynamic allocationofshared memory segments (Robert Haas, Amit Kapila)

Improve randomnessofthe database system identifier (Tom Lane)

</para>

</listitem>

</para>

</listitem>

<listitem>

<para>

Fix race condition in B-tree page deletion (Heikki Linnakangas)

</para>

</listitem>

<listitem>

<para>

Make the handling of interrupted B-tree page splits more robust (Heikki Linnakangas)

</para>

</listitem>

</itemizedlist>

</sect4>

</para>

<para>

This avoidslater freezing overhead.

This avoidsthe need to freeze the tuples in the future.

</para>

</listitem>

<listitem>

<para>

Improve speed ofaccessing manysequence values (David Rowley)

Improve speed ofaccesessing manydifferent sequences in the same session (David Rowley)

</para>

</listitem>

<listitem>

<para>

Use memory barriers to avoid some spinlock use (Heikki Linnakangas)

Auto-resize the catalog cache (Heikki Linnakangas)

</para>

<para>

This reduces memory consumption for backends accessing only a few tables, and improves performance for backend accessing many

tables.

</para>

</listitem>

<listitem>

<para>

Add huge_pages configuration parameter toattempt to use huge translation look-aside buffer (TLB) pages on Linux (Christian Kruse,

Add huge_pages configuration parameter toenable huge translation look-aside buffer (TLB) pages on Linux (Christian Kruse,

Richard Poole, Abhijit Menon-Sen)

</para>

</para>

</listitem>

<listitem>

<para>

Add configuration variable data_checksums to report whether data page checksums are enabled (Bernd Helmle)

</para>

</listitem>

<listitem>

<para>

Add superuser-only session_preload_libraries configuration parameter to load libraries at session start (Peter Eisentraut)

</para>

</listitem>

<listitem>

<para>

Use the last specified recovery_target if multiple are specified (Heikki Linnakangas)

</para>

</listitem>

<listitem>

<para>

pg_switch_xlog() now clears the trailing unused space in the WAL file (Heikki Linnakangas)

</para>

<para>

Description? Logical only?

Replication slots allow preservation of resources like WAL files on the

primary that are needed by standby servers.

</para>

</listitem>

<listitem>

<para>

Reduce spinlock contention during WAL replay (Heikki Linnakangas)

</para>

</listitem>

<listitem>

<para>

Improve return codes from external recovery commands (Peter Eisentraut)

Report failure return codes from external recovery commands (Peter Eisentraut)

</para>

</listitem>

<listitem>

<para>

Write WAL records of running transactions every 15 seconds ? (Andres Freund)

Write WAL records of running transactions more frequently (Andres Freund)

</para>

<para>

This allows standby servers to start faster and cleanup resources

more aggressively.

</para>

</listitem>

</itemizedlist>

<sect4>

<title>Logical Change-Set Encoding</title>

<title>Logical Change-Set Extraction</title>

<para>

The new Logical change-set extraction feature allows database

changes to be optionally recorded in <emphasis>logical</> format

in the WAL. This format can be easily processed by external tools.

In previous releases, only binary changes were recorded in the

WAL. To implement this feature, the following changes were made:

</para>

<itemizedlist>

<listitem>

<para>

Allow security barrier views automatically updateable (Dean Rasheed)

Allow security barrier viewsto beautomatically updateable (Dean Rasheed)

</para>

</listitem>

<listitem>

<para>

Add structured (non-text) data type (jsonb) for storing JSON data (Oleg Bartunov, Teodor Sigaev, Peter Geoghegan and Andrew Dunstan)

Add structured (non-text) data type (jsonb) for storing JSON data (Oleg Bartunov, Teodor Sigaev,

Alexander Korotkov, Peter Geoghegan, and Andrew Dunstan)

</para>

<para>

This data type allows faster indexing and access to json keys/value pairs.

This data type allows for faster indexing and access to json key/value

pairs, as well as efficient indexing of all key/value pairs in a JSON document.

</para>

</listitem>

<listitem>

<para>

Add functions pg_filenode_relation() and pg_relation_filepath() to do relation/relfilenode conversions (Andres Freund)

</para>

<para>

These use a new pg_class index to speed lookups.

Add function pg_filenode_relation() to allow for more efficient

filenode to relation lookups (Andres Freund)

</para>

</listitem>

<listitem>

<para>

Improve the way tuples are frozen, to preserve forensic information ((Robert Haas, Andres Freund)

Improve the way tuples are frozen, to preserve forensic information (Robert Haas, Andres Freund)

</para>

<para>

Code that inspects tuple flag bits will need to be modified

</para>

</listitem>

<listitem>

<para>

Auto-resize the catalog cache (Heikki Linnakangas)

</para>

<para>

This reduces memory consumption for backends accessing only a few tables, and improves performance for backend accessing many

tables.

Code that inspects tuple flag bits will need to be modified.

</para>

</listitem>

</para>

<para>

All existing uses have been switched to more appropriate snapshot types.

All existing uses have been switched to more appropriate snapshot

types. Catalog scans now use MVCC snapshots.

</para>

</listitem>

<listitem>

<para>

Use an MVCC snapshot (rather than SnapshotNow) for catalog scans (Robert Haas)

</para>

</listitem>

<listitem>

<para>

Use printf() modifier "z" to specify size_t values (Andres Freund)

Add printf() modifier "z" to specify size_t values (Andres Freund)

</para>

</listitem>

<listitem>

<para>

</para>

</listitem>

<listitem>

<para>

Improve spinlockspeed on x86_64 CPUs (test on i386?) (Heikki Linnakangas)

Remove spinlocksupport for unsupported platforms SINIX, Sun3, and NS32K (Robert Haas)

</para>

</listitem>

<listitem>

<para>

Removespinlock support for unsupported platforms SINIX, Sun3, and NS32K (Robert Haas)

RemoveIRIX port (Robert Haas)

</para>

</listitem>

<listitem>

<para>

Rewrite duplicate_oids Unixhell script in Perl (Andrew Dunstan)

Rewrite duplicate_oids Unixshell script in Perl (Andrew Dunstan)

</para>

</listitem>

</para>

</listitem>

<listitem>

<para>

Remove IRIX port (Robert Haas)

</para>

</listitem>

<listitem>

<para>

Avoid most uses of dlltool in Cygwin and Mingw builds (Marco Atzeri, Hiroshi Inoue)