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?
Date: Wed, 28 Aug 2002 08:04:35 -0700 (PDT)
Message-ID: <20020828080034.A85460-100000@megazone23.bigpanda.com> (raw)
In-Reply-To: <akeivd$1tm5$1@news.hub.org>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: sszabo@megazone23.bigpanda.com, pimentel_ligia@hotmail.com
Subject: Re: Problems with version 7.1, could they be fixed in 7.2?
In-Reply-To: <20020828080034.A85460-100000@megazone23.bigpanda.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox