Re: Corrupt index - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: Corrupt index
Date
Msg-id 20030324121636.I16920@mail.libertyrms.com
Whole thread Raw
In response to Corrupt index  ("Amir Becher" <amir@msdcapital.com>)
List 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 by date:

Previous
From: "Anand B Kumar"
Date:
Subject: Re: [HACKERS] Please clarify with regard to Renaming a Sequence
Next
From: "Dekkers Intermediair"
Date:
Subject: Re: postgreSQL as MSSQL2000 server?