From: Josh Berkus <josh.berkus@pgexperts.com>
To: pgsql-docs@postgreSQL.org
Subject: Patch for "big features" section of release notes
Date: Tue, 03 Aug 2010 17:40:22 -0700
Message-ID: <4C58B6F6.6030404@pgexperts.com> (raw)
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
Attachments:90releasenotes.intro.patch (text/x-patch, 8.0K) download
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>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: josh.berkus@pgexperts.com
Subject: Re: Patch for "big features" section of release notes
In-Reply-To: <4C58B6F6.6030404@pgexperts.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox