|
|
Subscribe / Log in / New account

PostgreSQL 8.0.0 released

From:  josh-AT-postgresql.org
To:  pr-AT-lwn.net
Subject:  PostgreSQL 8.0.0 Released
Date:  Wed, 19 Jan 2005 08:05:58 +0000 (GMT)


FOR IMMEDIATE RELEASE

NY, NY: 19 January 2005 - The PostgreSQL Global Development group has released
version 8.0 of the PostgreSQL object-relational database management system, 
building on its position as the most advanced open source database in the 
world. This release includes features previously only available in the most 
expensive proprietary database systems, and is expected to substantially 
increase the adoption of PostgreSQL by both users and software vendors.

In addition to significant improvements in scalability, features, and 
performance, PostgreSQL 8.0 demonstrates the unparalleled development speed 
of open source.  More than a dozen companies, including Red Hat, Fujitsu, 
Afilias, Software Research Associates, Inc., 2nd Quadrant, and Command Prompt 
Inc., as well as hundreds of individual developers, contributed to add more 
major features to 8.0 than have been seen in any previous version.

"We are confident that these enterprise features will attract a great number 
of new PostgreSQL users.", said Mr. Takayuki Nakazawa, Director of Fujitsu's 
OSS Database in Software Group. "Fujitsu is proud of its sponsorship of 
contributions to PostgreSQL and of its work with the PostgreSQL community. We 
are committed to helping make PostgreSQL the leading Database Management 
System."

New features include:

Native Windows Support:  PostgreSQL now works natively with Windows systems 
and does not need an emulation layer.  This provides dramatically improved 
performance over previous versions, and offers a compelling alternative to 
proprietary database software for independent software vendors, corporate 
users, and individual Windows developers.

Savepoints:  This SQL-standard feature allows specific parts of a database 
transaction to be rolled back without aborting the entire operation. This 
benefits business application developers who require complex transactions 
with error recovery.

Point in Time Recovery: This feature allows full data restoration from the 
automatic and continuously archived transaction logs. It provides a 
long-sought alternative to hourly or daily backups for data-critical services 
on PostgreSQL.

Tablespaces:  Crucial to the administrators of multi-gigabyte data warehousing
systems, tablespaces allow the placement of large tables and indexes on their 
own individual disks or arrays, improving query performance.

Improved Memory and I/O:  Disk and memory usage have been optimized through 
the use of the Adaptive Replacement Cache algorithm, the new background 
writer, and the new vacuum delay feature.   This will result in more 
predictable loads and substantially more consistent performance during peak 
usage times.

Javier Soltero, Chief Architect at Hyperic LLC, said, "PostgreSQL 8.0 gives us
the high degree of concurrency and throughput required by our HQ monitoring 
product. Having PostgreSQL 8.0 supported natively on Windows means we can now 
bundle PostgreSQL in our product and benefit from the proven scalability and 
performance of PostgreSQL, as well as its license, which allows us to include 
it in our distribution free of commercial obligations."

In addition to the many features bundled with the release, PostgreSQL has been
enhanced by accelerated development of add-ons and optional components over 
the last year.    The Slony-I replication tool and the pgPool connection 
pooling/brokering utility are both already being used for high-availability 
server pools.   Several stored procedure languages have been added or greatly 
expanded, including PL/Java, PL/J, PL/PHP and PL/Perl, while the Npgsql and 
PGsqlClient .NET data providers have been enhanced to support the many new 
Windows users.

For a full list and description of the many new features in 8.0, please see 
our press page: http://www.postgresql.org/about/press/presskit80.html

About PostgreSQL: PostgreSQL is the collective work of hundreds of developers,
building on almost twenty years of development which started at the 
University of California at Berkeley.  With its long-time support of an 
enterprise level feature set including transactions, functions, triggers, and 
subqueries, PostgreSQL is being used by many of today's most demanding 
businesses and government agencies. PostgreSQL is distributed under a BSD 
license, which allows use and distribution without fees for both commercial 
and non-commercial applications.

To find out more about PostgreSQL or to download it, please visit:
        http://www.postgresql.org/

For information about Fujitsu and Hyperic LLC, please see our press page.



to post comments

Big thank you!

Posted Jan 19, 2005 22:35 UTC (Wed) by bojan (subscriber, #14302) [Link] (4 responses)

Thanks everyone that put effort into making PostgreSQL so good. You are doing a fabulous job!

Big thank you seconded!

Posted Jan 19, 2005 23:51 UTC (Wed) by ccyoung (guest, #16340) [Link] (3 responses)

great job! a real pleasure to work with this db.

minor notes:

not mentioned anywhere but supposedly there are session variables (dangerous but delicious).

added parameters to cursors.

vacuum sucks. they've made it into a lightweight process - now the final step is to make it simply an on-going, self-tuning part of pg itself. (as with analyze.)

still no autonomous transactions (sorry, personal favorite)

un-defaulted oids - what little objectness seems to be taking a backseat to mainstream sql issues.

nice formalization of function/transaction dependencies so they can be properly optimized (and written).

ms binary, although chewing gum in some people's eyes (eg, mine), a huge step in greater acceptance (compare Evolution to Firefox).

would love to see osd or apache take pg under its wings. with the little bit of money it's taken big strides, imho on the threshhold of the killer app.

Big thank you seconded!

Posted Jan 20, 2005 1:02 UTC (Thu) by prasadgc (guest, #27375) [Link]

ccyoung said:

> vacuum sucks.

isn't that what vacuum is expected to do? ;-)

Ganesh

Big thank you seconded!

Posted Jan 20, 2005 21:00 UTC (Thu) by sbergman27 (guest, #10767) [Link]

> vacuum sucks.

pg_autovacuum is included with the distribution and handles the vacuuming as needed, automatically.

Think of it as a sort of Roomba for your database.

Big thank you seconded!

Posted Jan 21, 2005 1:01 UTC (Fri) by zblaxell (subscriber, #26385) [Link]

"un-defaulted oids" - and good riddance, I say. I can finally stop
writing "without oids" except for the extremely rare occurrences where I
actually want a table that can be inherited from. Man, that was
annoying. ;-)

Am I missing something, or is there very little useful about OO tables
that can't be achieved with some rules and triggers on a conventional (or
at least non-OO) database? Seems to me the OID does basically the same
thing an integer sequence primary key does, except using built-in
facilities instead of some views and insert/update/delete hooks. Does the
back-end do some incredibly efficient organization of tables with an
inheritance relationship, or is it just a legacy PostgreSQL-specific
syntax for something that could now be implemented in plain SQL?


Copyright © 2005, Eklektix, Inc.
Comments and public postings are copyrighted by their creators.
Linux is a registered trademark of Linus Torvalds