When might MariaDB be preferred over PostgreSQL?

Question

MySQL

It is clear that PostgreSQL is more powerful. But are there cases where MariaDB is the preferred option?

Yes, I saw a couple of old articles on habr about switching from PG to MariaDB, but from your experience, how?

What can I get and in what cases?

Let's say now my whole PG tuning comes down to disabling various features and logging in order to increase the speed. In my case, the speed of insertion / selection is more important to me than the guarantee of data integrity.

I heard that MariaDB has different engines. Here in PG there is a built-in multiversion, but as I understand it, it only complicates everything and is not always needed.

In what cases can MariaDB win?

Answer 1

When might MariaDB be preferred over PostgreSQL?

If those who develop the application and maintain the database know this software better than postgres.
At the stage "speed is more important to me than data consistency/integrity", there will almost certainly not be much difference between a normally configured muscle and a normally configured postgres.