PostgreSQL Review

Simple installation and it does not consume a lot of resources.


Valuable Features:

  • It's open source product not need to license, so economic
  • It provides a graphical interface (pgAdmin) simple, intuitive and efficient
  • Simple installation 
  • It does not consume a lot of resources
  • Really suitable for business n-tier solutions
  • Rich documentation
  • An interactive community

Improvements to My Organization:

The strength of this product is set in the timeliness of SELECT queries with lots of joins. compared with other DBMS, it is really optimized for joins.

Room for Improvement:

I think that due to the lack of functionality for data warehousing, it is more suitable for operational information systems instead of BI systems. Besides, it only allows Relational Online Analytical Processing (ROLAP) not Multidimensional Online Analytical Processing (MOLAP).

Deployment Issues:

There have been no issues with the deployment.

Stability Issues:

We have had no issues with the stability.

Scalability Issues:

It's been able to scale for our needs.

Other Advice:

Because we use it in many information systems (Financial, Human Resources, Inventory Management) in several large companies with significant data flow, we have not had problems. It was effective as a product.

Read the product documentation well and know the configuration parameters because just one incorrect parameter can affect the entire database.

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