PostgreSQL 10 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 | 34,997.24 | 34,997.24 | 0.913 | 4,116.554 | 20,583 | 15.507 |
| 120 | 100 | 100 | 1,000 | 33,386.52 | 33,386.52 | 0.479 | 4,117.187 | 20,586 | 15.489 | |
| 4 vCPUs | 32 GB | 120 | 500 | 100 | 5,000 | 67,719.94 | 67,719.94 | 0.472 | 7,070.501 | 35,353 | 4.518 |
| 120 | 500 | 500 | 5,000 | 57,937.06 | 57,937.06 | 0.552 | 6,039.305 | 30,197 | 5.294 | |
| 8 vCPUs | 64 GB | 120 | 1,000 | 100 | 10,000 | 94,576.89 | 94,576.89 | 0.338 | 11,082.72 | 55,414 | 5.766 |
| 120 | 1,000 | 500 | 10,000 | 91,279.68 | 91,279.68 | 0.35 | 10,102.88 | 50,514 | 6.323 | |
| 120 | 1,000 | 1,000 | 10,000 | 26,045.6 | 26,045.6 | 0.614 | 10,148.18 | 50,741 | 6.296 | |
| 16 vCPUs | 128 GB | 120 | 1,000 | 100 | 10,000 | 104,788.8 | 104,788.8 | 0.305 | 12,115.58 | 60,578 | 5.279 |
| 120 | 1,000 | 500 | 10,000 | 103,259.5 | 103,259.5 | 0.309 | 11,941.04 | 59,705 | 5.358 | |
| 120 | 1,000 | 1,000 | 10,000 | 101,724.5 | 101,724.5 | 0.314 | 12,038.66 | 60,193 | 5.31 |
Last Article: PostgreSQL 9.6 Test Data
Next Article: PostgreSQL 11 Test Data
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.