Re: Why HDD performance is better than SSD in this case - Mailing list pgsql-performance

From Fabio Pardi
Subject Re: Why HDD performance is better than SSD in this case
Date
Msg-id 2ca77872-d2d4-07be-2fce-5f63879dc6cc@portavita.eu
Whole thread Raw
In response to Re: Why HDD performance is better than SSD in this case  (Neto pr <netopr9@gmail.com>)
Responses Re: Why HDD performance is better than SSD in this case
List pgsql-performance

On 07/17/2018 04:05 PM, Neto pr wrote:
> 2018-07-17 10:55 GMT-03:00 Fabio Pardi <f.pardi@portavita.eu>:

>> Also i think it makes not much sense testing on RAID 0. I would start
>> performing tests on a single disk, bypassing RAID (or, as mentioned, at
>> least disabling cache).
>>
> 
> But in my case, both the 2 SSDs and the 2 HDDs are in RAID ZERO.
> This way it would not be a valid test ? Because the 2 environments are
> in RAID ZERO.
> 
> 

in theory, probably yes and maybe not.
In RAID 0, data is (usually) striped in a round robin fashion, so you
should rely on the fact that, in average, data is spread 50% on each
disk. For the sake of knowledge, you can check what your RAID controller
is actually using as algorithm to spread data over RAID 0.

But you might be in an unlucky case in which more data is on one disk
than in another.
Unlucky or created by the events, like you deleted the records which are
on disk 0 and you only are querying those on disk 1, for instance.

The fact is, that more complexity you add to your test, the less the
results will be closer to your expectations.

Since you are testing disks, and not RAID, i would start empirically and
perform the test straight on 1 disk.
A simple test, like dd i mentioned here above.
If dd, or other more tailored tests on disks show that SSD is way slow,
then you can focus on tuning your disk. or trashing it :)

When you are satisfied with your results, you can build up complexity
from the reliable/consolidated level you reached.

As side note: why to run a test on a setup you can never use on production?

regards,

fabio pardi




pgsql-performance by date:

Previous
From: Nicolas Charles
Date:
Subject: Re: Why HDD performance is better than SSD in this case
Next
From: Tomas Vondra
Date:
Subject: Re: Special bloom index of INT, BIGINT, BIT, VARBIT for bitwiseoperation