More release note adjustments, reordering.

1 files changed, 183 insertions, 166 deletions

diff --git a/doc/src/sgml/release.sgml b/doc/src/sgml/release.sgml
index f7d33074d2e..231ef4fe5cf 100644
--- a/doc/src/sgml/release.sgml
+++ b/doc/src/sgml/release.sgml
@@ -1,4 +1,4 @@
-<!-- $PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.617 2009/03/30 19:59:19 momjian Exp $ -->
+<!-- $PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.618 2009/03/30 20:32:49 momjian Exp $ -->
 <!--
 
 Typical markup:
@@ -125,12 +125,31 @@ do it for earlier branch release files.
 
       <para>
        This was available previously via a configure
-       --enable-integer-datetimes.
+       --enable-integer-datetimes option.
       </para>
      </listitem>
 
      <listitem>
       <para>
+       Remove <application>ipcclean</> utility command (Bruce)
+      </para>
+
+      <para>
+       The utility only worked on a few platforms;  users should use
+       their operating system tools instead.
+      </para>
+     </listitem>
+
+    </itemizedlist>
+
+    </sect3>
+
+   <sect3>
+    <title>Server Settings</title>
+    <itemizedlist>
+
+     <listitem>
+      <para>
        Change <filename>postgresql.conf</> default for log_min_messages
        to <literal>warning</> (previously <literal>notice</>) to reduce
        log file volume (Tom)
@@ -204,19 +223,9 @@ do it for earlier branch release files.
 
      <listitem>
       <para>
-       Remove <application>ipcclean</> utility command (Bruce)
-      </para>
-
-      <para>
-       The utility only worked on a few platforms;  users should use
-       their operating system tools instead.
-      </para>
-     </listitem>
-
-     <listitem>
-      <para>
-       The <filename>pg_hba.conf</> section below also has extensive
-       changes related to migration.
+       The <link
+       linkend="release-8-4-pg-hba-conf"><filename>pg_hba.conf</></link>
+       section below also has extensive changes related to migration.
       </para>
      </listitem>
 
@@ -288,7 +297,7 @@ do it for earlier branch release files.
 
 
     <sect3>
-     <title>Functions and Operators</title>
+     <title>General Functions and Operators</title>
 
     <itemizedlist>
 
@@ -325,6 +334,31 @@ do it for earlier branch release files.
 
      <listitem>
       <para>
+       Remove <literal>~=~</> and <literal>~&lt;&gt;~</> operators
+       used for <literal>LIKE</> index comparisons (Tom) bjm: needed,
+       pg_upgrade impact?
+      </para>
+
+      <para>
+       A not-immediately-obvious incompatibility is that the sort
+       order within <literal>bpchar_pattern_ops</> indexes changes
+       --- it had been identical to plain <function>strcmp()</>, but
+       is now trailing-blank-insensitive.  This will impact in-place
+       upgrades, if those ever happen.
+      </para>
+     </listitem>
+
+    </itemizedlist>
+
+   </sect3>
+
+    <sect3>
+     <title>Temporal Functions and Operators</title>
+
+    <itemizedlist>
+
+     <listitem>
+      <para>
        Have <function>to_char()</>'s localized month/day names depend
        on <varname>LC_TIME</>, not <varname>LC_MESSAGES</> (Euler
        Taveira de Oliveira)
@@ -381,22 +415,6 @@ do it for earlier branch release files.
       </para>
      </listitem>
 
-     <listitem>
-      <para>
-       Remove <literal>~=~</> and <literal>~&lt;&gt;~</> operators
-       used for <literal>LIKE</> index comparisons (Tom) bjm: needed,
-       pg_upgrade impact?
-      </para>
-
-      <para>
-       A not-immediately-obvious incompatibility is that the sort
-       order within <literal>bpchar_pattern_ops</> indexes changes
-       --- it had been identical to plain <function>strcmp()</>, but
-       is now trailing-blank-insensitive.  This will impact in-place
-       upgrades, if those ever happen.
-      </para>
-     </listitem>
-
     </itemizedlist>
 
    </sect3>
@@ -547,27 +565,29 @@ do it for earlier branch release files.
    </sect3>
 
    <sect3>
-    <title>Wide-Value Storage (<acronym>TOAST</>)</title>
+    <title>Server Settings</title>
     <itemizedlist>
 
      <listitem>
       <para>
