Re: Serious Crash last Friday - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Serious Crash last Friday
Date
Msg-id Pine.LNX.4.44.0206202049290.6888-100000@cm-lcon-46-187.cm.vtr.net
Whole thread Raw
In response to Re: Serious Crash last Friday  (Scott Marlowe <scott.marlowe@ihs.com>)
List pgsql-general
Scott Marlowe dijo:

> On Thu, 20 Jun 2002, Henrik Steffen wrote:

> > I have now created a cronjob that will drop and recreate all indexes on a
> > daily basis.
> >
> > But shouldn't this be unnecessary ?

[...]

> A few questions.  Have you done any really heavy testing on your server to
> make sure it has no problems with its hardware or anything?  I've seen
> machines with memory errors or bad blocks on the hard drive slip into
> production and wreak havoc due to slow corruption of a database.

Also, if you are on ix86 hardware, try running memtest86 for a few hours
on it (www.teresaudio.com/memtest86).

--
Alvaro Herrera (<alvherre[a]atentus.com>)
"La realidad se compone de muchos sueños, todos ellos diferentes,
pero en cierto aspecto, parecidos..." (Yo, hablando de sueños eróticos)


pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Idea for the statistics collector
Next
From: Bruce Momjian
Date:
Subject: Re: Download version on website