PostgreSQL 9.5 Test Data
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 | 38,182.15 | 38,182.15 | 0.419 | 4,231.173 | 21,156 | 3.778 |
| 120 | 100 | 100 | 1,000 | 35,673.1 | 35,673.1 | 0.896 | 4,330.887 | 21,654 | 7.375 | |
| 4 vCPUs | 32 GB | 120 | 500 | 100 | 5,000 | 69,462.87 | 69,462.87 | 0.46 | 8,218.108 | 41,091 | 7.774 |
| 120 | 500 | 500 | 5,000 | 60,999.6 | 60,999.6 | 1.046 | 7,563.455 | 37,817 | 8.442 | |
| 8 vCPUs | 64 GB | 120 | 1,000 | 100 | 10,000 | 91,376.6 | 91,376.6 | 0.35 | 10,769.54 | 53,848 | 5.933 |
| 120 | 1,000 | 500 | 10,000 | 87,050.39 | 87,050.39 | 0.688 | 9,827.995 | 49,140 | 6.499 | |
| 120 | 1,000 | 1,000 | 10,000 | 26,447.25 | 26,447.25 | 0.605 | 9,494.244 | 47,471 | 6.721 | |
| 16 vCPUs | 128 GB | 120 | 1,000 | 100 | 10,000 | 94,726.29 | 94,726.29 | 0.584 | 11,212.86 | 56,064 | 5.704 |
| 120 | 1,000 | 500 | 10,000 | 93,091 | 93,091 | 0.599 | 11,311.36 | 56,557 | 5.654 | |
| 120 | 1,000 | 1,000 | 10,000 | 92,007.3 | 92,007.3 | 0.609 | 11,036.39 | 55,182 | 5.796 |
Last Article: Test Method
Next Article: PostgreSQL 9.6 Test Data
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.