-       Consider <acronym>TOAST</> compression on values as short as
-       32 bytes (previously 256 bytes) (Tom)
+       Convert many <filename>postgresql.conf</> settings to enumerated
+       values so <literal>pg_settings</> can easily display valid
+       values (Magnus)
       </para>
      </listitem>
 
      <listitem>
       <para>
-       Require 25% of space savings before using <acronym>TOAST</>
-       compression (previously 20%) (Tom)
+       Add <varname>cursor_tuple_fraction</> parameter to control the
+       fraction of a cursor's rows expected to be requested by the
+       user (Robert Hell)
       </para>
      </listitem>
 
      <listitem>
       <para>
-       Be more aggressive in storing <literal>EXTERNAL</> and
-       <literal>EXTENDED</> column values in <acronym>TOAST</>(Tom)
+       Allow underscores in <filename>postgresql.conf</> custom variable
+       classes (Tom)
       </para>
      </listitem>
 
@@ -576,29 +596,27 @@ do it for earlier branch release files.
    </sect3>
 
    <sect3>
-    <title>Server Settings</title>
+    <title>Authentication</title>
     <itemizedlist>
 
      <listitem>
       <para>
-       Convert many <filename>postgresql.conf</> settings to enumerated
-       values so <literal>pg_settings</> can easily display valid
-       values (Magnus)
+       Report appropriate error message for combination of <literal>MD5</>
+       authentication and <varname>db_user_namespace</> enabled (Bruce)
       </para>
      </listitem>
 
      <listitem>
       <para>
-       Add <varname>cursor_tuple_fraction</> parameter to control the
-       fraction of a cursor's rows expected to be requested by the
-       user (Robert Hell)
+       Support regular expressions in <filename>pg_ident.conf</>
+       (Magnus)
       </para>
      </listitem>
 
      <listitem>
       <para>
-       Allow underscores in <filename>postgresql.conf</> custom variable
-       classes (Tom)
+       Allow <productname>Kerberos</>/<acronym>GSSAPI</> parameters
+       to be changed without restarting the postmaster (Magnus)
       </para>
      </listitem>
 
@@ -606,88 +624,109 @@ do it for earlier branch release files.
 
    </sect3>
 
-   <sect3>
-    <title>Monitoring</title>
+   <sect3 id="release-8-4-pg-hba-conf">
+    <title><filename>pg_hba.conf</></title>
     <itemizedlist>
 
      <listitem>
       <para>
-       Add <function>pg_conf_load_time()</> to report when
-       the Postgres configuration files were last loaded (George
-       Gensure)
+       Parse <filename>pg_hba.conf</> in the postmaster so errors are
+       reported on reload (Magnus)
+      </para>
+      
+      <para>
+       Previously errors in the file wouldn't be detected until clients
+       tried to connect, which could leave the system with a broken
+       file loaded.
       </para>
      </listitem>
 
      <listitem>
       <para>
-       Add <function>pg_terminate_backend()</> to safely terminate a
-       backend (the <literal>SIGTERM</> signal works also) (Tom, Bruce)
+       Remove the <literal>sameuser</> option, making it the default
+       if no usermap is specified (Magnus)
       </para>
      </listitem>
 
      <listitem>
       <para>
-       Add ability to track user-defined functions call counts and
-       runtimes via parameter <varname>track_functions</> (Martin
-       Pihlak)
+       Change all authentication options to be <literal>name=value</>
+       settings (Magnus)
       </para>
-
+     </listitem>
+     
+     <listitem>
       <para>
-       Function statistics appear in a new system table,
-       <literal>pg_stat_user_functions</>.  However, inlined
-       <acronym>SQL</> functions are not tracked.
+       Allow usermap parameter for all external authentication methods
+       (Magnus)
+      </para>
+      
+      <para>
+       Previously this was only supported for <literal>ident</>
+       authentication.
       </para>
      </listitem>
 
      <listitem>
       <para>
-       Allow specification of the maximum <literal>pg_stat_activity</>
-       query string size via <varname>track_activity_query_size</>
-       parameter (Thomas Lee)
+       Allow <literal>ident</> authentication over Unix-domain sockets
+       on <productname>Solaris</> (Garick Hamlin)
       </para>
      </listitem>
 
      <listitem>
       <para>
