Re: WAL filling up disk

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Josh Berkus" <josh(at)agliodbs(dot)com>
Cc: Chris Ruprecht <chrup999(at)yahoo(dot)com>, Roberto Mello <rmello(at)cc(dot)usu(dot)edu>, pgsql-sql(at)postgresql(dot)org
Subject: Re: WAL filling up disk
Date: 2002-02-05 21:49:52
Message-ID: 1382.1012945792@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"Josh Berkus" <josh(at)agliodbs(dot)com> writes:
>> RTFannouncelist.

> Uh, Tom, the last annoucement was ver. 7.2b5 on Janary 15th. Is this
> what you are referring to, or is there another announcement that
> should have gone out and didn't?

The release announcement went out this AM. I can't prove it right now
because I can't get into archives.postgresql.org --- which is the same
machine as ftp.postgresql.org, so I suppose it's slashdotted into
oblivion :-(. And it's also mail.postgresql.org, so perhaps not
everyone's copies have been delivered yet. But that would strongly
suggest that quite a few people did see the announcement, eh? Sorry
if you guys are at the tail end of the delivery list...

regards, tom lane

PS: my archived copy looks like:

Received: from server1.pgsql.org (www.postgresql.org [64.49.215.9])
by sss.pgh.pa.us (8.11.4/8.11.4) with SMTP id g15GC1f25200
for <tgl(at)sss(dot)pgh(dot)pa(dot)us>; Tue, 5 Feb 2002 11:12:01 -0500 (EST)
Received: (qmail 81101 invoked by alias); 5 Feb 2002 16:08:36 -0000
Received: from unknown (HELO postgresql.org) (64.49.215.8)
by www.postgresql.org with SMTP; 5 Feb 2002 16:08:36 -0000
Received: from earth.hub.org (earth.hub.org [64.49.215.11])
by postgresql.org (8.11.3/8.11.4) with ESMTP id g15G1Sl78800;
Tue, 5 Feb 2002 11:01:28 -0500 (EST)
(envelope-from scrappy(at)postgresql(dot)org)
Received: from localhost (scrappy(at)localhost)
by earth.hub.org (8.11.3/8.11.6) with ESMTP id g15G1OF20685;
Tue, 5 Feb 2002 12:01:24 -0400 (AST)
(envelope-from scrappy(at)postgresql(dot)org)
X-Authentication-Warning: earth.hub.org: scrappy owned process doing -bs
Date: Tue, 5 Feb 2002 12:01:24 -0400 (AST)
From: "Marc G. Fournier" <scrappy(at)postgresql(dot)org>
X-X-Sender: scrappy(at)earth(dot)hub(dot)org
To: pgsql-announce(at)postgresql(dot)org
cc: pgsql-hackers(at)postgresql(dot)org, <pgsql-general(at)postgresql(dot)org>
Subject: [GENERAL] PostgreSQL v7.2 Final Release
Message-ID: <20020205112231(dot)A44048-100000(at)earth(dot)hub(dot)org>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
Precedence: bulk
Sender: pgsql-general-owner(at)postgresql(dot)org

For Immediate Release February 5th, 2002

After almost a full year of development since PostgreSQL v7.1 was
released, the PostgreSQL Global Development Group is proud to announce the
availability of our latest development milestone ... PostgreSQL v7.2,
another step forward for the project.

A full list of changes to v7.2 can be found in the HISTORY file,
included with the release, as well as under all ftp mirrors as:

/pub/README.v7_2

Highlights of this release are as follows:

VACUUM
Vacuuming no longer locks tables, thus allowing normal user
access during the vacuum. A new "VACUUM FULL" command does
old-style vacuum by locking the table and shrinking the on-disk
copy of the table.

Transactions
There is no longer a problem with installations that exceed
four billion transactions.

OID's
OID's are now optional. Users can now create tables without
OID's for cases where OID usage is excessive.

Optimizer
The system now computes histogram column statistics during
"ANALYZE", allowing much better optimizer choices.

Security
A new MD5 encryption option allows more secure storage and
transfer of passwords. A new Unix-domain socket authentication
option is available on Linux and BSD systems.

Statistics
Administrators can use the new table access statistics module
to get fine-grained information about table and index usage.

Internationalization
Program and library messages can now be displayed in several
languages.

.. with many many more bug fixes, enhancements and performance
related changes ...

Source for this release is available on all mirrors under:

/pub/source/v7.2

As always, any bugs with this release should be reported to
pgsql-bugs(at)postgresql(dot)org ... and, as with all point releases, this
release requires a complete dump and reload from previous releases, due to
internal structure changes ...

Marc G. Fournier
Co-ordinator
PostgreSQL Global Development Group

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Murray Prior Hobbs 2002-02-05 22:37:19 practical limitations to number of postgres user accounts
Previous Message Josh Berkus 2002-02-05 20:53:19 Re: WAL filling up disk