Re: coping with failing disks - Mailing list pgsql-general

From Vick Khera
Subject Re: coping with failing disks
Date
Msg-id AANLkTing-SNuDoeqsWQURpZFdzyvybcSYSQGR4EgzLgc@mail.gmail.com
Whole thread Raw
In response to coping with failing disks  (Joachim Worringen <joachim.worringen@iathh.de>)
Responses Re: coping with failing disks  (Joachim Worringen <joachim.worringen@iathh.de>)
List pgsql-general
On Thu, Sep 2, 2010 at 8:16 AM, Joachim Worringen
<joachim.worringen@iathh.de> wrote:
> Would the consistency of the database be affected if all indices are
> suddenly gone?

The unique constraint is implemented as a unique index. So I'd say
"yeah, you could break your consistency".

Why not purchase a robust RAM/SSD disk system designed for DB use
rather than hacking one up on the cheap?

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Recreating constraint triggers
Next
From: Joachim Worringen
Date:
Subject: Re: coping with failing disks