-       Improve syslog performance by increasing the maximum line length
-       (Tom)
+       Add <literal>clientcert</> option to control requesting of a
+       client certificate (Magnus)
       </para>
-     </listitem>
 
-     <listitem>
       <para>
-       Add read-only <filename>postgresql.conf</> variables <varname>segment_size</>,
-       <varname>wal_block_size</>, and <varname>wal_segment_size</> (Bernd Helmle)
+       Previously this was controlled by the presence of a root
+       certificate file in the server's data directory.
       </para>
      </listitem>
 
      <listitem>
       <para>
-       When reporting a deadlock, report all session queries involved
-       in the deadlock to the server log  (Itagaki Takahiro)
+       Add <literal>cert</> authentication method to allow user
+       authentication via <acronym>SSL</> certificates (Magnus)
+      </para>
+
+      <para>
+       Previously <acronym>SSL</> certificates could only verify that
+       the client had access to a certificate, not authenticate a
+       user.
       </para>
      </listitem>
 
      <listitem>
       <para>
-       New <function>pg_stat_get_activity(pid)</> function to return
-       information about a specific process id (Magnus)
+       Allow <literal>krb5</>, <literal>gssapi</> and <literal>sspi</>
+       realm and <literal>krb5</> host settings to be specified in
+       <filename>pg_hba.conf</> (Magnus)
+      </para>
+
+      <para>
+       These override the settings in <filename>postgresql.conf</>.
       </para>
      </listitem>
 
      <listitem>
       <para>
-       Move the server statistics file into the subdirectory
-       <filename>pg_stat_tmp</> and allow its location to be specified
-       via <varname>stats_temp_directory</> (Magnus)
+       Add <literal>krb5</>, <literal>gssapi</>, and <literal>sspi</>
+       <varname>include_realm</> parameter (Magnus)
       </para>
 
       <para>
-       This allows the statistics file to be placed in a
-       <acronym>RAM</>-resident directory to reduce I/O requirements.
-       On startup/shutdown, the file is copied to the top-level
-       <literal>$PGDATA</> directory so it is preserved between
-       restarts.
+       This allows identical usernames from different realms to be
+       authenticated as different database users using usermaps.
+      </para>
+     </listitem>
+
+     <listitem>
+      <para>
+       Show all parsing errors instead of aborting after the first
+       one (Selena Deckelmann)
       </para>
      </listitem>
 
@@ -738,137 +777,87 @@ do it for earlier branch release files.
    </sect3>
 
    <sect3>
-    <title>Authentication</title>
+    <title>Monitoring</title>
     <itemizedlist>
 
      <listitem>
       <para>
-       Report appropriate error message for combination of <literal>MD5</>
-       authentication and <varname>db_user_namespace</> enabled (Bruce)
-      </para>
-     </listitem>
-
-     <listitem>
-      <para>
-       Support regular expressions in <filename>pg_ident.conf</>
-       (Magnus)
+       Add <function>pg_conf_load_time()</> to report when
+       the Postgres configuration files were last loaded (George
+       Gensure)
       </para>
      </listitem>
 
      <listitem>
       <para>
-       Allow <productname>Kerberos</>/<acronym>GSSAPI</> parameters
-       to be changed without restarting the postmaster (Magnus)
+       Add <function>pg_terminate_backend()</> to safely terminate a
+       backend (the <literal>SIGTERM</> signal works also) (Tom, Bruce)
       </para>
      </listitem>
 
-    </itemizedlist>
-
-   </sect3>
-
-   <sect3>
-    <title><filename>pg_hba.conf</></title>
-    <itemizedlist>
-
      <listitem>
       <para>
-       Parse <filename>pg_hba.conf</> in the postmaster so errors are
-       reported on reload (Magnus)
-      </para>
-      
-      <para>
-       Previously errors in the file wouldn't be detected until clients
-       tried to connect, which could leave the system with a broken
-       file loaded.
+       Add ability to track user-defined functions call counts and
+       runtimes via parameter <varname>track_functions</> (Martin
+       Pihlak)
       </para>
-     </listitem>
 
-     <listitem>
       <para>
-       Remove the <literal>sameuser</> option, making it the default
-       if no usermap is specified (Magnus)
+       Function statistics appear in a new system table,
+       <literal>pg_stat_user_functions</>.  However, inlined
+       <acronym>SQL</> functions are not tracked.
       </para>
      </listitem>
 
      <listitem>
       <para>
