Re: Index Corruption

From: Dylan Adams <dylan(dot)adams(dot)work(at)gmail(dot)com>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Index Corruption
Date: 2011-09-12 22:27:41
Message-ID: CA+Rt69YXc78m8hxMSEFTpHc15fWkX86CYg+EFf6e9S5WmzkK1Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Sep 12, 2011 at 3:51 PM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:
> Are you sure you aren't having either server or RAID problems of some
> kind?  Single bit memory errors or bad sectors not getting remapped
> before corrupting data etc? Have you torture tested your hardware to
> ensure it's rock solid stable?  Dell's insistence on using non
> buffered memory has cause me untold problems with single bit errors in
> the past.  I don't know if they still use unbuffered memory in their
> servers or not as I gave up on Dell three or four years ago for
> servers and support.

Current servers (R710s) use DDR3 - Synchronous Registered (Buffered) ECC memory.

We don't think there's anything wrong with the hardware, as the
problem has persisted across various physical servers (the R710s
replaced 2950s). We also don't have any other intermittent issues
(postgres crashes, application server crashes, etc) that would
indicate random bit errors.

Thanks,
dylan

In response to

Browse pgsql-general by date

  From Date Subject
Next Message pasman pasmański 2011-09-12 23:07:34 Compatibility 9.1rc and 9.1.0
Previous Message Merlin Moncure 2011-09-12 22:07:01 Re: Unlogged table restart