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

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 capabilities are (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