Thread: FOR IMMEDIATE RELEASE: PostgreSQL v7.1 Release Announcement

Date: Saturday, April 14, 2001
Subject: PostgreSQL v7.1 Release Announcement

The PostgreSQL Global Development Group is pleased to announce
the release of PostgreSQL v7.1, now available for download from
http://www.postgresql.org and our mirror sites.

After a long and arduous development cycle, v7.1 adds several
improvements to the award winning [Linux World 1999, Linux
Journal 2000] PostgreSQL open source Object-based Relational
Database application.

As with all past releases, PostgreSQL v7.1 is the result of
collaberative and cooperative efforts of a worldwide network of
independent developers and companies committed to advancing
PostgreSQL as the best open source database solution. The Global
Development Group wants to thank the hundreds of individual
contributors who have added, tested, and improved PostgreSQL
throughout the development lifecycle of this release.

Key New Features and Capabilities of Version 7.1 Include:

Write-ahead Log (WAL) increases data integrity and processing speed.
         To maintain database consistency in case of an operating
     system crash, previous releases of PostgreSQL have forced all
     all data modifications to disk before each transaction commit.
     With WAL, only one log file must be flushed to disk, greatly
     improving performance.
     (Tech note: can eliminate use of -F in to disable disk flushes)

TOAST (The Oversized-Attribute Storage Technique)
          Past releases had compiled-in row length limit typically
     between 8Kb & 32Kb.  This restriction made storage of long text
     fields difficult, cumbersome and slow. TOAST enables rows of
     any length while maintaing the high performance PostgreSQL
     users have come to expect.

SQL92 Outer Joins are now supported.
     (Tech note: eliminates the UNION/NOT IN workaround)

64-bit C Language Function Manager support
           The previous C function manager did not handle support
     64-bit CPU's (e.g. Alpha, Sun, Itanium).
     (Tech note: This change should not impact existing custom
      functions developed for past versions, but performance will
      be improved through rewriting to use the new call interface.)

Complex Queries that are better, stronger and faster
           Many complex queries were unsupported in previous
     releases. With v7.1 combinations of views, aggregates, UNION,
     LIMIT, cursors, subqueries, and inherited tables are enabled.
     Inherited tables are now accessed by default, and subqueries
     in FROM are now supported.

Marc G. Fournier
for the PostgreSQL Global Development Group

=================

For a more complete list of New Features and Bugs Fixed, please
refer to the HISTORY segment available at:

        ftp://ftp.postgresql.org/pub/README.v7_1

Source code is available at ftp://ftp.postgresql.org/pub/v7.1

For more information please contact:

"Marc G. Fournier" wrote:
>
> Date: Saturday, April 14, 2001
> Subject: PostgreSQL v7.1 Release Announcement
>

As good a place to put it as any, I guess. After a long sojourn
with MySQL I needed to go back to PostgreSQL. Installed v7.0 but
was waiting patiently for v7.1.

Then on the port.

Then I was ready to activate it. Alas, it was not to be. For
some reason I can't "initdb -W -D /home/db/...". Or rather,
I can get my cake but not in any eadible condition so to
speak. Which is no good.

I want to eat my cake!

I can't even create a database cluster, nay, system in its
default place. Well, not in any ...

The v7.0 release on the production box has no such troubles. I
can get and eat all the cake I want, as long as it's v7.0 cake.

Haven't yet tried to see v7.0 databases are v7.1 compatible.

Since I've unsubscribed the pgsql maillists some years ago, does
anyone here know if this is 'known'? Or if it's me in which case
the details of the errors of my ways would be very much appreciated!

Roelof

2nd OSDN DB Summit Call For Papers
September 23rd-25th, 2001
The Westin Providence
Providence, Rhode Island

Authors and Presenters are invited to submit papers for the 2nd annual
Open Source Development Network Database Summit. The Database summit is a
forum for the latest developments in free software related to Databases.
The kinds of topics we'd like to see include, but are not limited to:

Database Internals
Real World Database Applications
MySQL/PostgresSQL/Interbase
Writing Database Applications (frontends, etc.)
Database Programming Concerns
Kernel and Filesystems Concerns
Writing Efficient SQL
Database Administration
Database Hardware Interaction

If you would like to schedule a BOF Session, please let us know.

To submit a paper to the summit, please fill out the form below and email
it to:

    papers@osdn.com

Advisory Board:

    Britt Johnston <britt@nusphere.com>
    Michael A. Olson <mao@sleepycat.com>
    Bruce Momjian <root@candle.pha.pa.us>
    David Axmark <davida@mysql.com>
    Monty Widenius <monty@mysql.com>
    Tom Lane <tgl@sss.pgh.pa.us>

If you have any questions about the conference, please contact:

    Chris DiBona
    chris@osdn.com

Also, please see the OSDN Conferences page for more information:

http://www.osdn.com/conferences

Deadlines:

Abstract Submission Deadline    : May 18, 2001
Notification of Acceptance    : May 31, 2001
Final Papers/Proceedings Due    : August 17, 2001
Show Date            : September 23rd-25th, 2001

Please fill out the following:

1....Contact Information

Name    :
Phone    :
Email    :

2....Abstract

Please describe your presentation. Include a small outline if appropriate.

3....By submitting an abstract to OSDN you agree to being added to an event
specific speaker mailing list so that we can send you information pertinent
to speaking at the Summit.

4....Would you like to be added to a low-traffic mailinglist that explains
the conferences we need speakers for? Future CFP's would be sent to you via
this list.

OSDN operates a number of other mailing lists you may be interested in.  To
register for a list, please visit the OSDN website for more details.

Thanks!

    The OSDN Conference Team