Re: Raid 10 chunksize - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: Raid 10 chunksize
Date
Msg-id dcc563d10904011004u11b7b4a2mb637fa841eba49c2@mail.gmail.com
Whole thread Raw
In response to Re: Raid 10 chunksize  (Matthew Wakeling <matthew@flymine.org>)
List pgsql-performance
On Wed, Apr 1, 2009 at 11:01 AM, Matthew Wakeling <matthew@flymine.org> wrote:
> On Wed, 1 Apr 2009, Stef Telford wrote:
>>
>>   Good UPS, a warm PITR standby, offsite backups and regular checks is
>> "good enough" for me, and really, that's what it all comes down to.
>> Mitigating risk and factors into an 'acceptable' amount for each person.
>> However, if you see over a 2x improvement from turning write-cache 'on'
>> and have everything else in place, well, that seems like a 'no-brainer'
>> to me, at least ;)
>
> In that case, buying a battery-backed-up cache in the RAID controller would
> be even more of a no-brainer.

This is especially true in that you can reduce downtime.  A lot of
times downtime costs as much as anything else.

pgsql-performance by date:

Previous
From: Matthew Wakeling
Date:
Subject: Re: Raid 10 chunksize
Next
From: Matthew Wakeling
Date:
Subject: Re: Very specialised query