- 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).
There have been no issues with the deployment.
We have had no issues with the stability.
It's been able to scale for our needs.
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.