Compare MySQL vs. PostgreSQL

MySQL is ranked 1st in Open Source Databases with 14 reviews while PostgreSQL is ranked 3rd in Open Source Databases with 1 review. MySQL is rated 8.2, while PostgreSQL is rated 7.0. The top reviewer of MySQL writes "Offers a simple DBMS solution with a very low hardware footprint. Only one of the engines supports ACID transaction control". On the other hand, the top reviewer of PostgreSQL writes "Has robust backup and recovery integration, but should consider including the possibility to use query routers on sharded clusters". MySQL is most compared with CockroachDB, Firebird SQL and Oracle Database, whereas PostgreSQL is most compared with Firebird SQL, MariaDB and EDB Postgres Advanced Server.
Cancel
You must select at least 2 products to compare!
MySQL Logo
Read 14 MySQL reviews.
13,845 views|11,808 comparisons
PostgreSQL Logo
7,901 views|5,543 comparisons
Most Helpful Review
Find out what your peers are saying about EDB Postgres Advanced Server vs. MySQL and other solutions. Updated: September 2019.
366,239 professionals have used our research since 2012.
Quotes From Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Pricing and Cost Advice
Can range from free to quite expensive, depending on the environments and requirements, so better to really set goals ahead of setting it up.MySQL Enterprise Support is not cheap, though might still be cheaper than Oracle or SQL Server. They may not have local support depending on where you’re based, but there are many smaller agencies out there that will readily provide support. You’ll need to spend some time looking around.​Enterprise editions and support are definitely needed for the heavy users who need direct support. ​When you know the setup will continue to grow, make sure you have the paid support.

Read more »

Information Not Available
report
Use our free recommendation engine to learn which Open Source Databases solutions are best for your needs.
366,239 professionals have used our research since 2012.
Ranking
1st
Views
13,845
Comparisons
11,808
Reviews
12
Average Words per Review
409
Avg. Rating
8.2
3rd
Views
7,901
Comparisons
5,543
Reviews
1
Average Words per Review
373
Avg. Rating
7.0
Top Comparisons
Compared 13% of the time.
Compared 12% of the time.
Compared 11% of the time.
Compared 34% of the time.
Compared 22% of the time.
Learn
Oracle
PostgreSQL
Video Not Available
Overview

Until its recent acquisition by Oracle, MySQL was possibly the most renowned open source database enterprise package that could be accessed completely for free. With the merger, the server increased both its features and its price tag, but there is still a free version available to the general community to contribute ideas and suggestions.

MySQL is a fast and relatively inexpensive database management system. It can easily integrate with a wide variety of programming languages, and it is considered to be a very reliable option. One of the most prominent features that customers seem to enjoy is the easy scalability of this system.

PostgreSQL is a powerful and fully-featured database management system with which business owners can create object relational tables. It is an open source project that can be acquired for free and heavily focuses on elements such as extensibility and strict standard compliance. PostgreSQL is a flexible server system that can manage large workloads that are being contributed and accessed from a wide range of locations such as in a network, as well as small-scale projects like a single machine or user.

Some technical details of interest about PostgreSQL include:

  • Its MVCC (Multi-inversion concurrency control) allows fluid changes to be made to the system without cumbersome roadblocks, while maintaining the optimal level of ACID.
  • Replication, built-in binary replication is available from the 9.0 version and later.
  • It offers a wide range of indexing capabilities, including B-tree and hash indexes, as well as GIN and GiST (generalized inverted indexes and generalized search trees).
  • It uses procedural languages that make it easier for developers to expand the database.
Offer
Learn more about MySQL
Learn more about PostgreSQL
Sample Customers
Facebook, Tumblr, Scholastic, MTV Networks, Wikipedia, Verizon Wireless, Sage Group, Glassfish Open Message Queue, and RightNow Technologies.Hundreds of companies have used PostgreSQL, including the University of Alabama, Birmingham, Berkman Center for Internet & Society at Harvard University, Champion Products, the United Nations Industrial Development Organization, the U.S. Agency for Disease Control and Prevention, and IMDB.com.
Top Industries
REVIEWERS
University23%
Non Tech Company9%
Mining And Metals Company9%
Software R&D Company9%
VISITORS READING REVIEWS
Retailer17%
Software R&D Company12%
Manufacturing Company11%
University11%
REVIEWERS
Financial Services Firm22%
University15%
Transportation Company11%
Software R&D Company7%
We monitor all Open Source Databases reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.
Sign Up with Email