We compared PostgreSQL and EDB Postgres Advanced Server based on our user's reviews in several parameters.
In summary, PostgreSQL is praised for its extensive range of features, excellent customer service, and overall valuable investment for businesses. On the other hand, EDB Postgres Advanced Server is highly regarded for its robust performance, scalability, and integration capabilities. Areas for improvement in PostgreSQL include enhancing performance and documentation, while EDB Postgres Advanced Server could benefit from improved performance optimization and user interface.
Features: PostgreSQL is appreciated for its robustness, stability, scalability, reliability, and versatility. It has excellent performance, advanced SQL functionality, extensive community support, wide selection of extensions, compatibility with various systems and languages. EDB Postgres Advanced Server is valued for its robust performance, scalability, seamless integration, advanced tools, flexibility, and compatibility.
Pricing and ROI: PostgreSQL offers flexible pricing options, manageable setup costs, and fair licensing terms based on user feedback. On the other hand, EDB Postgres Advanced Server is praised for its affordable and straightforward setup cost, along with flexible licensing options that satisfy users., EDB Postgres Advanced Server users reported highly favorable ROI, highlighting significant value and benefits. No explicit mention of evaluation or critique.
Room for Improvement: PostgreSQL could benefit from improvements in performance, installation and configuration processes, documentation, and user interface. EDB Postgres Advanced Server users desire enhancements in performance, documentation, troubleshooting, and user interface to provide a more efficient and intuitive experience.
Deployment and customer support: In comparing the reviews between PostgreSQL and EDB Postgres Advanced Server, users reported varying durations for deployment and setup. Some users of PostgreSQL took three months for deployment, while others took a week. EDB Postgres Advanced Server also had users who took three months for deployment, but some users only required a week. Additionally, users of both products mentioned spending an additional week on setup. However, the context in which these terms are used should be carefully evaluated. In cases where both deployment and setup took a week, it can be assumed that they refer to the same period and should not be considered separately., PostgreSQL's customer service is known for its responsiveness and helpfulness, delivering excellent support experiences. Meanwhile, the customer service of EDB Postgres Advanced Server is praised for its excellence, providing commendable assistance and ensuring customer satisfaction through prompt and effective solutions.
The summary above is based on 12 interviews we conducted recently with PostgreSQL and EDB Postgres Advanced Server users. To access the review's full transcripts, download our report.
"I rate EDB Postgres Advanced Server's stability an eight out of ten."
"The low cost and functionality allows us to save money on smaller database projects."
"I like that EDB Postgres Advanced Server scales well. A valuable feature of the solution is multi-tenancy support. It also supports JSONB."
"It gives us a solid, less expensive alternative to deploying with Oracle."
"The product is quite flexible."
"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 solution is quite stable."
"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."
"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."
"The most valuable feature is the performance."
"It is a pretty comprehensive database system. Its performance is good, and it does what it is supposed to do. It also integrates very well."
"PostgreSQL has complete SQL dialects and is useful for writing sophisticated and complex queries. We have experience with Oracle database. My partner is experienced in DDA and he writes sophisticated SQL queries. The solution helps to get the job done in the best possible way. In today’s age, most developers do not have strong SQL knowledge or language command. They find it difficult to write even a SQL statement. These developers write cool queries which perform badly on the database end. As DBAs, we constantly urge the developers not to write bad queries, help them learn more, and write placebo commands."
"The security is not very robust and the product would be much more useful with more security options."
"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 system is aging and not keeping up with the performance of new, enhanced database models."
"Instead of the installation agent downloading all the packages for the install, it should allow the user to download the packages separately on their own to do the install."
"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 for the clients could be easier to use as they are small businesses. From a technical support perspective, the documentation could be improved."
"The interface could be much better."
"The search option is not very good."
"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."
"The interface climate could be better."
"It could be more secure."
EDB Postgres Advanced Server is ranked 6th in Open Source Databases with 6 reviews while PostgreSQL is ranked 2nd in Open Source Databases with 120 reviews. EDB Postgres Advanced Server is rated 8.0, while PostgreSQL is rated 8.6. The top reviewer of EDB Postgres Advanced Server writes "Scales well; works in both development and production environments and has multi-tenancy and JSONB support". On the other hand, the top reviewer of PostgreSQL writes " A scalable and stable database for transactional purposes". EDB Postgres Advanced Server is most compared with Percona Server, MySQL, YugabyteDB and MariaDB, whereas PostgreSQL is most compared with Firebird SQL, MySQL, MariaDB, SQLite and YugabyteDB. See our EDB Postgres Advanced 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.