PostgreSQL Review

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


Valuable Features

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.

Improvements to My Organization

It drives our enterprise architecture we are building.

Room for 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.

Deployment Issues

We had no deployment issues.

Stability Issues

The product is quite stable, and provides awesome performance.

Scalability Issues

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

Customer Service and Technical Support

It has a great support community.

Previous Solutions

I started with this product.

Initial Setup

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

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.

Pricing, Setup Cost and Licensing

It's free as it's open source.

Other Advice

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.
Add a Comment
Guest

Sign Up with Email