There are two use cases considered for running tests on the Greenplum cluster.
The first use case is to run the data load along with 182 parallel complex queries test simultaneously to stress the system. These are the actual production queries extracted from Dell Digital team workload.
Table 2. Parameters
Time taken for test | 11.58 min |
Read bandwidth | 40 GB/s |
Write Bandwidth | 10 GB/s |
It is observed there was no bottleneck at the storage side of PowerFlex when this test was run. The network bandwidth picked close to 50 GB/s which is the maximum limit that can be achieved as the network card has 2 x 25 GB/s support.
The second use case is to create a storage-consistent snapshot while the above test of data load along with 182 parallel queries is being run.
Table 3. Parameters
Time taken for test | 12.33 min |
Read bandwidth | 32 GB/s |
Write Bandwidth | 9 GB/s |
When the snapshot is taken, the maximum bandwidth at PowerFlex is seen at 41 GB/s. The read bandwidth is at 32 GB/s whereas the write bandwidth is at 9 GB/s. This bandwidth drop is temporary due to the heavy load on the system (relative to its size) at the time of the snapshot and was not seen when the workload was run again.
