A kind of mastodon, very old and competent DBMS. It is almost like MySQL, but better. But you need to be able to cook and configure. According to many people, a very stable DBMS, it is almost impossible to drop it, destroy tables like in MySQL. And this can be a decisive factor for you when choosing.
PostgreSQL for you, if:
- - you are a conservative (I understand, but I am) and you need a reliable storage;
- - you or your specialist know how to configure and use PostgreSQL;
- - you need well structured data, but with some flexibility in the data schema (JSON/BJSON);
- - with the help of third-party libraries, it's easy and convenient to expand into clusters and shard tables. And all this really works.
And the disadvantages are not much to describe ... To be fair, I have not had much practice, mainly judging by the stories of friends:
- - the need for experience working with this DBMS to prepare it well. Otherwise it is better to take MySQL or read it further;
- - the default authorization system can be difficult database performance to use or configure, not everyone likes it, some even very experienced developers still do not https://www.sqlsplus.com fully understand how it works there.