EDB Postgres Advanced Server vs PostgreSQL comparison

EDB Postgres Advanced Server

Read 125 PostgreSQL reviews

8,785 Views
7,651 Comparison Views

96% willing to recommend

Comparison Buyer's Guide

Download the report

Executive SummaryUpdated on Jan 12, 2025

PostgreSQL and EDB Postgres Advanced Server compete in the database solutions category. EDB Postgres Advanced Server often has the upper hand due to its advanced features and Oracle compatibility.

Features: PostgreSQL supports complex queries, indexing, JSON, and GIS data types, making it a versatile choice for open-source users. EDB Postgres Advanced Server includes these features and adds proprietary functions and enterprise-level support, appealing to enterprises needing comprehensive capabilities.

Room for Improvement: PostgreSQL could improve its clustering, user-friendliness, and JSON/NoSQL features. Better documentation and setup support would benefit new users. EDB Postgres Advanced Server could enhance its JSONB querying for better data handling and optimize performance for large-scale operations.

Ease of Deployment and Customer Service: PostgreSQL offers versatile deployment options with extensive community support, which may not suffice for those needing instant help. EDB Postgres Advanced Server provides structured support and adaptability across environments, ensuring smoother enterprise support experiences.

Pricing and ROI: PostgreSQL’s open-source model ensures zero licensing fees, minimizing initial costs and maximizing ROI through saved expenses. EDB Postgres Advanced Server has a structured pricing model with additional features and support, slightly increasing costs but offering competitive value for enhanced functionality and dedicated support.

To learn more, read our detailed EDB Postgres Advanced Server vs. PostgreSQL Report (Updated: March 2025).

EDB Postgres Advanced Server vs. PostgreSQL

Download the complete report

Helped 845,040 peers since 2012

Review summaries and opinions

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

Categories and Ranking

EDB Postgres Advanced Server

Ranking in Open Source Databases

8th

Average Rating

8.0

Reviews Sentiment

7.7

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

Number of Reviews

125

Ranking in other categories

Vector Databases (9th)

Mindshare comparison

As of April 2025, in the Open Source Databases category, the mindshare of EDB Postgres Advanced Server is 2.9%, down from 4.9% compared to the previous year. The mindshare of PostgreSQL is 18.2%, down from 21.1% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Open Source Databases

Featured Reviews

Munirathnakumar Si

Senior Principal Cyber Security Consultant - Cloud and Container at Standard Chartered Bank

Though user-friendly, it fails to offer a mobile application to users

The product currently fails to offer a mobile application. In the future, I want the solution to offer a mobile application, especially since you can access the services via mobile phone with all the service providers like AWS and others. A mobile application provided by the product can help a user to see the status whenever needed.

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

"The product is user-friendly."

"It gives us a solid, less expensive alternative to deploying with Oracle."

"The number of indices available in Postgres is remarkable."

"I like that EDB Postgres Advanced Server scales well. A valuable feature of the solution is multi-tenancy support. It also supports JSONB."

"The feature of vector database management for AI is quite interesting and impactful."

"I rate EDB Postgres Advanced Server's stability an eight out of ten."

"Postgres is highly compatible with many software and programming languages. Its compatibility is excellent, covering nearly everything related to data engineering or migration."

"The low cost and functionality allows us to save money on smaller database projects."

"It is easy to use."

"The solution is open-source and free to use."

"The main value is that it is open source, which means it is free. Our organization has the initiative to go to open source to cut down on cost. Oracle costs us $6 million a year right now, which is killing us, and Postgres costs nothing. So, there is a big push to go to Postgres."

"The product's deployment is easy."

"PostgreSQL is very easy to use. I have experience in Oracle SQL and PostgreSQL uses the same syntax which makes it is easy for me to develop."

"Postgres has some functions called JSONB aggregators or other aggregators, which are quite useful."

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

"It is very scalable and comes with a bonus: no licensing issues as you scale with your databases."

Cons

"There aren't specific new features we wish to add."

