Shulou(Shulou.com)05/31 Report--

This article mainly introduces "what's the difference between postgresql and Mysql". In daily operation, I believe many people have doubts about the difference between postgresql and Mysql. The editor consulted all kinds of materials and sorted out simple and easy-to-use methods of operation. I hope it will be helpful to answer the questions of "what's the difference between postgresql and Mysql?" Next, please follow the editor to study!

Mysql's multi-table join query only supports "Nest Loop", not "hash join" and "sort merge join". And mysql does not support many illegal, low subquery performance, while does not support sequence;postgresql to support the vast majority of with statements, the rule is the strongest, built-in functions are rich, field types support arrays, PL/PGSQL, PL/Python

There are problems in the operation of mysql, which only produces very little performance data, so it is difficult to locate the problem. Moreover, mysql replication is asynchronous and zero data loss cannot be achieved through master/slave. Pg has a large number of performance views.

Mysql online operation function is weak: if a new column is created in mysql, it is basically a new table, and the whole table will be locked when the new index is created, that is, during the indexing process, the table cannot have any operations. The general solution is to operate slave first, then switch master to slave, and finally operate master.

Postgresql is suitable for data warehouse, supports complex sql, and supports a large number of analysis functions.

At this point, the study on "what's the difference between postgresql and Mysql" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.