Home > Storage > PowerFlex > White Papers > Delphix on Dell PowerFlex: Accelerating DevOps Workflows > Validation results
This section details the various results obtained from the Delphix engine using a sample PostgreSQL database.
The following table summarizes the results achieved on a PostgreSQL database with a 2TB workload. The operations include creation, refresh, rewind, and concurrent creation and refresh of multiple virtual databases (VDBs).
Test (PostgreSQL with 2 TB database size) | Delphix Execution Time |
Create 1 VDB | 6 sec |
Refresh 1 VDB | 9 sec |
Rewind 1 VDB | 9 sec |
Create 10 VDB simultaneous | 2 min |
Refresh 10 VDB simultaneous | 2 min |
The following table summarizes the performance results achieved on scaling PostgreSQL virtual databases with a 2TB workload each, measured using the pgbench tool.
pgbench configuration (TPCB-like workload) | Delphix | PowerFlex | ||||||||
No. of VDBs/host | No. of concurrent database sessions | Jobs | TPS | Avg latency | NFS Read IOPS | NFS Write IOPS | Read IOPS | Write IOPS | Read latency | Write latency |
1 VDB x 1 Target | 80 | 20 | 5186 | 15 ms | 10 k | 10 k | 9 k | 9 k | 0.45 ms | 0.85 ms |
4 VDB x 4 Target | 4x80 | 4x20 | 10471 | 30 ms | 18 k | 13 k | 21 k | 13 k | 0.52 ms | 1.01 ms |
8 VDB x 8 Target | 8x80 | 8x20 | 11416 | 50 ms | 21 k | 13 k | 25 k | 13 k | 0.52 ms | 1.01 ms |
The following table summarizes the results obtained when performing masking operations on entries within a scaling PostgreSQL database table using the Delphix Appliance.
PostgreSQL | Delphix Execution Time | |
Workload (Target VDB) | PROFILE | MASK |
5 million Rows (1x table) | 2 sec | 2 min 5 sec |
10 million Rows (1x table) | 2 sec | 4 min 4 sec |
20 million Rows (1x table) | 2 sec | 8 min 10 sec |
100 million Rows (1x table) | 2 sec | 42 min 13 sec |