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.

Which version of this solution are you currently using?

9.4.7
**Disclosure: I am a real user, and this review is based on my own experience and opinions.
More PostgreSQL reviews from users
...who work at a Comms Service Provider
...who compared it with MySQL
Learn what your peers think about PostgreSQL. Get advice and tips from experienced pros sharing their opinions. Updated: May 2021.
510,882 professionals have used our research since 2012.
Add a Comment
ITCS user
Guest