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.
"It gives us a solid, less expensive alternative to deploying with Oracle."
"I like that EDB Postgres Advanced Server scales well. A valuable feature of the solution is multi-tenancy support. It also supports JSONB."
"The low cost and functionality allows us to save money on smaller database projects."
"I rate EDB Postgres Advanced Server's stability an eight out of ten."
"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."
"The most valuable feature is the performance."
"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 easy to use."
"The product is easy to use and works fast for relational databases."
"PostgreSQL is very powerful, easy to manage, and has many features."
"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 PostgreSQL database is similar to the SQL Server but has a slightly different technology that has similar resources as well. If the customer has the confidence using SQL Server, they will be fairly comfortable using this solution."
"The system is aging and not keeping up with the performance of new, enhanced database models."
"I have faced performance issues in the community edition."
"The security is not very robust and the product would be much more useful with more security options."
"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."
"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."
"There are several features I would like to improve that aren't working as expected. It's likely that the latest version is doing something that was missed in the previous versions. For example, the output parameters — the stored procedures — is something new in PostgreSQL that Firebird has already had for a long time."
"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."
"It could be improved by using parallelization. You want basically, distributed computing."
"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."
"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."
"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 scalability is limited."
EDB Postgres Advanced Server is ranked 6th in Open Source Databases with 6 reviews while PostgreSQL is ranked 2nd in Open Source Databases with 123 reviews. EDB Postgres Advanced Server is rated 8.0, while PostgreSQL is rated 8.4. 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 " Real-time data capture optimizes database performance but Views create problems". 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 Chroma. 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.