-       Change all authentication options to be <literal>name=value</>
-       settings (Magnus)
-      </para>
-     </listitem>
-     
-     <listitem>
-      <para>
-       Allow usermap parameter for all external authentication methods
-       (Magnus)
-      </para>
-      
-      <para>
-       Previously this was only supported for <literal>ident</>
-       authentication.
+       Allow specification of the maximum <literal>pg_stat_activity</>
+       query string size via <varname>track_activity_query_size</>
+       parameter (Thomas Lee)
       </para>
      </listitem>
 
      <listitem>
       <para>
-       Allow <literal>ident</> authentication over Unix-domain sockets
-       on <productname>Solaris</> (Garick Hamlin)
+       Improve syslog performance by increasing the maximum line length
+       (Tom)
       </para>
      </listitem>
 
      <listitem>
       <para>
-       Add <literal>clientcert</> option to control requesting of a
-       client certificate (Magnus)
-      </para>
-
-      <para>
-       Previously this was controlled by the presence of a root
-       certificate file in the server's data directory.
+       Add read-only <filename>postgresql.conf</> variables <varname>segment_size</>,
+       <varname>wal_block_size</>, and <varname>wal_segment_size</> (Bernd Helmle)
       </para>
      </listitem>
 
      <listitem>
       <para>
-       Add <literal>cert</> authentication method to allow user
-       authentication via <acronym>SSL</> certificates (Magnus)
-      </para>
-
-      <para>
-       Previously <acronym>SSL</> certificates could only verify that
-       the client had access to a certificate, not authenticate a
-       user.
+       When reporting a deadlock, report all session queries involved
+       in the deadlock to the server log  (Itagaki Takahiro)
       </para>
      </listitem>
 
      <listitem>
       <para>
-       Allow <literal>krb5</>, <literal>gssapi</> and <literal>sspi</>
-       realm and <literal>krb5</> host settings to be specified in
-       <filename>pg_hba.conf</> (Magnus)
-      </para>
-
-      <para>
-       These override the settings in <filename>postgresql.conf</>.
+       New <function>pg_stat_get_activity(pid)</> function to return
+       information about a specific process id (Magnus)
       </para>
      </listitem>
 
      <listitem>
       <para>
-       Add <literal>krb5</>, <literal>gssapi</>, and <literal>sspi</>
-       <varname>include_realm</> parameter (Magnus)
-      </para>
-
-      <para>
-       This allows identical usernames from different realms to be
-       authenticated as different database users using usermaps.
+       Move the server statistics file into the subdirectory
+       <filename>pg_stat_tmp</> and allow its location to be specified
+       via <varname>stats_temp_directory</> (Magnus)
       </para>
-     </listitem>
 
-     <listitem>
       <para>
-       Show all parsing errors instead of aborting after the first
-       one (Selena Deckelmann)
+       This allows the statistics file to be placed in a
+       <acronym>RAM</>-resident directory to reduce I/O requirements.
+       On startup/shutdown, the file is copied to the top-level
+       <literal>$PGDATA</> directory so it is preserved between
+       restarts.
       </para>
      </listitem>
 
@@ -979,8 +968,7 @@ do it for earlier branch release files.
 
      <listitem>
       <para>
-       Improve the parser's ability to report the error location of
-       a query (Tom)
+       Improve the parser's ability to report error locations (Tom)
       </para>
      </listitem>
 
@@ -1684,6 +1672,35 @@ do it for earlier branch release files.
    </sect3>
 
    <sect3>
+    <title>Wide-Value Storage (<acronym>TOAST</>)</title>
+    <itemizedlist>
+
+     <listitem>
+      <para>
+       Consider <acronym>TOAST</> compression on values as short as
+       32 bytes (previously 256 bytes) (Tom)
+      </para>
+     </listitem>
+
+     <listitem>
+      <para>
+       Require 25% of space savings before using <acronym>TOAST</>
+       compression (previously 20%) (Tom)
+      </para>
+     </listitem>
+
+     <listitem>
+      <para>
+       Be more aggressive in storing <literal>EXTERNAL</> and
+       <literal>EXTENDED</> column values in <acronym>TOAST</>(Tom)
+      </para>
+     </listitem>
+
+    </itemizedlist>
+
+   </sect3>
+
+   <sect3>
     <title>General Functions</title>
     <itemizedlist>