From josh.berkus@pgexperts.com Wed Aug 4 00:40:41 2010 Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 7AB11633336 for ; 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 ; 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 ; 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 ) 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 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 **** Overview - Based on overwhelming user demand, this release of 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 PostgreSQL will embrace. This has all ! been done with few incompatibilities. Major enhancements are: --- 12,27 ---- Overview Based on overwhelming user demand, this release of 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 PostgreSQL will embrace. This has all ! been done with few incompatibilities. The major areas of ! enhancement are: *************** *** 29,41 **** - ! 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 (WAL) files to be streamed over a network port to a ! standby database server. --- 29,39 ---- ! 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 (WAL) files ! to be streamed over a network port to a standby database server. *************** *** 53,64 **** Broadly enhanced stored procedure support. The DO 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. --- 51,78 ---- + Add support for compiling on 64-bit + Windows and running in 64-bit + mode. + + + + + Broadly enhanced stored procedure support. The DO 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. ! ! ! ! ! ! More advanced reporting queries with additional windowing functions ! (PRECEDING and FOLLOWING) and the ability to ORDER BY inside aggregate ! functions. *************** *** 66,72 **** Triggers now support two new features, SQL-compliant per-column triggers, and conditional trigger execution. --- 80,86 ---- Triggers now support two new features, SQL-compliant per-column triggers, and conditional trigger execution. *************** *** 80,95 **** ! Exclusion constraints let database designers define uniqueness ! based on complex criteria, including for non-scalar data such ! as time periods, ranges and arrays. The LISTEN/NOTIFY 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 ---- ! New and enhanced security features, including RADIUS authentication, ! LDAP authentication improvements, and the new checkpassword optional module ! for testing password strength. The LISTEN/NOTIFY 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 **** As part of our decade-long effort to eliminate the pain of VACUUM, ! VACUUM FULL is now substantially faster by rewriting the entire table and indexes, rather than moving around single rows to compact space. --- 113,143 ---- + Add /contrib/pg_upgrade + to support in-place upgrades from 8.3 or 8.4 to 9.0. + + + + + + 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). + + + + + + Exclusion constraints let database designers define uniqueness + based on complex criteria, including for non-scalar data such + as time periods, ranges and arrays. + + + + + As part of our decade-long effort to eliminate the pain of VACUUM, ! VACUUM FULL is not substantially faster by rewriting the entire table and indexes, rather than moving around single rows to compact space. *************** *** 108,124 **** ! Add support for compiling on 64-bit ! Windows and running in 64-bit ! mode. ! Add /contrib/pg_upgrade ! to support in-place upgrades from 8.3 or 8.4 to 9.0. --- 145,159 ---- ! EXPLAIN plans are now available in JSON, XML and YAML format, and include ! buffer utilization and other data not previously available. ! The HStore optional module has been improved with new functions and greater ! data capacity to make it a high-performance key-value store. --------------020103010005010602010808-- From robertmhaas@gmail.com Fri Aug 6 17:55:29 2010 Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 9CA4B63219F for ; Fri, 6 Aug 2010 14:55:29 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 34475-09 for ; Fri, 6 Aug 2010 17:55:22 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-iw0-f174.google.com (mail-iw0-f174.google.com [209.85.214.174]) by mail.postgresql.org (Postfix) with ESMTP id 3AEFA632E80 for ; Fri, 6 Aug 2010 14:55:22 -0300 (ADT) Received: by iwn33 with SMTP id 33so1480163iwn.19 for ; Fri, 06 Aug 2010 10:55:21 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:received:in-reply-to :references:date:message-id:subject:from:to:cc:content-type :content-transfer-encoding; bh=tui3mFh7+Fr8GPyxeszpU+r2N7hNaU/vBu/W+w3B9aQ=; b=ul5jKwVEMPJnIpxpNrvFBV0PUmHcGtlgb0Vx6iHcZHMM85SuXkkMVvGXxC4/SRPjUU rljOeih5swswGbL6fksOpFmdvISp2ub0EH2O8XedSuxT4NpY+cdpBM882PISHNEk7kMO UUXeN3mjok64/JZ8fzy1kQnGy3XhD1D5JmpYc= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type:content-transfer-encoding; b=KWKwXm7yJfHFC0L2f2O6BU6QC7I9UD6mVWBbq82nr8IwZK1rWLYvMIXo9RAo5lSzj5 Uy9c2ot1MEK2mAF+CVXuO7Xl4DqwaG1Tv/WYFE+1EPRYdwA4EnEAyqjoqcXgbQkkMM6I 7fv5pJ59bxFx+VT0KLln9eswyKxyWt2sAUTiM= MIME-Version: 1.0 Received: by 10.231.177.25 with SMTP id bg25mr13844067ibb.154.1281117320943; Fri, 06 Aug 2010 10:55:20 -0700 (PDT) Received: by 10.231.32.11 with HTTP; Fri, 6 Aug 2010 10:55:20 -0700 (PDT) In-Reply-To: <4C58B6F6.6030404@pgexperts.com> References: <4C58B6F6.6030404@pgexperts.com> Date: Fri, 6 Aug 2010 13:55:20 -0400 Message-ID: Subject: Re: Patch for "big features" section of release notes From: Robert Haas To: Josh Berkus Cc: pgsql-docs@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable 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/9 X-Sequence-Number: 5833 On Tue, Aug 3, 2010 at 8:40 PM, Josh Berkus wro= te: > Attached is a patch re-arranging some of the features in the first part > of the release notes, as well as adding a few. =A0The 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. --=20 Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise Postgres Company