PostgreSQL Review

It is a tool without cost, powerful, easy to learn and with a large active community.​​


Valuable Features

Common Table Expressions(CTEs). It's powerfull, easy to write and read and very flexible.

Improvements to My Organization

JSONB (Binary JSON storage), because I can have both relational and non-relation data storage at the same time with this data type. In addition, by using Generalized Inverted Indexes (GIN) it supports fast lookups and simple expression search queries.

Room for Improvement

Replication is not yet as well implemented as in MySQL.

Use of Solution

I've been using it for one year and five months

Deployment Issues

There are some issues around different OS, but not a big problem.

Stability Issues

There are some issues around different OS, but not a big problem.

Scalability Issues

There are some issues around different OS, but not a big problem.

Customer Service and Technical Support

The documentation could be written better, but there is a huge community committed to help.

Previous Solutions

I used MySQL, but for safety and consistency issues, I moved to PostgreSQL

Initial Setup

Straightforward, easy and intuitive.

Implementation Team

In a vendor team, we develop products for different segments stores. In the implementation, keep in mind the configurations and platforms that are available, it certainly will save time and avoid potential problems.

Other Advice

Currently this is one of the best solutions on the market. It is a tool without cost, powerful, easy to learn and with a large active community.

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