Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id 7AB11633336
	for <pgsql-docs-postgresql.org@mail.postgresql.org>;
	Tue,  3 Aug 2010 21:40:41 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 54058-08 for
	<pgsql-docs-postgresql.org@mail.postgresql.org>;
	Wed,  4 Aug 2010 00:40:32 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from glacier.frostconsultingllc.com (glacier.frostconsultingllc.com
	[69.36.227.170])
	by mail.postgresql.org (Postfix) with ESMTP id 7FB3A632540
	for <pgsql-docs@postgreSQL.org>; Tue,  3 Aug 2010 21:40:33 -0300 (ADT)
Received: from dsl081-245-111.sfo1.dsl.speakeasy.net ([64.81.245.111]
	helo=Sidney-Stratton.local)
	by glacier.frostconsultingllc.com with esmtpsa
	(TLSv1:CAMELLIA256-SHA:256) (Exim 4.69)
	(envelope-from <josh.berkus@pgexperts.com>) id 1OgS1v-0005Y4-1U
	for pgsql-docs@postgreSQL.org; Tue, 03 Aug 2010 17:40:29 -0700
Message-ID: <4C58B6F6.6030404@pgexperts.com>
Date: Tue, 03 Aug 2010 17:40:22 -0700
From: Josh Berkus <josh.berkus@pgexperts.com>
User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US;
	rv:1.9.1b3pre) Gecko/20090223 Thunderbird/3.0b2
MIME-Version: 1.0
To: pgsql-docs@postgreSQL.org
Subject: Patch for "big features" section of release notes
Content-Type: multipart/mixed; boundary="------------020103010005010602010808"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.9 tagged_above=-5 required=5 tests=BAYES_00=-1.9
X-Spam-Level: 
X-Archive-Number: 201008/1
X-Sequence-Number: 5825

This is a multi-part message in MIME format.
--------------020103010005010602010808
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit

All,

Attached is a patch re-arranging some of the features in the first part
of the release notes, as well as adding a few.  The additions are based
on (a) votes on what's a big feature for 9.0, and (b) a desire to match
the features listed elsewhere, such as the press kit.

-- 
-- Josh Berkus
---------------------------------------------------------
Josh Berkus                       PostgreSQL Experts Inc.
CEO                               database professionals
josh.berkus@pgexperts.com         www.pgexperts.com
1-888-743-9778 x.508              San Francisco

--------------020103010005010602010808
Content-Type: text/x-patch;
 name="90releasenotes.intro.patch"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
 filename="90releasenotes.intro.patch"

Index: release-9.0.sgml
===================================================================
RCS file: /projects/cvsroot/pgsql/doc/src/sgml/release-9.0.sgml,v
retrieving revision 2.44
diff -c -r2.44 release-9.0.sgml
*** release-9.0.sgml	29 Jul 2010 21:18:11 -0000	2.44
--- release-9.0.sgml	4 Aug 2010 00:25:34 -0000
***************
*** 12,27 ****
  
    <sect2>
     <title>Overview</title>
- 
     <para>
      Based on overwhelming user demand, this release of
      <productname>PostgreSQL</> adds features that have been requested
      for years, like easy-to-use replication, a mass permission
      facility, and anonymous blocks. While past major releases have
!     been conservative in their scope, this release shows a
!     bold new desire to provide facilities that new and existing
!     users of <productname>PostgreSQL</> will embrace. This has all
!     been done with few incompatibilities. Major enhancements are:
     </para>
  
     <itemizedlist>
--- 12,27 ----
  
    <sect2>
     <title>Overview</title>
     <para>
      Based on overwhelming user demand, this release of
      <productname>PostgreSQL</> adds features that have been requested
      for years, like easy-to-use replication, a mass permission
      facility, and anonymous blocks. While past major releases have
!     been quite conservative in their scope, this release shows a
!     bold new desire to provide facilities that every new and existing
!     user of <productname>PostgreSQL</> will embrace. This has all
!     been done with few incompatibilities. The major areas of
!     enhancement are:
     </para>
  
     <itemizedlist>
***************
*** 29,41 ****
      <!-- This list duplicates items below, but without authors or details-->
  
      <listitem>
- 
       <para>
!       Built-in, binary, log-based replication.  This advance consists of two
!       features: Hot Standby allows continuous archive standby database servers
!       to accept read-only queries, and Streaming Replication allows continuous
!       archive (<acronym>WAL</>) files to be streamed over a network port to a
!       standby database server.
       </para>
      </listitem>
  
--- 29,39 ----
      <!-- This list duplicates items below, but without authors or details-->
  
      <listitem>
       <para>
!       Built-in, binary, log-based replication.  This advance consists of two features:
!       Hot Standby allows continuous archive standby database servers to accept read-only
!       queries, and Streaming Replication allows continuous archive (<acronym>WAL</>) files 
!       to be streamed over a network port to a standby database server.
       </para>
      </listitem>
  
***************
*** 53,64 ****
  
      <listitem>
       <para>
        Broadly enhanced stored procedure support.
        The <link linkend="SQL-DO"><command>DO</></link> statement permits
