PostgreSQL 11 Test Data
Test Result
| 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 | 27,492.9 | 27,492.9 | 1.163 | 3,584.291 | 17,921 | 8.914 |
| 120 | 100 | 100 | 1,000 | 28,846.86 | 28,846.86 | 0.554 | 3,488.25 | 17,441 | 9.16 | |
| 4 vCPUs | 32 GB | 120 | 500 | 100 | 5,000 | 56,261.5 | 56,261.5 | 0.568 | 6,354.399 | 31,772 | 20.074 |
| 120 | 500 | 500 | 5,000 | 47,058.23 | 47,058.23 | 0.679 | 5,825.554 | 29,128 | 21.897 | |
| 8 vCPUs | 64 GB | 120 | 1,000 | 100 | 10,000 | 95,182.58 | 95,182.58 | 0.336 | 10,721.74 | 53,609 | 11.895 |
| 120 | 1,000 | 500 | 10,000 | 89,324.21 | 89,324.21 | 0.358 | 10,079.84 | 50,399 | 12.647 | |
| 120 | 1,000 | 1,000 | 10,000 | 23,774.92 | 23,774.92 | 0.673 | 9,017.991 | 45,090 | 7.078 | |
| 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 10 Test Data
Next Article: PostgreSQL 11 Enhanced Edition Test Data
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.