Re: Serious Crash last Friday

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Serious Crash last Friday
Дата
Msg-id Pine.LNX.4.44.0206202049290.6888-100000@cm-lcon-46-187.cm.vtr.net
обсуждение исходный текст
Ответ на Re: Serious Crash last Friday  (Scott Marlowe <scott.marlowe@ihs.com>)
Список 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 по дате отправления:

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Idea for the statistics collector
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Download version on website