Compare MySQL vs. PostgreSQL

Cancel
You must select at least 2 products to compare!
MySQL Logo
Read 38 MySQL reviews.
10,133 views|8,228 comparisons
PostgreSQL Logo
4,248 views|3,505 comparisons
Most Helpful Review
Find out what your peers are saying about MySQL vs. PostgreSQL and other solutions. Updated: May 2021.
511,307 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:

Pros
"The solution is very simple. It's easy to use. That's the most important feature.""The solution is free to use, which is its most valuable aspect.""The initial setup was pretty straightforward. I would have worked with our IT team in terms of the initial setup.""Apart from the features that are in the enterprise part, we find the database to be valuable. The connectors and the backup features are valuable as well. We use the basic database. We don't really use the extra features. Our clients like the security features in the database.""MySQL is open-source. There are a lot of open-source communities trying to come up with their own patches, and to come up with their own features, which help MySQL develop faster than traditional databases like Oracle, which is closed source.""This specific version of this MySQL has been battle tested for a long time. Any issues are known issues and we pretty much don't have any problems when they're in production. So it's very stable.""This product is a good teaching tool for students who want to learn about networked databases.""This is a lightweight product that is not demanding on the resources, which is what I think gives it the edge."

More MySQL Pros »

"The most valuable features are the price, stability, it is scalable and is used by our clients in small business environments, and it is a simple product to use.""It is easy to install and easy to manage. There is no license on it, so it is free. There is high compatibility with Oracle, and there are many tools for the migration of data from Oracle to Postgre.""The database has excellent performance.""Clustering will be the number 1 feature. It is also open-source so it is free. It can also be clustered, to allow fault tolerance.""With the database, you can provide a multi-component at the same service with the same performance, scalability, or all those things.""The product is quite flexible.""What I like is that it's quite powerful in terms of performance.""The built-in code procedural language is the most valuable. It has a built-in layer for code procedures. Its installation is very easy and quick, and it is free. It is also stable, and its performance is also good."

More PostgreSQL Pros »

Cons
"The replication needs improvement. It's becoming a native cloud product like Oracle DB or Cockroach DB.""From a user perspective, the initial setup could be simplified a bit.""I find the Microsoft solution a bit better. But mostly in terms of the UI layout, I would say. I just find it a little bit more efficient.""Oracle should start putting in some of the enterprise features in the standard feature. There are some key features that should be part of the standard.""They should come up with a better solution than the NDB cluster for better scaling. If they could come up with a better solution for write scaling, apart from the NDB cluster, which is supported by all open source communities, that would be great. Although the NDB cluster, I believe, is an open-source tool, it's not widely supported as a solution.""In terms of what I'd like to see in the next release, one thing that's always missing is dash boarding. There's no real BI tool for MySQL, like there is in Yellowfin and all the different tools that you get. They all have MySQL connectors, but there's no specific BI tool for MySQL. These open source projects have sprung up, but they're more general purpose.""The documentation is pretty weak and should be improved.""The product is a little bit complex and it is difficult to find sufficient documentation."

More MySQL Cons »

"The user interface for the clients could be easier to use as they are small businesses. From a technical support perspective, the documentation could be improved.""It still needs to be more mature and have some backup feature. We are normally dealing with Oracle's data, and we have very strong online tools to back up the data and do other things. PostgreSQL still needs to do more in this area as well as in the high availability area. There are many external tools that you can use for PostgreSQL's high availability, but there is no embedded tool within PostgreSQL for high availability. It could have a feature similar to Oracle for working on a distributed system. It can have some scripts to improve the monitoring and some tools to do performance analysis. We have a workaround for most of such requirements except for the support for a distributed system, which is very difficult to have. This area should be included in the core of the database itself.""The user interface could be a bit better.""It could be improved by using parallelization. You want basically, distributed computing.""The database and applications can become very slow.""The pricing could be better.""I had some issues when I integrated with the Jupyter Notebook.""PostgreSQL doesn't have a feature for temporal SQL, which is useful for gathering versions of data. This feature should be included in PostgreSQL. This feature is available in MariaDB, SQL Server, Oracle Database, and DB2."

