Re: Corrupt index

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: Corrupt index
Дата
Msg-id 20030324121636.I16920@mail.libertyrms.com
обсуждение исходный текст
Ответ на Corrupt index  ("Amir Becher" <amir@msdcapital.com>)
Список pgsql-general
On Tue, Mar 18, 2003 at 10:03:54AM -0500, Amir Becher wrote:
> I am experiencing frequent index corruptions (approximately once a
> week). I solve the problem by using the REINDEX TABLE command and
> rerunning my programs. Does anyone know why I might be experiencing
> these problems? Also, is there a way to determine whether an index is
> corrupt (other than seeing inconsistencies in the data)?

I would ask some questions about your hardware.  Memtest86 and
badblocks may be useful to you on x86 Linux.

A

--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110


В списке pgsql-general по дате отправления:

Предыдущее
От: "Anand B Kumar"
Дата:
Сообщение: Re: [HACKERS] Please clarify with regard to Renaming a Sequence
Следующее
От: "Dekkers Intermediair"
Дата:
Сообщение: Re: postgreSQL as MSSQL2000 server?