Re: Article about PostgreSQL and RAID in Brazil

Поиск
Список
Период
Сортировка
От mudfoot@rawbw.com
Тема Re: Article about PostgreSQL and RAID in Brazil
Дата
Msg-id 1095375619.414a1b034ba63@webmail.rawbw.com
обсуждение исходный текст
Ответ на Article about PostgreSQL and RAID in Brazil  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-performance
Quoting Josh Berkus <josh@agliodbs.com>:

> The first and most important step for RAID performance with PostgreSQL is to
>
> get a card with onboard battery back-up and enable the write cache for the
> card.   You do not want to enable the write cache *without* battery back-up
>

I'm curious about this -- how do you avoid losing data if a cache stick dies?
Without redundancy, whatever hasn't been destaged to the physical media vanishes
 Dual-controller external arrays (HDS, EMC, LSI, etc.) tend to mirror (though
algorithms vary) the cache in addition to battery backup.  But do onboard arrays
tend to do this as well?

Mark

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: Article about PostgreSQL and RAID in Brazil
Следующее
От: Stephen Crowley
Дата:
Сообщение: Re: Large # of rows in query extremely slow, not using