<!-- $PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.478 2006/10/21 18:15:44 momjian Exp $ -->

<!-- $PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.479 2006/10/21 18:41:53 tgl Exp $ -->

<!--

Typical markup:

<para>

This changes the previous behavior where concatenation

wouldadjust thelowerarraydimensions.

wouldmodify the arraylower bound.

</para>

</listitem>

<listitem>

<para>

Improve efficiency of <link

linkend="functions-comparisons"><literal>IN</>

(list-of-expressions)</link> clauses (Tom)

Allow the planner to reorder <link linkend="queries-join">outer

joins</link> in some circumstances (Tom)

</para>

<para>

In previous releases, outer joins would always be evaluated in

the order written in the query. This change allows the

query optimizer to consider reordering outer joins, in cases where

it can determine that the join order can be changed without

altering the meaning of the query. This can make a

considerable performance difference for queries involving

multiple outer joins or mixed inner and outer joins.

</para>

</listitem>

<listitem>

<para>

Increase default values for <link

linkend="guc-shared-buffers"><varname>shared_buffers</></link>

and <link

linkend="guc-max-fsm-pages"><varname>max_fsm_pages</></link>

(Andrew)

Improve efficiency of <link

linkend="functions-comparisons"><literal>IN</>

(list-of-expressions)</link> clauses (Tom)

</para>

</listitem>

</para>

</listitem>

<listitem>

<para>

Increase default values for <link

linkend="guc-shared-buffers"><varname>shared_buffers</></link>

and <link

linkend="guc-max-fsm-pages"><varname>max_fsm_pages</></link>

(Andrew)

</para>

</listitem>

<listitem>

<para>

Improve locking performance by breaking the lock manager tables into

<listitem>

<para>

Allow the planner to reorder <link linkend="queries-join">outer

joins</link> in some circumstances (Tom)

</para>

<para>

In previous releases, outer joins would always be evaluated in

the order written in the query. This change allows the

query optimizer to consider reordering outer joins, in cases where

it can determine that the join order can be changed without

altering the meaning of the query. This can make a

considerable performance difference for queries involving

multiple outer joins or mixed inner and outer joins.

</para>

</listitem>

<listitem>

<para>

Improve the optimizer statistics used by <link

Improve the optimizer's selectivity estimates for <link

linkend="functions-like"><literal>LIKE</></link>, <link

linkend="functions-like"><literal>ILIKE</></link>, and

<link linkend="functions-posix-regexp">regular expression

operations</link> (Tom)

<link linkend="functions-posix-regexp">regular expression</link>

operations (Tom)

</para>

</listitem>

</para>

<para>

This allows the new table to receive matching constraints.

This allows easy copying of <literal>CHECK</> constraints to a new

table.

</para>

</listitem>

<para>

Previously, comments attached to databases were stored in individual

databases, making them ineffective, and there was no provision

at all for comments on roles. This change adds a new

<link

at all for comments on roles or tablespaces. This change adds a new

shared catalog<link

linkend="catalog-pg-shdescription"><structname>pg_shdescription</structname></link>

system catalogand stores comments on databasesandroles therein.

and stores comments on databases, roles,andtablespaces therein.

</para>

</listitem>

<listitem>

<para>

Add <literal>table_name</> and <literal>table_schema</> as

trigger data (Andrew)

Add <literal>TG_table_name</> and <literal>TG_table_schema</> to

trigger parameters (Andrew)

</para>

<para>

<literal>TG_relname</> is now deprecated. Comparable

changes have been made in the trigger parameters for the other

PLs as well.

</para>

</listitem>

<listitem>

<para>

Add <literal>table_name</> and <literal>table_schema</> as

trigger data (Adam Sj&oslash;gren)

</para>

<para>

<literal>relname</> is kept but now deprecated.

Add <literal>table_name</> and <literal>table_schema</> to

trigger parameters (Adam Sj&oslash;gren)

</para>

</listitem>

</para>

</listitem>

<listitem>

<para>

Honor <link

linkend="guc-check-function-bodies"><varname>check_function_bodies</></link>

(Tom)

</para>

</listitem>

</itemizedlist>

</sect3>

<listitem>

<para>

Add <literal>table_name</> and <literal>table_schema</> as

trigger data (Andrew)

Named parameters are passed as ordinary variables, as well as in the

<literal>args[]</> array (Sven Suursoho)

</para>

</listitem>

<listitem>

<para>

Allow returning of composite types and result sets (Sven Suursoho)

Add <literal>table_name</> and <literal>table_schema</> to

trigger parameters (Andrew)

</para>

</listitem>

<listitem>

<para>

Return result-set as <literal>list</>, <literal>iterator</>,

or <literal>generator </>(Sven Suursoho)

Allow returning of composite types and result sets (Sven Suursoho)

</para>

</listitem>

<listitem>

<para>

Allow functions to return <literal>void</> (Neil)

Return result-set as <literal>list</>, <literal>iterator</>,

or <literal>generator </>(Sven Suursoho)

</para>

</listitem>

<listitem>

<para>

Add named parameters to the <literal>args[]</> array (Sven

Suursoho)

Allow functions to return <literal>void</> (Neil)

</para>

</listitem>

<listitem>

<para>

Improve ability to relocate installs in more complex

configurations (Tom)

Improve ability to relocate installation directories (Tom)

</para>

</listitem>