Re: Raid 10 chunksize

Поиск
Список
Период
Сортировка
От Stef Telford
Тема Re: Raid 10 chunksize
Дата
Msg-id 49D39AFA.8000700@ummon.com
обсуждение исходный текст
Ответ на Re: Raid 10 chunksize  (Scott Marlowe <scott.marlowe@gmail.com>)
Ответы Re: Raid 10 chunksize  (Scott Marlowe <scott.marlowe@gmail.com>)
Re: Raid 10 chunksize  (Matthew Wakeling <matthew@flymine.org>)
Список 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 по дате отправления:

Предыдущее
От: Matthew Wakeling
Дата:
Сообщение: Re: self join revisited
Следующее
От: Matthew Wakeling
Дата:
Сообщение: Re: Raid 10 chunksize