| From: | Andrew Sullivan <andrew(at)libertyrms(dot)info> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Corrupt index |
| Date: | 2003-03-24 17:16:36 |
| Message-ID: | 20030324121636.I16920@mail.libertyrms.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2003-03-24 17:16:58 | Re: alter table change type column |
| Previous Message | Andrew Sullivan | 2003-03-24 17:13:01 | Re: Point in time recovery? |