"The security is not very robust and the product would be much more useful with more security options."

"The system is aging and not keeping up with the performance of new, enhanced database models."

"I would like to see improvements in the performance, especially in large-scale operations, as it currently cannot match Oracle's performance."

"I have faced performance issues in the community edition."

"An area for improvement in EDB Postgres Advanced Server is JSONB querying. It would be nice to have even stronger JSONB support from the solution."

"The product currently fails to offer a mobile application."

"It would be great if the solution offered even more integration capabilities."

"There are some products out there that have a slightly different method of implementation for the SQL language. Some of those are slightly better in some areas, and PostgreSQL is slightly better in some areas. I would probably like to match all of those products together. It is just down to the functionality. For example, Oracle has a number of options within SQL that are outside of what you would class as the SQL standard. PostgreSQL misses some of those, but PostgreSQL does other things that are better than what Oracle does. I would like to merge those two products so that there is a certain amount of functionality in a single product."

"The user interface could be a bit better."

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

"I'm not really able to customize it."

"PostgreSQL is a stable system, but from a security point of view, it still needs improvement."

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

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

Pricing and Cost Advice

"I have been working on the community edition."

"EDB Postgres Advanced Server is open source, so I don't pay for licensing."

"The product is either free with community support or very inexpensive with a small yearly fee for paid support."

"Pricing is significantly lower than competing products."

"It is an open-source product."

"It is free. There is no license on it."

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

"The licensing model is good."

"It is open source. There is no licensing."

"The community version of Postgre is basically free."

"There is an annual license."

"We use the open-source version of PostgreSQL and not the enterprise edition."

"PostgreSQL is open-source, so if capable admins are available then the setup cost can be $0."

Top Industries

By visitors reading reviews

Financial Services Firm

16%

Computer Software Company

14%

Manufacturing Company

10%

Government

Computer Software Company

16%

Financial Services Firm

12%

Comms Service Provider

Manufacturing Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

Questions from the Community

What do you like most about EDB Postgres Advanced Server?

I rate EDB Postgres Advanced Server's stability an eight out of ten.

What is your experience regarding pricing and costs for EDB Postgres Advanced Server?

EDB Postgres Advanced Server offers both processor-based and user-based licensing options. The cost is reasonable, particularly for middle and lower-tier customers, but there are hiccups when deali...

What needs improvement with EDB Postgres Advanced Server?

It was challenging to think of improvements for Postgres. We did not choose to extend or add new features to Postgres since it already meets our needs so well. There aren't specific new features we...

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.

Percona Server vs EDB Postgres Advanced Server

Comparisons

Compared 7% of the time

YugabyteDB vs EDB Postgres Advanced Server

Compared 6% of the time

More EDB Postgres Advanced Server Competitors

Firebird SQL vs PostgreSQL

Compared 37% of the time

MySQL vs PostgreSQL

Compared 14% of the time

MariaDB vs PostgreSQL

Compared 8% of the time

Chroma vs PostgreSQL

Compared 7% of the time

LanceDB vs PostgreSQL

Compared 4% of the time

Product Reports

EDB Postgres Advanced Server

Download EDB Postgres Advanced Server product report

Download PostgreSQL product report

Overview

EDB Postgres Advanced Server is a powerful and reliable database management system designed for production workloads. It offers a range of advanced features, making it an ideal choice for businesses looking to scale their operations. With support for multi-tenancy, JSONB, and production features similar to Oracle, the solution is versatile and can meet the needs of a wide range of organizations.

Overall, EDB Postgres Advanced Server is a robust and flexible database management system that can help businesses achieve their goals and stay competitive in today's fast-paced digital landscape.

EnterpriseDB

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

Ericsson, Clear Capital, PinkRoccade, ABN Amro, WholeWorldBand, Van Genechten, Gallinat-Bank AG, Mariner, coresystems, Aquent, Contegix, AQA, Genscape, InMobi

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

EDB Postgres Advanced Server vs. PostgreSQL