Ok. Got It. I thought that would help, also. Thanks. Ligia "Stephan Szabo" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > 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
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])