FOR IMMEDIATE RELEASE: PostgreSQL v7.1 Release Announcement

From: "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>
To: <pgsql-announce(at)postgresql(dot)org>
Subject: FOR IMMEDIATE RELEASE: PostgreSQL v7.1 Release Announcement
Date: 2001-04-14 05:30:55
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-announce pgsql-general

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 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:

Source code is available at

For more information please contact:


Browse pgsql-announce by date

  From Date Subject
Next Message The Hermit Hacker 2001-04-14 19:12:28 New List:
Previous Message Tom Lane 2001-04-13 16:36:58 Re: PostgreSQL v7.1 Release Candidate 4

Browse pgsql-general by date

  From Date Subject
Next Message Mike Mascari 2001-04-14 05:31:45 RE: Very slow query, Help please!
Previous Message Maurice Balick 2001-04-14 05:06:46 Re: Deadlock detected