PostgreSQL 12 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,927.61 | 36,927.61 | 0.866 | 3,840.838 | 19,204 | 4.163 |
| 120 | 100 | 100 | 1,000 | 35,618.78 | 35,618.78 | 0.449 | 4,080.838 | 20,404 | 3.918 | |
| 4 vCPUs | 32 GB | 120 | 500 | 100 | 5,000 | 71,903.41 | 71,903.41 | 0.445 | 7,464.693 | 37,323 | 17.08 |
| 120 | 500 | 500 | 5,000 | 60,513.53 | 60,513.53 | 1.056 | 7,336.201 | 36,681 | 17.35 | |
| 8 vCPUs | 64 GB | 120 | 500 | 100 | 5,000 | 99,406.14 | 99,406.14 | 0.321 | 11,642.26 | 58,211 | 5.491 |
| 120 | 500 | 500 | 5,000 | 97,165.48 | 97,165.48 | 0.328 | 11,212.74 | 56,064 | 5.699 | |
| 120 | 1,000 | 100 | 10,000 | 96,790.84 | 96,790.84 | 0.329 | 10,707.55 | 53,538 | 5.97 | |
| 120 | 1,000 | 500 | 10,000 | 92,442.36 | 92,442.36 | 0.345 | 9,630.608 | 48,153 | 3.32 | |
| 120 | 1,000 | 1,000 | 10,000 | 23,799.6 | 23,799.6 | 0.672 | 9,167.153 | 45,836 | 6.962 | |
| 16 vCPUs | 128 GB | 120 | 1,000 | 100 | 10,000 | 103,650.7 | 103,650.7 | 0.308 | 14,034.1 | 70,170 | 4.557 |
| 120 | 1,000 | 500 | 10,000 | 102,389.5 | 102,389.5 | 0.312 | 12,914.5 | 64,572 | 4.952 | |
| 120 | 1,000 | 1,000 | 10,000 | 100,970.1 | 100,970.1 | 0.317 | 13,379.79 | 66,899 | 4.775 |
Last Article: PostgreSQL 11 Enhanced Edition Test Data
Next Article: PostgreSQL
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.