For me, PostgreSQL is in the right direction, presenting a wide range of options and a solid, stable and integrity proven operation even in heavy loads.
i'm not sure but i think postgreSQL is more secure and also support complex database design. And this is most similar to oracle. it handles large amount of data with secure and reliable and etc...
Integrity is the Raison d'être of a relational database, if you need raw speed you're better off with a NoSQL solution.
PostgreSQL has more functionality (CTE, window functions, indexes that can use functions, ...), is generally more SQL-standard compliant (e.g. having to select all the columns involved in a GROUP BY is actually a good thing, none of that indeterministic results of MySQL), and data integrity by default. I'd also dispute the "MySQL is considerably faster than PostgreSQL" (more so if your application can benefits from indexes that use functions) and "MySQL allows for simpler database design". The choice of license may also matter, depending on your environment.
PostgreSQL is not only better but is also free, as in freedom.
Data integrity!!!
More advanced
it is used even in the case of complexity
For equivalent workloads Postgresql is faster on complex schemas. That and its transactional support for full text search and schema changes make it a better choice for all kinds of deployments.
BTW, the last sentence of the second paragraph seems to have a clause inverted and hence states the opposite of its intent.
Finally, I don't think these versions are the latest for MySQL or Postgresql.
More features.
suitable for complex enterprise database
more mature
