PostgreSQL 11 Enhanced Edition 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 | 29,662.82 | 29,662.82 | 0.539 | 3,212.977 | 16,065 | 4.975 |
| 120 | 100 | 100 | 1,000 | 28,749.75 | 28,749.75 | 0.556 | 3,376.902 | 16,885 | 4.734 | |
| 4 vCPUs | 32 GB | 120 | 500 | 100 | 5,000 | 58,017.65 | 58,017.65 | 0.551 | 6,877.078 | 34,385 | 18.544 |
| 120 | 500 | 500 | 5,000 | 45,958.22 | 45,958.22 | 2.768 | 6,038.081 | 30,190 | 21.113 | |
| 8 vCPUs | 64 GB | 120 | 500 | 100 | 5,000 | 92,893.5 | 92,893.5 | 0.344 | 10,584.47 | 52,922 | 12.051 |
| 120 | 500 | 500 | 5,000 | 90,279.03 | 90,279.03 | 0.354 | 10,650.45 | 53,252 | 11.976 | |
| 120 | 1,000 | 100 | 10,000 | 94,563.73 | 94,563.73 | 0.338 | 9,910.109 | 49,551 | 12.876 | |
| 120 | 1,000 | 500 | 10,000 | 86,176.2 | 86,176.2 | 0.371 | 9,334.534 | 46,673 | 13.665 | |
| 120 | 1,000 | 1,000 | 10,000 | 22,945.38 | 22,945.38 | 0.697 | 9,139.488 | 45,697 | 13.96 | |
| 16 vCPUs | 128 GB | 120 | 1,000 | 100 | 10,000 | 91,045.98 | 91,045.98 | 0.635 | 11,684.77 | 58,424 | 5.474 |
| 120 | 1,000 | 500 | 10,000 | 90,318.33 | 90,318.33 | 0.643 | 11,591.92 | 57,960 | 5.516 | |
| 120 | 1,000 | 1,000 | 10,000 | 89,622.71 | 89,622.71 | 0.649 | 11,519.55 | 57,598 | 5.553 |
Last Article: PostgreSQL 11 Test Data
Next Article: PostgreSQL 12 Test Data
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.