Re: Raid 10 chunksize - Mailing list pgsql-performance

From Stef Telford
Subject Re: Raid 10 chunksize
Date
Msg-id 49D39AFA.8000700@ummon.com
Whole thread Raw
In response to Re: Raid 10 chunksize  (Scott Marlowe <scott.marlowe@gmail.com>)
Responses Re: Raid 10 chunksize
Re: Raid 10 chunksize
List pgsql-performance
Scott Marlowe wrote:
> On Wed, Apr 1, 2009 at 10:15 AM, Stef Telford <stef@ummon.com> wrote:
>
>>     I do agree that the benefit is probably from write-caching, but I
>> think that this is a 'win' as long as you have a UPS or BBU adaptor,
>> and really, in a prod environment, not having a UPS is .. well. Crazy ?
>>
>
> You do know that UPSes can fail, right?  En masse sometimes even.
>
Hello Scott,
    Well, the only time the UPS has failed in my memory, was during the
great Eastern Seaboard power outage of 2003. Lots of fond memories
running around Toronto with a gas can looking for oil for generator
power. This said though, anything could happen, the co-lo could be taken
out by a meteor and then sync on or off makes no difference.

    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 ;)

    Regards
    Stef

pgsql-performance by date:

Previous
From: Matthew Wakeling
Date:
Subject: Re: self join revisited
Next
From: Matthew Wakeling
Date:
Subject: Re: Raid 10 chunksize