<listitem>

<para>

Improve performance of the CREATE TABLE ... ON COMMIT DELETE ROWS

clause by only issuing delete if the temporary table was accessed

(Heikki Linnakangas)

Improve performance of the CREATETEMPORARYTABLE ... ON COMMIT

DELETE ROWSclause by only issuing delete if the temporary table

was accessed(Heikki Linnakangas)

</para>

</listitem>

Store WAL in a continuous stream, rather than skipping the last

16MB segment every 4GB (Heikki Linnakangas) BACKWARD COMPATIBLE BREAK

</para>

</listitem>

<listitem>

<para>

RestructureWALfiles to better handle timeline changes during

If you haveWALbackup or restore scripts that took the skipping

</para>

</listitem>

<listitem>

<para>

Restructure WAL files to use a more compact storage format (Heikki Linnakangas)

Change the WAL record format to allow splitting the record header

across pages (Heikki Linnakangas)

</para>

<para>

The new format is slightly more compact.

</para>

</listitem>

<listitem>

<para>

Add CREATE SCHEMA ... IF NOTEXIST clause (Fabr&iacute;zio de

Add CREATE SCHEMA ... IF NOTEXISTS clause (Fabr&iacute;zio de

Royes Mello)

</para>

</listitem>

<listitem>

<para>

Allow CREATE TABLE IF NOTEXIST to succeed for a non-existent schema

Allow CREATE TABLE IF NOTEXISTS to succeed for a non-existent schema

(Bruce Momjian)

</para>

</para>

<para>

INSTEAD rules are still available for complex views.

Simple views that reference some or all columns from a single base table

are now updatable by default. More complex views can be made updatable

using INSTEAD OF triggers or INSTEAD rules.

</para>

</listitem>

</para>

</listitem>

<listitem>

<para>

Use a 64-bit integer to represent WAL positions (XLogRecPtr)

instead of two 32-bit integers (Heikki Linnakangas)

</para>

<para>

Generally, tools that need to read the WAL format will need to

be adjusted.

</para>

</listitem>

<listitem>

<para>

Allow PL/Python to support platform-specific include directories (Peter Eisentraut)