Performance¶
Test Architecture¶
NOTE
Tests were conducted on VMs in cloud infrastructure - PostgreSQL nodes with 4vCPU and 16GB RAM each.
HA PostgreSQL Performance Tests Architecture
Performance¶
Light Load¶
Number of clients: 1
Number of threads: 1
Duration: 10 minutes
| Parameter | single-node | multi-node |
|---|---|---|
| Number Of Transactions Actually Processed | 135989 | 96330 |
| Number Of Failed Transactions | 0 (0.000%) | 0 (0.000%) |
| Latency Average | 4.412 ms | 6.229 ms |
| Initial Connection Time | 9.360 ms | 9.483 ms |
| Transactions Per Second | 226 | 160 |
Heavy Load¶
Number of clients: 100
Number of threads: 16
Duration: 10 minutes
| Parameter | single-node | multi-node |
|---|---|---|
| Number Of Transactions Actually Processed | 1924444 | 1546693 |
| Number Of Failed Transactions | 0 (0.000%) | 0 (0.000%) |
| Latency Average | 31.180 ms | 38.795 ms |
| Initial Connection Time | 195.418 ms | 91.139 ms |
| Transactions Per Second | 3207 | 2577 |