Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Compare mysql with postgresql and oracle in terms of partition function

2025-03-29 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

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

Now I go to IOE with great fanfare. I feel a little embarrassed to say hello to people just talking about oracle. As a person who loves oracle, I am not disgusted with mysql and PG. People like me are the most single-minded: whoever gives money to whom, the wind blows, runs whichever way the wind blows. One day, I will become a pig in the tuyere, invested in the embrace of the hunter ^ _ ^, hehe, nonsense.

If there is no comparison, there is no harm, so I always do not compare with tuhao. But as an alternative to de-IOE, mysql and PG, this has to be compared. Here I only compare partition functions.

Before I am not sure how good the oracle partition is, anyway, it is getting richer and richer, and it is enough to use it. For example, we have a table that has reached 6 billion records, so we have to divide it into good areas and use a good index. I do not feel any pressure on the query, the need for sub-database and sub-table. For some people who cannot support the introduction of mysql sub-database partition with a large amount of data, I have deep doubts: is it really impossible to support it? Are all like Ali, do they have such a large volume of business?

One thing I can't accept when using mysql partitions is that the partitioning field must exist in the primary key or unique index, so I can't keep it unique in the partitioned scenario at the same time! Since there is no concept of global partitioning, it is estimated that this pain point cannot be realized.

On the other hand, the partition of PG makes me a little more open-minded, adopting the way of table inheritance + trigger, in a sense, it gives me a train of thought or possibility to implement inside the partition. Maybe we can make a more customized partition scheme along this way of thinking, but brother PG has a "no hand" attitude towards this kind of partition, which is too troublesome. If implemented as a built-in function, it will be more convenient for users. It is said that the built-in partition is under development.

So my feeling is that, after all, it is free, and it is not in vain for other commercial companies to invest so many developers. As far as zoning is concerned, the gap between mysql and PG is still very obvious.

Of course, on the other hand, is this not an opportunity? If the partition can be as easy to use as oracle, can the price of oracle be so high?

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.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report