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.
"The solution has been very easy to scale so far."
"The solution is a small application and is very easy to deploy."
"The solution is easy to use."
"The most valuable features are that it's free and the documentation is good."
"The most valuable feature of MySQL is auto-scaling."
"When comparing MySQL to other solutions it is easier to use and boots up faster. Additionally, when you want to query a lot of data, MySQL is better in performance."
"It creates a unified view of the entire architecture and performance factor, helping to manage the network more easily."
"This is a lightweight product that is not demanding on the resources, which is what I think gives it the edge."
"The solution is scalable, it is very good."
"We are able to create many different types of jobs and items with this solution making it one of the most valuable features."
"Scalable, stable, and easy to manage database system, with a straightforward installation."
"What I like is that it's quite powerful in terms of performance."
"I like that you can move any relational database from Oracle to PostgreSQL. I also like that it's pretty stable."
"It is easy to use."
"It's a transactional database, so we use Postgres for most of our reporting. That's where it's helping."
"The tool is user-friendly."
"The integration with other systems can be improved as can the integration between other databases."
"Its performance should be better. When we use big data, it is slow in performance. We should be able to use mirroring for improved performance."
"The performance, stability, and security are areas with shortcomings in MySQL, where improvements are required."
"Scalability could be improved."
"It could be a little bit simpler to use."
"I feel that some tools which make it easier to create queries or make it easier for other functions would be really interesting to see."
"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."
"It could be more secure."
"It would be great if the solution offered even more integration capabilities."
"I'm not really able to customize it."
"It needs more integration."
"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."
"It is possible that in the newer version this has been addressed, but I would like the deployment in microservices architecture could be improved."
"I'd like to see better memory management. I think that that's one of the few areas that Postgres does not handle as well as MySQL does or did."
"The interface could be much better."
"The solution could improve the integration."
MySQL is ranked 1st in Open Source Databases with 142 reviews while PostgreSQL is ranked 2nd in Open Source Databases with 123 reviews. MySQL is rated 8.2, while PostgreSQL is rated 8.4. 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 " Real-time data capture optimizes database performance but Views create problems". MySQL is most compared with Firebird SQL, MariaDB, Teradata, SAP HANA and SQL Server, whereas PostgreSQL is most compared with Firebird SQL, EDB Postgres Advanced Server, MariaDB, Chroma 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.