!       anonymous code blocks.  Functions can now be called using named
!       parameters.  PL/pgSQL is now installed by default, and PL/Perl and
!       PL/Python have been enhanced in several ways, including support for
!       Python3.
       </para>
      </listitem>
  
--- 51,78 ----
  
      <listitem>
       <para>
+       Add support for compiling on <link
+       linkend="install-win32-full">64-bit
+       <productname>Windows</></link> and running in 64-bit
+       mode.
+      </para>
+     </listitem>
+ 
+     <listitem>
+      <para>
        Broadly enhanced stored procedure support.
        The <link linkend="SQL-DO"><command>DO</></link> statement permits
!       ad-hoc or anonymous code blocks.  Functions can now be called using named
!       parameters.  PL/pgSQL is now installed by default, and PL/Perl and PL/Python
!       have been enhanced in several ways, including support for Python3.
!      </para>
!     </listitem>
! 
!     <listitem>
!      <para>
!       More advanced reporting queries with additional windowing functions 
!       (PRECEDING and FOLLOWING) and the ability to ORDER BY inside aggregate
!       functions.
       </para>
      </listitem>
  
***************
*** 66,72 ****
       <para>
        Triggers now support two new features,
        SQL-compliant <link
!       linkend="SQL-CREATETRIGGER">per-column triggers</link>, and
        conditional trigger execution.
       </para>
      </listitem>
--- 80,86 ----
       <para>
        Triggers now support two new features,
        SQL-compliant <link
!       linkend="SQL-CREATETRIGGER">per-column triggers</link>, and 
        conditional trigger execution.
       </para>
      </listitem>
***************
*** 80,95 ****
  
      <listitem>
       <para>
!       Exclusion constraints let database designers define uniqueness
!       based on complex criteria, including for non-scalar data such
!       as time periods, ranges and arrays.
       </para>
      </listitem>
  
      <listitem>
       <para>
        The <link linkend="SQL-LISTEN"><command>LISTEN</></link>/<link
!       linkend="SQL-NOTIFY"><command>NOTIFY</></link>
        feature has been overhauled to make it into
        a high-performance event queuing system.  It now stores
        events in a memory-based queue, and it now allows delivery
--- 94,109 ----
  
      <listitem>
       <para>
!       New and enhanced security features, including RADIUS authentication,
!       LDAP authentication improvements, and the new checkpassword optional module
!       for testing password strength.
       </para>
      </listitem>
  
      <listitem>
       <para>
        The <link linkend="SQL-LISTEN"><command>LISTEN</></link>/<link
!       linkend="SQL-NOTIFY"><command>NOTIFY</></link> 
        feature has been overhauled to make it into
        a high-performance event queuing system.  It now stores
        events in a memory-based queue, and it now allows delivery
***************
*** 99,106 ****
  
      <listitem>
       <para>
        As part of our decade-long effort to eliminate the pain of VACUUM,
!       <command>VACUUM FULL</> is now substantially faster by
        rewriting the entire table and
        indexes, rather than moving around single rows to compact space.
       </para>
--- 113,143 ----
  
      <listitem>
       <para>
+       Add <link linkend="pgupgrade"><filename>/contrib/pg_upgrade</></link>
+       to support in-place upgrades from 8.3 or 8.4 to 9.0.
+      </para>
+     </listitem>
+ 
+     <listitem>
+      <para>
+       Multiple performance enhancements for specific types of queries, 
+       including join elimination, which optimizes automatically generated
+       queries, such as those produced by object-relational mappers (ORMs).
+      </para>
+     </listitem>
+ 
+     <listitem>
+      <para>
+       Exclusion constraints let database designers define uniqueness
+       based on complex criteria, including for non-scalar data such
+       as time periods, ranges and arrays.
+      </para>
+     </listitem>
+ 
+     <listitem>
+      <para>
        As part of our decade-long effort to eliminate the pain of VACUUM,
!       <command>VACUUM FULL</> is not substantially faster by
        rewriting the entire table and
        indexes, rather than moving around single rows to compact space.
       </para>
***************
*** 108,124 ****
  
      <listitem>
       <para>
!       Add support for compiling on <link
!       linkend="install-win32-full">64-bit
!       <productname>Windows</></link> and running in 64-bit
!       mode.
       </para>
      </listitem>
  
      <listitem>
       <para>
!       Add <link linkend="pgupgrade"><filename>/contrib/pg_upgrade</></link>
!       to support in-place upgrades from 8.3 or 8.4 to 9.0.
       </para>
      </listitem>
  
--- 145,159 ----
  
      <listitem>
       <para>
!       EXPLAIN plans are now available in JSON, XML and YAML format, and include
!       buffer utilization and other data not previously available.
       </para>
      </listitem>
  
      <listitem>
       <para>
!       The HStore optional module has been improved with new functions and greater
!       data capacity to make it a high-performance key-value store.
       </para>
      </listitem>
  

--------------020103010005010602010808--