We compared PostgreSQL and MySQL based on our user's reviews in several parameters.
PostgreSQL is known for its robustness, scalability, and efficiency, with excellent customer service. However, it requires improvements in performance optimization and installation processes. On the other hand, MySQL is valued for its data management efficiency and security measures, with outstanding customer support. Areas for enhancement include query execution speed and documentation.
Features: PostgreSQL users appreciate its robustness, scalability, advanced SQL functionality, extensive community support, and compatibility with multiple operating systems. Meanwhile, MySQL shines with its efficient data handling, flexibility, ease of use, and strong security measures.
Pricing and ROI: PostgreSQL offers a manageable setup cost and fair licensing terms, catering to various budgets. On the other hand, MySQL is praised for its affordable setup cost and flexible licensing options, making it a reasonable choice for users., PostgreSQL offers excellent scalability, security features, and integration with other systems, delivering reliable results. MySQL is praised for its reliability, cost-effectiveness, ease of use, and ability to handle large databases.
Room for Improvement: PostgreSQL has room for improvement in enhancing overall performance, addressing difficulties during installation and configuration, improving documentation, and enhancing the user interface. On the other hand, MySQL needs enhancement in performance, documentation, support channels, scalability, compatibility, and security features.
Deployment and customer support: Users of PostgreSQL reported that the deployment and setup of a new tech solution took either 3 months for deployment and an additional week for setup or 1 week for both phases. On the other hand, users of MySQL reported longer deployment durations, ranging from several months to 1 week for both deployment and setup., PostgreSQL's customer service and support have been praised for their responsiveness, helpfulness, and effectiveness. Users appreciate the prompt and knowledgeable assistance provided by the team. In comparison, MySQL's customer service and support are highly praised. Users appreciate the prompt and helpful assistance they receive when facing any issues or inquiries. The support team is described as knowledgeable and reliable.
The summary above is based on 35 interviews we conducted recently with PostgreSQL and MySQL users. To access the review's full transcripts, download our report.
"A lot of the software components have been trialed and tested for often more than 10 years."
"Setup is easy. MySQL of various flavours has community editions to easily test, deploy, and run."
"What I've been most pleased with is the cost point, performance, and ease of use."
"The one interesting thing about this product is that it is open source. It comes from an open source product. MySQL has been positioned as open source, but it also provides support."
"For starters, it's free, which is always nice, and it's also pretty straightforward to use. It's a nice conventional database."
"We use the basic features of MySQL. The interface that allows us to see the parameters of the server is good."
"This is a lightweight product that is not demanding on the resources, which is what I think gives it the edge."
"It's a mature solution that's been around for decades."
"We often use PostgreSQL for operations monitoring because we are a manufacturing company."
"The product is quite flexible."
"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."
"The product is very similar to the SQL Server."
"PostgreSQL makes it very adaptable to several descriptions of a record. Instead of having several tables or several relations for one entity, I can adapt this entity. It can be a multiform entity. For example, here in Mexico, a company and a person can be sold to us as a physical entity or a physical person."
"It has completely met our needs. It works, and it is robust. We haven't had any problems with what PostgreSQL does for us and the way it does it. That's why we've been using it for so long. We understand it, and it does the job."
"The solution is open-source and free to use."
"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."
"MySQL could introduce more indexing strategies."
"MySQL doesn't have the auto-clustering and database clustering features that other competitors provide. They can include these features."
"The analytics features are in need of improvement."
"MySQL's performance needs to be improved for enterprise-level applications compared to Oracle and Postgres."
"It should have some code analytical functions. It can also have a monitoring tool."
"Since we upgraded from 8.0.12 to 8.0.22, it has had some slowness-related issues. Some of the queries that were fast previously are quite slow now. I did some research, and I found many people complaining about it."
"While utilizing a comparable algorithm, is noted to be sensitive, especially when configuring the inner device."
"The technical support should be more knowledgeable and available worldwide."
"The search option is not very good."
"It could be improved by using parallelization. You want basically, distributed computing."
"PostgreSQL is a stable system, but from a security point of view, it still needs improvement."
"We have to set up event API, which takes a lot of events from the user."
"We often find the solution's datetime datatype challenging."
"The user interface could be a bit better."
"The database and applications can become very slow."
"It could be more secure."
MySQL is ranked 1st in Open Source Databases with 142 reviews while PostgreSQL is ranked 2nd in Open Source Databases with 120 reviews. MySQL is rated 8.2, while PostgreSQL is rated 8.6. 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 " A scalable and stable database for transactional purposes". MySQL is most compared with Firebird SQL, MariaDB, Teradata, SQL Server and Oracle Database, whereas PostgreSQL is most compared with Firebird SQL, EDB Postgres Advanced Server, MariaDB, SQLite and YugabyteDB. 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.