More PostgreSQL Cons »

Pricing and Cost Advice
"I am using the Community Edition, which is available free of charge.""This is an open-source product that can be used free of charge.""It's an open-source database management system that can be used free of charge.""Microsoft licensing for SQL Server is probably ten times more expensive. I used to work for the government, and I remember when we were looking into upgrading to the enterprise version of SQL Server 2019, the licensing was going to cost 350,000. To get the equivalent in the cloud, it was going to be about four grand to get the same processing power and everything else. With MySQL, it was going to be about 300 for the same licensing. Cost-wise, for sure, there is a huge difference. Would you prefer to pay 300 a month or 3,000 to have the same amount of data resources? You might lose a few options that you need, but it isn't worth the price difference.""This product has a good price point.""There is a licensing cost because we are going for a proprietary product. There are some other versions for which there is no licensing cost.""It has a community version.""It is open-source."

More MySQL Pricing and Cost Advice »

"Affordable solution.""It is free. There is no license on it.""It is also open-source so it is free.""PostgreSQL is a free and open-source database.""It is free, but if you need support, you can go for the commercial version called EnterpriseDB. They provide paid support, and they can even do hosting for you if you want standby and support.""PostgreSQL is open-source, so if capable admins are available then the setup cost can be $0.""It is open-source. If you use it on-premise, it is free. It also has enterprise or commercial versions. If you go for the cloud version, there will be a cost, but it is lower than Oracle or Microsoft.""The solution requires a license."

More PostgreSQL Pricing and Cost Advice »

report
Use our free recommendation engine to learn which Open Source Databases solutions are best for your needs.
511,307 professionals have used our research since 2012.
Questions from the Community
Top Answer: A good traditional database that supports JSON.
Top Answer: There is a license for this solution. A lot of the time the solution gets bundled with other hardware or software purchases.
Top Answer: I'd like to see some additional JSON query support in the solution.
Top Answer: It's a standard reliable database management system.
Top Answer: The solution doesn't cost anything to use. It's open-source.
Top Answer: The interface could be much better. Maybe it took a little bit longer to understand the menu options and so on. On top of that, it's a web interface. It makes it uninteresting to look at. It's not so… more »
Ranking
1st
Views
10,133
Comparisons
8,228
Reviews
35
Average Words per Review
576
Rating
7.8
3rd
Views
4,248
Comparisons
3,505
Reviews
16
Average Words per Review
475
Rating
8.0
Popular Comparisons
Learn More
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
Computer Software Company18%
University12%
Comms Service Provider8%
Non Tech Company6%
VISITORS READING REVIEWS
Comms Service Provider30%
Computer Software Company24%
Financial Services Firm6%
Educational Organization6%
REVIEWERS
Comms Service Provider16%
Financial Services Firm14%
Computer Software Company12%
University9%
VISITORS READING REVIEWS
Comms Service Provider34%
Computer Software Company20%
Financial Services Firm11%
Manufacturing Company4%
Company Size
REVIEWERS
Small Business47%
Midsize Enterprise17%
Large Enterprise36%
REVIEWERS
Small Business45%
Midsize Enterprise23%
Large Enterprise32%
Find out what your peers are saying about MySQL vs. PostgreSQL and other solutions. Updated: May 2021.
511,307 professionals have used our research since 2012.

MySQL is ranked 1st in Open Source Databases with 38 reviews while PostgreSQL is ranked 3rd in Open Source Databases with 17 reviews. MySQL is rated 7.8, while PostgreSQL is rated 8.0. The top reviewer of MySQL writes "Good beginner base but it should have better support for backups". On the other hand, the top reviewer of PostgreSQL writes "Can be clustered which allows for fault tolerance". MySQL is most compared with Firebird SQL, Oracle Database, SAP HANA and IBM Db2 Database, whereas PostgreSQL is most compared with Firebird SQL, MariaDB, EDB Postgres Advanced Server, Percona Server and SQLite. See our MySQL vs. PostgreSQL report.

See our list of best Open Source Databases vendors.

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.