EDB Postgres Advanced Server Reviews

The backup utility tools such as pg_restore and pg_dump are really convenient and efficient tools to handle backup and recovery.

We have deployed the database to support our tax management system. 

It suffers issues ranging from data corruption to failing to delete temporary files which then necessitate us having to perform server restarts.

We have had no issues with the deployment.

The database has had stability issues.

The database has been able to support about three million taxpayers.

It's very easy and straightforward to deploy.

I would encourage any organization to adopt the solution as long as they are ready to invest in training and research. Supporting a PostgreSQL database requires highly skilled personnel.

Our primary use case for EDB Postgres Advanced Server was to study the code base behind it. We aimed to understand how it has been built, how the engine functions, the querying process, and what kinds of indices are available. This was part of our college projects where we explored its architecture and capabilities.

The number of indices available in Postgres is remarkable. Additionally, the way it forks each process into a child node, instead of executing in the same node, is quite different from most databases. These features can be especially useful in certain scenarios compared to MySQL or other SQL-based databases. Also, the ability to distribute the database across different machines is a significant advantage.

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 wish to add.

I have had experience with this product for the past year.

Postgres and MySQL are known for their stability and reliability, which is essential for a product server.

Although I do not have detailed insight into MySQL's scalability, I can affirm that Postgres scales effectively and performs exceptionally well among SQL databases.

Postgres has excellent documentation, which is very comprehensive and includes diagrammatic representations and visual aids. This makes learning and understanding the system much easier.

Positive

Setting up MySQL is slightly more straightforward than Postgres. I would rate the Postgres setup experience as seven and a half out of ten, compared to MySQL's setup, which I rate at nine out of ten.

I would highly recommend EDB Postgres Advanced Server to others. Most companies prefer Postgres or MySQL for a reason. The number of available options and the ability to distribute the database across different machines enhances its flexibility and features. 

I rate Postgres a nine out of ten overall.