From: | Alvaro Herrera <alvherre(at)atentus(dot)com> |
---|---|
To: | Scott Marlowe <scott(dot)marlowe(at)ihs(dot)com> |
Cc: | Henrik Steffen <steffen(at)city-map(dot)de>, pg <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Serious Crash last Friday |
Date: | 2002-06-21 00:51:00 |
Message-ID: | Pine.LNX.4.44.0206202049290.6888-100000@cm-lcon-46-187.cm.vtr.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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)
From | Date | Subject | |
---|---|---|---|
Next Message | terry | 2002-06-21 01:29:31 | crash problem |
Previous Message | Bruce Momjian | 2002-06-21 00:42:02 | Re: Download version on website |