<!-- $PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.435 2006/09/1821:45:10 momjian Exp $ -->

<!-- $PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.436 2006/09/1822:43:16 momjian Exp $ -->

<!--

Typical markup:

<title>Additional Changes</title>

<para>

Below you will find a detailed account of the additional changes

between <productname>PostgreSQL</productname> 8.2 and the

previous major release.

Below you will find a detailed account of the additional

changesbetween <productname>PostgreSQL</productname> 8.2 and

theprevious major release.

</para>

<sect3>

<listitem>

<para>

Improve performance of statistics monitoring, especially <literal>pg_stat_activity</> (Tom)

Improve performance of statistics monitoring, especially

<literal>stats_command_string</> (Tom, Bruce)

</para>

<para>

This release sets <envar>stats_command_string</> to

<literal>on</> by default, now that its overhead is minimal.

This means <literal>pg_stat_activity</> now will show all

active queries by default.

</para>

</listitem>

</para>

</listitem>

<listitem>

<para>

Default <envar>stats_command_string</> to <literal>on</>, now that its overhead is minimal

(Bruce)

</para>

<para>

This means <literal>pg_stat_activity</> now will show all active queries by default.

</para>

</listitem>

<listitem>

<para>

Add <acronym>GUC</> <envar>update_process_title</> to control whether the <application>ps</> display is

</para>

<para>

Theold behavior isstill available by omitting <literal>.*</>. The new behavior is

for data changes with <literal>if row(new.*) IS DISTINCT FROM row(old.*)</>.

Thenew behavior issubstantially more useful since it allows, for example,

The old behavior is still available by omitting <literal>.*</>.

</para>

</listitem>

<listitem>

<para>

Allow placeholder (shell) types to becreate (Martijn van Oosterhout)

Allow placeholder (shell) types to becreated (Martijn van Oosterhout)

</para>

<para>

</para>

</listitem>

<listitem>

<para>

Remove dead index entries during btree page split (Junji Teramoto)

</para>

</listitem>

<listitem>

<para>

Allow <command>VACUUM</> to expire rows without being affected by other concurrent

<listitem>

<para>

Avoid extra scan oftable during <command>VACUUM</> of index-less table (Greg Stark)

Avoid extra scan oftables during <command>VACUUM</> of index-less table (Greg Stark)

</para>

</listitem>

<listitem>

<para>

Add option to allow indexes to be createdindexeswithout blocking

Add option to allow indexes to be created without blocking

concurrent writes to the table (Greg Stark)

</para>

</para>

<para>

Rtree has been reimplemented using <acronym>GIST</>.

Rtree has been re-implemented using <acronym>GIST</>.

</para>

</listitem>