Percona Server vs PostgreSQL comparison

Read 125 PostgreSQL reviews

10,676 Views
8,893 Comparison Views

96% willing to recommend

Percona Server

Comparison Buyer's Guide

Download the report

Executive Summary

We performed a comparison between Percona Server and PostgreSQL based on real PeerSpot user reviews.

Find out in this report how the two Open Source Databases solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.

To learn more, read our detailed Percona Server vs. PostgreSQL Report (Updated: October 2024).

Percona Server vs. PostgreSQL

October 2024

Download the complete report

Helped 816,406 peers since 2012

Categories and Ranking

Percona Server

Ranking in Open Source Databases

12th

Average Rating

7.6

Reviews Sentiment

7.9

Number of Reviews

Ranking in other categories

No ranking in other categories

PostgreSQL

Ranking in Open Source Databases

2nd

Average Rating

8.4

Reviews Sentiment

7.9

Number of Reviews

125

Ranking in other categories

Vector Databases (9th)

Mindshare comparison

As of November 2024, in the Open Source Databases category, the mindshare of Percona Server is 2.7%, down from 4.4% compared to the previous year. The mindshare of PostgreSQL is 25.6%, up from 23.6% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Open Source Databases

Featured Reviews

Umair Hassan

Database Administrator at Systems Limited

Open-source and free to use with a good community

I would love to see the flashback in Percona MySQL or even in Percona PostgreSQL. It's available in Oracle, the flashback. In Oracle, there's the utility of a flashback. It stores all the information in the tables for a few days. That way, if I accidentally delete my records from the table or I need to check the value of a column or row two days back, I can. If Percona had flashback capabilities, it would be ideal. I would love to see training be easier to find. I had some complications finding the training that Percona provides. It is not displayed on the website. For example, if I want to train myself via a Percona expert through virtual files or through recorded videos or something like that, it's really difficult to find any sort of course. You have to email them first, and they will ask you whether it is for yourself or it is for the corporate sector. The course content should just be readily available and not hidden.

Read full review

AdityaSharma3

Vice President Business at Techmagnate: Digital Marketing Agency

Transaction processes are fast and good replication capability

Use cases include querying data warehouses and databases to fetch data for clients already working on PostgreSQL. We also use Postgres for building reports It's a transactional database, so we use Postgres for most of our reporting. That's where it's helping. The query speed is fast, and the…

Read full review

Quotes from Members

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

Pros

"We find the product mostly stable."

"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."

"PostgreSQL is very powerful, easy to manage, and has many features."

"We use the solution to store tables. It is stable and performs well."

"Initial setup is simple."

"It's a useful solution, that can be widely used."

"We are able to create many different types of jobs and items with this solution making it one of the most valuable features."

"One of the most valuable features is real-time data capture; it optimizes database performance. I think using real-time data capture reduces job running time and the amount of data sent at once with batch loads."

"The solution provides complete support in terms of the SQL dialect and behaves nicely when it comes to transactions."

Cons

"If Percona had flashback capabilities, it would be ideal."

"The solution could improve the integration."

"The scalability is limited."

"When you get a large number of records in a database and start doing various queries, it can adversely impact the performance of the live running systems. That's an area we continue to look at and mean to improve, but it is not only because of PostgreSQL. It is also because of the way the schemas are put together, and certain events are triggered. So, it is because of both parties."

"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."

"We often find the solution's datetime datatype challenging."

"I don't think PostgreSQL supports bulk databases, so it needs to have more capabilities in terms of managing the bulk data."

"As PostgreSQL is an open-source product, you do have to do a bit more configuration and management yourself."

"The interface climate could be better."

Pricing and Cost Advice

Information not available

"The solution requires a license."

"Affordable solution."

"Our company pays for it. There are free versions available, but for advanced features, you obviously have to pay."

"It is free. In terms of operating costs, it basically needs the same platform on which Oracle runs."

"PostgreSQL is a free and open-source database."

"It could be much cheaper. If you would like to build an application on Amazon today, PostgreSQL is the standard database with Redshift. If you want other databases, you can add them, but PostgreSQL is the basis of everything. It's a question of money, that's it."

"The tool is cheaply priced compared to other RDBMS providers in the market."

"There is an annual license."

Top Industries

By visitors reading reviews

Computer Software Company

31%

Financial Services Firm

10%

Educational Organization

Comms Service Provider

Computer Software Company

16%

Financial Services Firm

12%

Manufacturing Company

Comms Service Provider

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

No data available

Questions from the Community

What do you like most about Percona Server?

We find the product mostly stable.

What is your experience regarding pricing and costs for Percona Server?

This is an open-source product and is free to use.

What needs improvement with Percona Server?

How does Firebird SQL compare with PostgreSQL?

PostgreSQL was designed in a way that provides you with not only a high degree of flexibility but also offers you a cheap and easy-to-use solution. It gives you the ability to redesign and audit yo...

What do you like most about PostgreSQL?

It's a transactional database, so we use Postgres for most of our reporting. That's where it's helping.

What is your experience regarding pricing and costs for PostgreSQL?

The tool is free of cost. For now, it's not about making money. But once we perfect it, we can offer it to customers willing to pay for support and other services. Most of my deployments are free.

MariaDB vs Percona Server

Comparisons

MySQL vs Percona Server

Compared 35% of the time

Compared 34% of the time

EDB Postgres Advanced Server vs Percona Server

Compared 14% of the time

More Percona Server Competitors

Firebird SQL vs PostgreSQL

Compared 38% of the time

MySQL vs PostgreSQL

Compared 16% of the time

EDB Postgres Advanced Server vs PostgreSQL

Compared 14% of the time

MariaDB vs PostgreSQL

Compared 8% of the time

Weaviate vs PostgreSQL

Compared 1% of the time

Product Reports

Download Percona Server product report

Open Source Databases

October 2024

Download PostgreSQL product report

November 2024

Learn More

Video not available

Percona

Video not available

Overview

Percona Server for MySQL is a free, fully compatible, enhanced, open source drop-in replacement for MySQL that provides good performance, scalability and instrumentation. With over 3,000,000 downloads, Percona Server for MySQL's self-tuning algorithms and support for extremely high-performance hardware delivers excellent performance and reliability.

PostgreSQL is a versatile and reliable database management system commonly used for web development, data analysis, and building scalable databases.

It offers advanced features like indexing, replication, and transaction management. Users appreciate its flexibility, performance, and ability to handle large amounts of data efficiently. Its robustness, scalability, and support for complex queries make it highly valuable.

Additionally, PostgreSQL's extensibility, flexibility, community support, and frequent updates contribute to its ongoing improvement and stability.

Sample Customers

Pricefalls Marketplace, Micpoint, Rent the Runway, Transmart, Wattpad, Singular Group, Invoca, 3E

1. Apple 2. Cisco 3. Fujitsu 4. Instagram 5. Netflix 6. Red Hat 7. Sony 8. Uber 9. Cisco Systems 10. Skype 11. LinkedIn 12. Etsy 13. Yelp 14. Reddit 15. Dropbox 16. Slack 17. Twitch 18. WhatsApp 19. Snapchat 20. Shazam 21. SoundCloud 22. The New York Times 23. Cisco WebEx 24. Atlassian 25. Cisco Meraki 26. Heroku 27. GitLab 28. Zalando 29. OpenTable 30. Trello 31. Square Enix 32. Bloomberg