簡(jiǎn)而言之：
- 簡(jiǎn)單應(yīng)用用MySQL入宦，傳說中更快。
- 復(fù)雜應(yīng)用使用PostgreSQL图贸，支持SubQuery蹂季、View冕广、Stored Procedure，復(fù)雜的查詢更快偿洁。
比較方法：
https://www.google.com.hk/
關(guān)鍵字：mysql vs postgresql benchmark 2016
別人的結(jié)論：
PostgreSQL [9.5.0] vs MariaDB [10.1.11] vs MySQL [5.7.0] year 2016
http://nghenglim.github.io/PostgreSQL-9.5.0-vs-MariaDB-10.1.11-vs-MySQL-5.7.0-year-2016/?time=1
Conclusion
MariabDB & MySQL has slight advantages at database writing
PostgreSQL has slight advantages at simple database read query
PostgreSQL has big advantages at complex database read query
As a result, I think that choosing PostgreSQL is a better options for RDBMS - provided that PostgreSQL comes with more features and following standard SQL.
Written on February 12, 2016
Compare incomparable: PostgreSQL vs Mysql vs Mongodb
http://erthalion.info/2015/12/29/json-benchmarks/
Why I Choose PostgreSQL Over MySQL/MariaDB
http://insights.dice.com/2015/03/19/why-i-choose-postgresql-over-mysqlmariadb/
PostgreSQL Vs MySQL And MySQL Vs Postgresql Performance 2016
https://www.bestwebsitesblogs.com/postgresql-vs-mysql-and-mysql-vs-postgresql-performance-2016/
Performance difference between MySQL and PostgreSQL for the same schema/queries
http://dba.stackexchange.com/questions/41232/performance-difference-between-mysql-and-postgresql-for-the-same-schema-queries
