This project researches the differences between OpenGauss and PostgreSql-14.11 in efficiency and safety. It proposes some criteria and key metrics for evaluating the quality of databases and places emphasis on performance in complex data-intensive scenarios. It also gives test code for measuring differences between OpenGauss and PostgreSql-14.11 on these metrics. We executing these code on the elastic cloud server(ECS) and gained some conclusions about the features of OpenGauss. You can recurrence it as directed by OpenGauss installation and deployment guide and report in this project.
Here are some of our test results. You can see OpenGauss almost always performs worse than PostgreSql-14.11 in both simple and complex data-intensive scenarios, even in growth ratio this conclusion is true. OpenGauss only has advantages in query with index in extremely complex data-intensive scenarios.
- Efficiency comparison in insert operations:
 |
 |
|---|
- Efficiency comparison in select operations:
 |
 |
|---|
- Efficiency comparison in update operations:
 |
 |
|---|
- Efficiency comparison in delete operations:
 |
 |
|---|
- Efficiency comparison in join operations:
 |
 |
|---|
- Efficiency comparison in index operations:
 |
 |
|---|
