pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedPatch for "big features" section of release notes
2+ messages / 2 participants
[nested] [flat]
* Patch for "big features" section of release notes
@ 2010-08-04 00:40 Josh Berkus <josh.berkus@pgexperts.com>
2010-08-06 17:55 ` Re: Patch for "big features" section of release notes Robert Haas <robertmhaas@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: Josh Berkus @ 2010-08-04 00:40 UTC (permalink / raw)
To: pgsql-docs
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>
* Re: Patch for "big features" section of release notes
2010-08-04 00:40 Patch for "big features" section of release notes Josh Berkus <josh.berkus@pgexperts.com>
@ 2010-08-06 17:55 ` Robert Haas <robertmhaas@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Robert Haas @ 2010-08-06 17:55 UTC (permalink / raw)
To: Josh Berkus <josh.berkus@pgexperts.com>; +Cc: pgsql-docs
On Tue, Aug 3, 2010 at 8:40 PM, Josh Berkus <josh.berkus@pgexperts.com> wrote:
> 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.
This patch reverts a bunch of the changes in Erik Rijkers' previous
doc patch. Since you didn't mention anything about that, I'm guessing
it was unintentional. Using git can help avoid these kinds of
mistakes... rebase is your friend. If it was intentional, let's
discuss. Anyhow, I've somewhat painstakingly extracted what I believe
to be the intentional changes and am committing those now. Please
check.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2010-08-06 17:55 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-08-04 00:40 Patch for "big features" section of release notes Josh Berkus <josh.berkus@pgexperts.com>
2010-08-06 17:55 ` Robert Haas <robertmhaas@gmail.com>
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