Shulou(Shulou.com)06/02 Report--

This article will explain in detail what are the five advantages of using PostgreSQL. The content of the article is of high quality, so the editor will share it with you for reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

Despite Instagram's recent negative growth and rebuttal, I just saw a compliment on PostgreSQL on Instagram Engineering: "Handling Growth with Postgres: 5 Tips From Instagram."

The strength and contribution of Facebook in the field of MySQL is among the best, but there is always a reason why Instagram continues to use PostgreSQL after it is bought by Facebook. Although the real reason is not necessarily technology, the content of this article that tries to explain with technology can still take a look at what are the characteristics of PostgreSQL.

The first one is to talk about partial indexes, which is different from the partial index that MySQL community often talks about.

The partial index of MySQL refers to only a part of the index field, such as the 10 chars; in front of the index in VARCHAR (255), while the partial indexes of PostgreSQL refers to the index only if the row meets certain conditions.

The second is functional indexes, which can be calculated and then index. MySQL's partial index can be used in PostgreSQL with functional indexes + substr () to achieve the same effect, and there are other function available, more tricks.

MySQL can't do it (or can't do it well), but PostgreSQL can't do it well. Generally speaking, in order to achieve this function of PostgreSQL in MySQL, you need to open another field, store the de-normalized value in it, and then index this field.

The third is about defrag, this part of MySQL can also be done with a third-party tool Percona Toolkit.

The fourth Write-Ahead Log that talks about PostgreSQL is a bit like the binlog of MySQL.

The last one is about psycopg2 on Python.

It seems that the index piece is the most obvious. You can directly reduce the number of de-normalized fields

About what are the five advantages of using PostgreSQL to share here, I hope that the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

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.