Re: Why HDD performance is better than SSD in this case

Поиск
Список
Период
Сортировка
От Fabio Pardi
Тема Re: Why HDD performance is better than SSD in this case
Дата
Msg-id 95d2d354-bd8c-f67d-d1f5-03072fd8a2ac@portavita.eu
обсуждение исходный текст
Ответ на Re: Why HDD performance is better than SSD in this case  (Neto pr <netopr9@gmail.com>)
Список pgsql-performance
Hi Neto,

RAID 0 to store production data should never be used. Never a good idea, in my opinion.

Simple reason is that when you lose one disk, you lose everything.

If your goal is to bench the disk, go for single disk.

If you want to be closer to a production setup, go for RAID 10, or pick a RAID setup close to what your needs and
capabilitiesare (more reads? more writes? SSD? HDD? cache? ...? )
 

If you only have 2 disks, your obliged (redundant) choice is RAID 1.

regards,

fabio pardi


On 18/07/18 03:24, Neto pr wrote:
>
>> As side note: why to run a test on a setup you can never use on production?
>>
>> regards,
>>
>> fabio pardi
>>
>
> Can you just explain why you said it below?
>
> "As side note: why to run a test on a setup you can never use on production?"
>
> You think that a RAID ZERO configuration for a DBMS is little used?
> Which one do you think would be good? I accept suggestions because I
> am in the middle of a work for my
> research of the postgraduate course and I can change the environment
> to something that is more useful and really used in real production
> environments.
>
> Best Regards
> []`s Neto



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

Предыдущее
От: Neto pr
Дата:
Сообщение: Re: Why HDD performance is better than SSD in this case
Следующее
От: Nicolas Charles
Дата:
Сообщение: Re: Why HDD performance is better than SSD in this case