PostgreSQL 9.6 Test Data
Test Result
Table 1 describes the test results.
| Instance Class | Test Time (s) | Data Volume (Million) | Hot Data Volume (Million) | Scale | TPS (Read-Only) | QPS (Read-Only) | Average Latency (Read-Only) | TPS (Read/Write) | QPS (Read/Write) | Average Latency (Read/Write) |
|---|---|---|---|---|---|---|---|---|---|---|
| 2 vCPUs | 16 GB | 120 | 100 | 50 | 1,000 | 36,542.44 | 36,542.44 | 0.875 | 3,880.385 | 19,402 | 16.448 |
| 120 | 100 | 100 | 1,000 | 35,476.06 | 35,476.06 | 0.451 | 4,029.257 | 20,146 | 15.839 | |
| 4 vCPUs | 32 GB | 120 | 500 | 100 | 5,000 | 72,689.28 | 72,689.28 | 0.44 | 7,696.777 | 38,484 | 4.154 |
| 120 | 500 | 500 | 5,000 | 63,544.7 | 63,544.7 | 0.503 | 7,203.794 | 36,019 | 8.871 | |
| 8 vCPUs | 64 GB | 120 | 1,000 | 100 | 10,000 | 98,303.09 | 98,303.09 | 0.324 | 11,100.02 | 55,500 | 5.761 |
| 120 | 1,000 | 500 | 10,000 | 92,038.66 | 92,038.66 | 0.347 | 10,053.22 | 50,266 | 6.355 | |
| 120 | 1,000 | 1,000 | 10,000 | 25,499.84 | 25,499.84 | 0.627 | 10,251.77 | 51,259 | 6.24 | |
| 16 vCPUs | 128 GB | 120 | 1,000 | 100 | 10,000 | 98,165.3 | 98,165.3 | 0.326 | 11,767.64 | 58,838 | 5.436 |
| 120 | 1,000 | 500 | 10,000 | 96,328.43 | 96,328.43 | 0.332 | 11,142.02 | 55,710 | 5.738 | |
| 120 | 1,000 | 1,000 | 10,000 | 94,182.02 | 94,182.02 | 0.339 | 11,042.51 | 55,213 | 5.79 |
Last Article: PostgreSQL 9.5 Test Data
Next Article: PostgreSQL 10 Test Data
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.