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."We find the product mostly stable."
"Initial setup is simple."
"It's a transactional database, so we use Postgres for most of our reporting. That's where it's helping."
"The product is very similar to the SQL Server."
"It is very useful for both structured and unstructured data. You can store unstructured and structured data in PostgreSQL. It is easy to use. You can easily manage things through PostgreSQL Admin. It is cost-effective. Its on-premise version is free. It is agnostic of on-premise or cloud. You can install it on the cloud or on-premises. It is available with all clouds, and you can also install it on desktop or Windows Servers."
"The product is quite flexible."
"It's a standard reliable database management system."
"Postgres is rock solid when deployed according to best practices as documented by the PostgreSQL community. When it's installed correctly, PostgreSQL is an enterprise-grade solution."
"PostgreSQL is very powerful, easy to manage, and has many features."
"If Percona had flashback capabilities, it would be ideal."
"PostgreSQL is a stable system, but from a security point of view, it still needs improvement."
"The pricing could be better."
"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."
"PostgreSQL could improve by providing a geographical solution for tracking trucks and people in the field. They might already have features similar to this and I have not found them. I haven't done research about this topic."
"Sometimes, the views create problems. If you don't have the view, sometimes what happens is you need to have the drivers properly set up for PostgreSQL."
"They need to have a better graphical interface. There is a tool called pgAdmin 4 that they use, which is free. It is written in Java, and it is slow. They need to have a better product that is similar to Toad for Oracle, but, of course, it is hard to get something that's really great and free. Other than that, it is great."
"It would be good to have machine learning functionality in this solution, similar to Microsoft SQL Server and other solutions. Machine learning capability for a basic level or a common user would be useful. It can also have good reporting capabilities."
"The user interface could be a bit better."
Percona Server is ranked 8th in Open Source Databases with 2 reviews while PostgreSQL is ranked 2nd in Open Source Databases with 123 reviews. Percona Server is rated 7.6, while PostgreSQL is rated 8.4. The top reviewer of Percona Server writes "Open-source and free to use with a good community". On the other hand, the top reviewer of PostgreSQL writes " Real-time data capture optimizes database performance but Views create problems". Percona Server is most compared with MariaDB, MySQL, EDB Postgres Advanced Server and Oracle MySQL Cloud Service, whereas PostgreSQL is most compared with Firebird SQL, EDB Postgres Advanced Server, MySQL, MariaDB and Weaviate. See our Percona Server 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.