PostgreSQL Review

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


What is most valuable?

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

How has it helped 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.

What needs improvement?

Replication is not yet as well implemented as in MySQL.

For how long have I used the solution?

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

What was my experience with deployment of the solution?

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

What do I think about the stability of the solution?

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

What do I think about the scalability of the solution?

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

How are customer service and technical support?

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

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

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

How was the initial setup?

Straightforward, easy and intuitive.

What about the 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.

What other advice do I have?

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.
More PostgreSQL reviews from users
Add a Comment
Guest