Re: Inserts optimization?

Поиск
Список
Период
Сортировка
От Michael Stone
Тема Re: Inserts optimization?
Дата
Msg-id 20060414114911.GG32678@mathom.us
обсуждение исходный текст
Ответ на Re: Inserts optimization?  (Francisco Reyes <lists@stringsutils.com>)
Список pgsql-performance
>On Thu, Apr 13, 2006 at 02:59:23PM -0400, Francisco Reyes wrote:
>>In RAID 10 would it matter that WALL is in the same RAID set?
>>Would it be better:
>>4 disks in RAID10 Data
>>2 disks RAID 1 WALL
>>2 hot spares

I guess the first question is why 2 hot spares? You don't have many
spindles, so you don't want to waste them. It might turn out that a
larger array with more spindles with outperform a smaller one with
fewer, regardless of RAID level (assuming a decent battery-backed
cache). You might try
5 RAID5
2 RAID1
1 spare

Mike Stone

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

Предыдущее
От: Francisco Reyes
Дата:
Сообщение: Re: Inserts optimization?
Следующее
От: Marc Cousin
Дата:
Сообщение: Re: Inserts optimization?