PostgreSQL vs MysSQL on OpenVZ VPS?

Question

linux

It is known for certain that running mysql on openvz is not the best solution due to the peculiarities of how openvz works with shared memory.
How is it with PostgreSQL?
Will the efficiency be higher if you change the database, taking into account that the resource that the database serves is the zabbix server?

Answer 1

not the best solution due to the way openvz works with shared memory.

And what are the features then?
And the efficiency will be higher than the solution that is tuned. I think that a simple change of base will not drastically increase the efficiency. Nevertheless, postgres is more convenient for development, and the profits from it are felt more strongly there.

Answer 2

I perfectly drive the muscle on openvz, it works no worse than just on the dedicator. Zabbisk is also running on muscle and both are on openvz.
Postgres is good if you have hundreds of servers and tens of thousands of tracked items.

Answer 3

It is silly to choose a database for VPS, it is right to do the opposite. And for Zabbix, I recommend Postgres.