<!-- $PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.602 2009/03/27 00:11:34 momjian Exp $ -->

<!-- $PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.603 2009/03/27 00:45:40 momjian Exp $ -->

<!--

Typical markup:

</para>

<para>

This was available previously via a configure --enable-integer-datetimes

This was available previously via a configure

</para>

</listitem>

<para>

While semi-joins merely replace existing IN joins, anti-joins

are a new capability for NOT IN and NOTEXIST clauses (Tom)

are a new capability for NOT IN and NOTEXISTS clauses (Tom)

This improves optimization possibilities.

</para>

</listitem>

</para>

<para>

IN andEXISTs now provide similar performance for equivalent clauses.

IN andEXISTS now provide similar performance for equivalent clauses.

</para>

</listitem>

</para>

<para>

A new constraint_exclusion setting, "partition",which matches this

A new constraint_exclusion setting, "partition",was added to match this

behavior.

</para>

</listitem>

<listitem>

<para>

Movethat server statistics file into the subdirectory pg_stat_tmp

(Magnus)

Movethe server statistics file into the subdirectory pg_stat_tmp

and allow its location to be specified via stats_temp_directory(Magnus)

</para>

<para>

</para>

</listitem>

<listitem>

<para>

Allow the location of the new pg_stat_tmp to be configured via

the stats_temp_directory setting (Magnus)

</para>

</listitem>

</itemizedlist>

</sect3>