Re: What is the best way to storage music files in Postgresql

Поиск
Список
Период
Сортировка
От Andrej Ricnik-Bay
Тема Re: What is the best way to storage music files in Postgresql
Дата
Msg-id b35603930803180213v6a3c2e64i8a65eca5472c0b49@mail.gmail.com
обсуждение исходный текст
Ответ на Re: What is the best way to storage music files in Postgresql  ("Peter Koczan" <pjkoczan@gmail.com>)
Ответы Re: What is the best way to storage music files in Postgresql  (Craig Ringer <craig@postnewspapers.com.au>)
Список pgsql-performance
On 18/03/2008, Peter Koczan <pjkoczan@gmail.com> wrote:


>  available, and RAID 5 and RAID 6 are just huge pains and terribly slow
>  for writes.
RAID 5 and RAID 6 are just huge pains and terribly slow for writes
with small numbers of spindles....  ;}

In my testing I found that once you hit 10 spindles in a RAID5 the
differences between it and a RAID10 started to become negligible
(around 6% slower on writes average with 10 runs of bonnie++ on
10 spindles) while the read speed (if you're doing similar amounts
of reads &  writes it's a fair criterion) were in about the 10% region
faster.  With 24 spindles I couldn't see any difference at all. Those
were 73GB 15K SCAs, btw, and the SAN connected via 2GB fibre.


>  Peter
Cheers,
Andrej


--
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

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

Предыдущее
От: James Mansion
Дата:
Сообщение: Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: What is the best way to storage music files in Postgresql