Date: Wed, 28 Aug 2002 08:04:35 -0700 (PDT)
From: Stephan Szabo <sszabo@megazone23.bigpanda.com>
To: Ligia Pimentel <pimentel_ligia@hotmail.com>
Cc: <pgsql-sql@postgresql.org>
Subject: Re: Problems with version 7.1, could they be fixed in 7.2?
In-Reply-To: <akeivd$1tm5$1@news.hub.org>
Message-ID: <20020828080034.A85460-100000@megazone23.bigpanda.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII

On Mon, 26 Aug 2002, Ligia Pimentel wrote:

> I've been having problems with a database in postgres 7.1, this database
> worked just fine for about 6 months, but it is a fast growing database (a
> lot of records inserted every day, almost none deleted).
>
> The problem is that the database started corrupting indexes, and tables
> (even system tables, like pg_class). I posted my questions previously with
> the specific messages, but sadly I got no reply :(...
>
> I recovered a backup and installed it on another computer to verify that it
> was not a hardware problem, but I kept having crashes every week.
>
> Last week I decided to install a new computer with postgres 7.2 and I loaded
> the database on this version. So far, no problem...
>
> I would like to know if I could expect this problems to be fixed, because I
> read on the documentation that version 7.2 was optimized for large
> databases, or should I check something else.

Possibly, there were a bunch of bugs that were fixed between the two
versions.  There have still been reports of corruption on 7.2, but almost
all of those have been traced to hardware problems.  As a note, you
probably want to run 7.2.2 if you're not already.