EDB Postgres Advanced Server Review

Effectively allowing us to be far more flexible from architecture to production

What is our primary use case?

As a replacement for Oracle RAC where there's need:

  • More than four servers
  • Dynamically deployable servers
  • Split access between the transnational and reporting on the same data store.

How has it helped my organization?

  • Major reduction in run cost, and a quantum leap in the flexibility of deployment models
  • Elimination of replication of transaction from reporting systems
  • Able to do rolling upgrades with zero production downtime.

What is most valuable?

  • Variant server configuration: not requiring the same release on all.
  • Effectively allowing us to be far more flexible from architecture to production, and the overall support model improves drastically.

What needs improvement?

  • Lighter integration model for containerized deployment.

Effectively, there still remain some issues with a containerized deployment, so we have opted for a non-containerized deployment. This makes pack distribution a little more time-consuming.

For how long have I used the solution?

More than five years.

What do I think about the stability of the solution?

This is an extremely robust, enterprise-grade solution that inherits all of the same reliability aspects of Ingress.

What do I think about the scalability of the solution?

This is a very scalable environment both linear, horizontally and vertically.

How are customer service and technical support?

We are one of the largest corporations in the world so our exectation and support given was extremely high. Would this be so with smaller company's I am not sure.

Which solution did I use previously and why did I switch?

Oracle RAC and Informix. The single reason for moving off Oracle was the hard limit of four servers in a RAC and the degradation of performance at that. Meaning Oracle really is not scalable across servers, but requires massive increase in individual server specs.

Oracle and Informix are more costly deployments and support models, from a pure licensing perspective.

How was the initial setup?

This was a straightforward one-to-one activity, and both Oracle and Informix database were fully able to be completely comfortable within a day.

What about the implementation team?

In-house team with advice from the vendor.

What was our ROI?

Recovery of investment was less than four months.

What's my experience with pricing, setup cost, and licensing?

I believe this is a negotiation issue with any organization that is based on the size of footprint looked at. Hence our experience would not be applicable. But negotiate, negotiate, and negotiate.

Which other solutions did I evaluate?

Yes numerous options, include HANA, MongoDB, MySQL, and MS SQL. None of which were sufficiently scalable or at our size, cost effective.

What other advice do I have?

There will be a 10% pure play performance hit against ORacle and about 12% against Informix but the deployment and cost model more than compensate for the additional hardware requirements.
**Disclosure: I am a real user, and this review is based on my own experience and opinions.
Find out what your peers are saying about EnterpriseDB, PostgreSQL, MariaDB and others in Open Source Databases. Updated: March 2021.
475,291 professionals have used our research since 2012.
Add a Comment