Thread: Problems with version 7.1, could they be fixed in 7.2?
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. Thank you. Ligia
Hi Ligia, Are you running VACUUM ANALYSE or is it VACUUM ANALYZE (can never remember, though reasonably sure that its the former). Regards Mark Carew Brisbane Australia
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.
Ok. Got It. I thought that would help, also. Thanks. Ligia "Stephan Szabo" <sszabo@megazone23.bigpanda.com> 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