PostgreSQL Review

Has robust backup and recovery integration, but should consider including the possibility to use query routers on sharded clusters


What is our primary use case?

We use PostgreSQL for most part of our mission critical applications.

The solution has a very robust backup and recovery integration, and has good ANSI SQL language.

How has it helped my organization?

We are considering migrating to this platform due to its robust backup and recovery solution, among many other features.

What is most valuable?

  • Robust backup and recovery integration.
  • Follows ANSI SQL.
  • opensource
  • easy to integrate with applications and high level programming languages such as; python, ruby, java, C, perl, php...

What needs improvement?

  • Possibility to use query routers on sharded clusters.
  • Remove the limitations of how many changes one can have on the databases before it requires to reset all blocks, which are very painful.

For how long have I used the solution?

More than five years.

What do I think about the stability of the solution?

No issues.

What do I think about the scalability of the solution?

Yes, as the database grows, one has to perform a full vacuum in order to continue to work on the database.

Another issue is that the "archive_command"s are executed in sequence, instead of in parallel, and as the WAL size is fixed to 16MB, and it is not possible to change in a configuration file, this will have a huge impact of protecting the WAL logs to a backup system.

How is customer service and technical support?

Customer Service:

10 out of 10.

Technical Support:

10 out of 10.

Which solutions did we use previously?

We switch to this solution due to its stability and that it is open source.

How was the initial setup?

The initial setup is simple.

What about the implementation team?

We implemented it in-house.

What was our ROI?

The software is free, and very easy to find for skilled people.

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

Use backup software that integrates with the solution.

We selected "DB Protection for PostgreSQL", which has some nice features to perform block level incremental forever using IBM Spectrum Protect.

Which other solutions did I evaluate?

Yes, we reviewed MongoDB, MariaDB, and MySQL.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
Add a Comment
Guest
Sign Up with Email