PostgreSQL Review

You can call from SQL and dig deep into the query planner with its excellent Explain functionality.


What is most valuable?

PostGres is a fantastic modern RDBMS and its open nature allows you to get as low level as you need. You can define functionality, you can call from SQL and dig deep into the query planner with it's excellent explain functionality. The true open community is loaded with helpful people who believe in OSS. Every feature in PG is first, present, but secondly mature and just works. You may have bugs in your code but PGSQL will never be the cause of it.

How has it helped my organization?

It drives our enterprise architecture we are building.

What needs improvement?

The only thing that could potentially be improved is PGAdmin3, the DB Client that's has not been updated in quite a while. PostGres keeps ahead of the curve on it's feature set. For instance the new JSON column that's come out recently to provide nosql functionality that has been benchmarked to outperform mongo.

What was my experience with deployment of the solution?

We had no deployment issues.

What do I think about the stability of the solution?

The product is quite stable, and provides awesome performance.

What do I think about the scalability of the solution?

There's been no issues with scaling it for our needs.

How are customer service and technical support?

It has a great support community.

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

I started with this product.

How was the initial setup?

It's very straightforward initial configuration if you start with your distro packeges.

What about the implementation team?

It's very easy, and you only need to familiarize yourself with its file structure. Sometimes you need to write your own plugin, so sometimes it is better to have it implemented by a vendor.

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

It's free as it's open source.

What other advice do I have?

It's go good reliability and is very compliant with standards. If you are installing relational DB you likely know how to use one. If you're not familiar with RDBMS's make sure you look into and use the features of the DB like views etc. They all serve a purpose and will improve your development if leveraged properly.Huge feature set.

**Disclosure: I am a real user, and this review is based on my own experience and opinions.
More PostgreSQL reviews from users
Add a Comment
Guest