Thread: Please check text of community announcement ASAP

Please check text of community announcement ASAP

From
Josh Berkus
Date:
Folks,

I'll be sending this out in one hour, so please check for awful gaffs:

========================================
After eight months of development and five months of integration and
testing, the PostgreSQL Global Development Group now announces the
availability of PostgreSQL version 8.2 (our 14th public release).

Among the features of this new version are:
-- Average 20% overall performance improvement
-- Warm standby databases
-- Online index builds
-- SQL2003 aggregates
-- Improved TSearch2 with Generalized Inverted Indexes
-- Support for DTrace probes
-- Advisory Locks
-- New ISN/ISBN and pgCrypto modules
-- Selective pg_dump options

... and many more included in the over 300 patches which went into this
version.

For highlights of the release, please see the press kit:
http://www.postgresql.org/about/press/presskit82.html.en

Downloads:
    Source: http://www.postgresql.org/ftp/source/v8.2/
    Windows Binaries: http://www.postgresql.org/ftp/binary/v8.2.0/win32/
    Red Hat RPMs: http://www.postgresql.org/ftp/binary/v8.2.0/linux/rpms/

Packages and ports for OSX, Solaris, Ubuntu, Debian, SuSE and other
operating systems will be available in the weeks and months to come,
either from postgresql.org or from the platform vendor.

Version 8.2 will be announced and discussed at the LISA conference in
Washington DC, at the PostgreSQL booth and BOF:
http://www.usenix.org/events/lisa06/

Re: Please check text of community announcement ASAP

From
"Joshua D. Drake"
Date:
On Tue, 2006-12-05 at 13:42 -0500, Josh Berkus wrote:
> Folks,
>
> I'll be sending this out in one hour, so please check for awful gaffs:
>
> ========================================
> After eight months of development and five months of integration and
> testing, the PostgreSQL Global Development Group now announces the
> availability of PostgreSQL version 8.2 (our 14th public release).
>
> Among the features of this new version are:
> -- Average 20% overall performance improvement
> -- Warm standby databases
> -- Online index builds

I still think that Online index builds sounds wierd. Non blocking?
Non-locking? etc... but it isn't a huge problem.

Sincerely,
Joshua D. Drake


> -- SQL2003 aggregates
> -- Improved TSearch2 with Generalized Inverted Indexes
> -- Support for DTrace probes
> -- Advisory Locks
> -- New ISN/ISBN and pgCrypto modules
> -- Selective pg_dump options
>
> ... and many more included in the over 300 patches which went into this
> version.
>
> For highlights of the release, please see the press kit:
> http://www.postgresql.org/about/press/presskit82.html.en
>
> Downloads:
>     Source: http://www.postgresql.org/ftp/source/v8.2/
>     Windows Binaries: http://www.postgresql.org/ftp/binary/v8.2.0/win32/
>     Red Hat RPMs: http://www.postgresql.org/ftp/binary/v8.2.0/linux/rpms/
>
> Packages and ports for OSX, Solaris, Ubuntu, Debian, SuSE and other
> operating systems will be available in the weeks and months to come,
> either from postgresql.org or from the platform vendor.
>
> Version 8.2 will be announced and discussed at the LISA conference in
> Washington DC, at the PostgreSQL booth and BOF:
> http://www.usenix.org/events/lisa06/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>
--

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
             http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate




Re: [CORE] Please check text of community announcement ASAP

From
Tom Lane
Date:
Josh Berkus <josh@agliodbs.com> writes:
> Among the features of this new version are:
> -- Average 20% overall performance improvement

Hmm, do we have any numbers backing that up?  Some things improved much
more than that, some not at all, so I'm kinda wondering where "20% overall"
came from.  If you're basing that on one specific benchmark you oughta
say which one.

> -- Warm standby databases

I think we could do that already, it just didn't work as smoothly.
Maybe "Better support for warm standby databases" would be better.

The rest of it seems OK to me.

            regards, tom lane

Re: [CORE] Please check text of community announcement ASAP

From
Josh Berkus
Date:
Tom,

>> -- Average 20% overall performance improvement
>
> Hmm, do we have any numbers backing that up?  Some things improved much
> more than that, some not at all, so I'm kinda wondering where "20% overall"
> came from.  If you're basing that on one specific benchmark you oughta
> say which one.

TPCC scores, according to Unisys, and the Tweakers.net benchmark.  The
actual press release is more specific.  The idea was for the community
announcement to be brief.

So:
Higher performance (+20% in OLTP benchmarks)

>
>> -- Warm standby databases
>
> I think we could do that already, it just didn't work as smoothly.
> Maybe "Better support for warm standby databases" would be better.

Ok, "improved"

--Josh

Re: [CORE] Please check text of community announcement

From
"Joshua D. Drake"
Date:
On Tue, 2006-12-05 at 14:28 -0500, Tom Lane wrote:
> Josh Berkus <josh@agliodbs.com> writes:
> > Among the features of this new version are:
> > -- Average 20% overall performance improvement
>
> Hmm, do we have any numbers backing that up?  Some things improved much
> more than that, some not at all, so I'm kinda wondering where "20% overall"
> came from.  If you're basing that on one specific benchmark you oughta
> say which one.

I have pgbench marks that reflect that...

Sincerely,

Joshua D. Drake

--

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
             http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate



Attachment

Re: [CORE] Please check text of community announcement ASAP

From
Dave Page
Date:
Josh Berkus wrote:
> Tom,
>
>>> -- Average 20% overall performance improvement
>>
>> Hmm, do we have any numbers backing that up?  Some things improved much
>> more than that, some not at all, so I'm kinda wondering where "20%
>> overall"
>> came from.  If you're basing that on one specific benchmark you oughta
>> say which one.
>
> TPCC scores, according to Unisys, and the Tweakers.net benchmark.  The
> actual press release is more specific.  The idea was for the community
> announcement to be brief.
>
> So:
> Higher performance (+20% in OLTP benchmarks)

Do we actually know what Tweakers are doing? Their graphs and articles
seem very good n'all, but the best I've been able to ascertain is that
it's some in-house benchmark based on their own (99% read only?)
website. Not that that's a bad thing, just not exactly OLTP...

Regards, Dave.

Re: [CORE] Please check text of community announcement ASAP

From
Tom Lane
Date:
Dave Page <dpage@postgresql.org> writes:
> Josh Berkus wrote:
>> Higher performance (+20% in OLTP benchmarks)

> Do we actually know what Tweakers are doing? Their graphs and articles
> seem very good n'all, but the best I've been able to ascertain is that
> it's some in-house benchmark based on their own (99% read only?)
> website. Not that that's a bad thing, just not exactly OLTP...

Another problem is that the Tweakers result Josh is quoting is based on
"8.2devel", which turns out to mean a CVS pull from 3-Jun-2006, which is
quite a bit different from 8.2 final --- and Arjen says 8.2 final looks
a lot worse:
http://archives.postgresql.org/pgsql-performance/2006-12/msg00041.php
I've been discussing this with him off-list and trying to figure out
why such a drop, but no answers yet.  I'm pretty hesitant to wave that
Tweakers article around until we know what's going on here.  If we have
other benchmarks we can point to that justify the "20%" number, then
it's OK to use ...

            regards, tom lane

Re: [CORE] Please check text of community announcement ASAP

From
Josh Berkus
Date:
Tom, Dave,

I do actually have information about the Tweakers workload, which I'll
be posting on my blog later.


Anyway, the original 20% number came from Doug at Unisys in TPCC
testing.  I'm actually searching the archives so that I can quote him ....

--Josh