Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 61944475E97 for ; Wed, 28 Aug 2002 11:43:57 -0400 (EDT) Received: from news.hub.org (news.hub.org [64.49.215.80]) by postgresql.org (Postfix) with ESMTP id D3136475E6D for ; Wed, 28 Aug 2002 11:43:56 -0400 (EDT) Received: by news.hub.org (Postfix, from userid 8) id 7D551381952; Wed, 28 Aug 2002 11:43:55 -0400 (EDT) From: "Ligia Pimentel" X-Newsgroups: comp.databases.postgresql.sql Subject: Re: Problems with version 7.1, could they be fixed in 7.2? Date: Wed, 28 Aug 2002 09:38:41 -0500 Organization: . Lines: 44 Message-ID: References: <20020828080034.A85460-100000@megazone23.bigpanda.com> Reply-To: "Ligia Pimentel" X-Complaints-To: news@hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 To: pgsql-sql@postgresql.org X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200208/395 X-Sequence-Number: 9241 Ok. Got It. I thought that would help, also. Thanks. Ligia "Stephan Szabo" wrote in message news:20020828080034.A85460-100000@megazone23.bigpanda.com... > 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. > > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org