<!--

$PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.366 2005/09/11 23:40:33 neilc Exp $

$PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.367 2005/09/12 05:10:12 neilc Exp $

Typical markup:

</sect2>

<sect2>

<title>Migration to 8.1</title>

<title>Migration toversion8.1</title>

<para>

A dump/restore using <application>pg_dump</application> is required

<sect3>

<title>Performance Improvements</title>

<itemizedlist>

<listitem>

<para>

Improve GiST and rtree index performance (Neil)

<command>SELECT INTO</> (Simon)

</para>

<para>

Since a crash during <command>CREATE TABLE</> would cause the

Since a crash during <command>CREATE TABLE AS</> would cause the

table to be dropped during recovery, there is no reason to WAL

log as the table is loaded. (Logging still happens if WAL

archiving is enabled, however.)

larger chunks, rather than character by character.

</para>

</listitem>

<listitem>

<para>

Improve the performance of <function>COUNT()</function>,

<function>SUM</function>, <function>AVG()</function>,

<function>STDDEV()</function>, and

<function>VARIANCE()</function> (Neil, Tom)

</para>

</listitem>

</itemizedlist>

</sect3>

</para>

</listitem>

<listitem>

<para>

Add <function>SPI_getnspname()</function> to SPI (Neil)

</para>

</listitem>

</itemizedlist>

</sect3>

<listitem>

<para>

Reducememoryusage of PL/PgSQL functions (Neil)

Overhaul thememorymanagement of PL/PgSQL functions (Neil)

</para>

<para>

The parsetree of each function is now stored in a separate

memory context. This allowsthe memory to be easily reclaimed

memory context. This allowsthis memory to be easily reclaimed

when it is no longer needed.

</para>

</listitem>

<para>

This is a byproduct of the newly added <command>OUT</> and

<command>INOUT</> functionality. <command>RETURN</> can

be omitted when it is not needed to provide the function result.

be omitted when it is not needed to provide the function's

return value.

</para>

</listitem>

<listitem>

<para>

Add support for an optional <command>INTO</> clause to

PL/PgSQL's <command>EXECUTE</>command (Pavel Stehule, Neil)

PL/PgSQL's <command>EXECUTE</>statement (Pavel Stehule, Neil)

</para>

</listitem>

exception (Pavel Stehule, Neil)

</para>

<para>

These variables are onlyaccessible inside exception blocks.

These variables are onlydefined inside exception blocks.

</para>

</listitem>

</para>

</listitem>

<listitem>

<para>

Make <application>libpq</application> consistently return an error

to the client application on <function>malloc()</function>

failure (Neil)

</para>

</listitem>

</itemizedlist>

</sect3>

Remove support for Kerberos V4 (Magnus)

</para>

<para>

Kerberos 4 had security vulnerabilities and is no longer being

Kerberos 4 had security vulnerabilities and is no longer

maintained.

</para>

</listitem>

</para>

</listitem>

<listitem>

<para>

Move private declarations from <filename>gist.h</filename> to

<filename>gist_private.h</filename> (Neil)

</para>

<para>

In previous releases, <filename>gist.h</> contained both the

public GiST API (intended for use by authors of GiST index

implementations) as well as some private declarations used by

the implementation of GiST itself. The latter have been moved

to a separate file, <filename>gist_private.h</>. Most GiST

index implementations should be unaffected.

</para>

</listitem>

<listitem>

<para>

Overhaul GiST memory management (Neil)

</para>

<para>

GiST methods are now always invoked in a short-lived memory

context. Therefore, memory allocated via <function>palloc()</>

will be reclaimed automatically, so GiST index implementations

do not need to manually release allocated memory via

<function>pfree()</>.

</para>

</listitem>

</itemizedlist>

</sect3>

<sect3>

<title>Contrib Changes</title>

<itemizedlist>

Take build parameters (OpenSSL, zlib) from <filename>configure</> result

</para>

<para>

No need to edit the <filename>Makefile</> anymore.

There is no need to edit the <filename>Makefile</> anymore.

</para>

</listitem>