MySQL PostgreSQL database big evaluation

zhaozj2021-02-08 520

sequence

With the growing Internet development and free software software, more and more people began to apply various databases in their own network applications. As a result, various database systems appear on the internet stage, the most commonly used databases here are mysql and postgreSQL, which has different applications and user groups in the Internet. Interestingly, like the controversy between FreeBSD and Linux inside the operating system field, there is a small argument between these two databases, and these debates have greatly affected the user's own Judgment, it also feels uncomfortable when the user will choose, in order to facilitate everyone to use their own eyes, we specially organize comparison information provided by all aspects, focusing, for everyone to use. At the same time, the materials we collected have some information about other databases, in order to provide you with more complete information as much as possible, we also included them. Here we mainly conduct features and performance comparisons, there are other important factors, such as copyright and active, etc., can be easier to get in our other resource parts, this is no longer repeated.

This article is made by the original and / or Chinese translator of the information. This article allows free reprinting of any non-commercial use, but please refer to the respective copyright statements of each author. If there is conflict, please contact the author contact. The data and results in the article are throughout the author's serious and strict professional test, but the author does not undertake any commitments and guarantees for any data and results.

version

V1.0.0RC1

That mount

Here is a comparison of the Matthias WARKUS written by Yan Zi brother.

Here is the evaluation from a Russian hacker.

Wang Po sells melon

Some of all aspects of their own evaluation and comparison are collected here.

This part of the content is the collection of netizens wangbin.

PostgreSQL test

Postgresql's own comparison test is relatively simple, mainly based on characteristic comparisons, but it is interesting to have no mysql's figure in this list. From PostgreSQL concept, mysql is not a complete database, probably because of current mysql There is still lack some key database features.

Here is a simple contrast of PostgreSQL yourself.

Mysql test

MySQL provides a database test kit and is the most abundant and detailed data in the materials we collected. In addition to providing comparison with PostgreSQL, it also provides comparison data with many other databases. The comparison of mysql is based primarily based on speed and performance, and there is a characteristic comparison between all of its participation platform, but lack of RDBMS-InterBase that is becoming free software (Interbase is open from 6.0, but I don't know if GPL) .

The following is the acquired information and test results on the MySQL site:

You can find the full source code of the test program from the MySQL source release version and some contrast data sheets.

The entry for _fast tags is to be tested using the cleaning command (Cleanup calls) in non-standard ANSI SQL mode. This is no longer a hundred percent SQL, but these data items are still very useful.

Some entries are sent to us by anonymous MySQL users, so they cannot guarantee that these test data are fully accurate, we recommend running this test program on your own database. If you are willing to share your test results with us, you can upload the files in the 'Output' directory to 'www.tcx.se/pub/mysql/incoming' so that we can be in the future test results. Publish these test data.

The following chart is a comparison of all reference databases in Crash-me.

All the charts below the Crash-me are compared to the POSTGRESQL and MySQL on the Linux platform.

POSTGRESQL and MYSQL comparison data table