PostgreSQL Review

Basically, you are mixing together the relational and NoSQL world in just one database, one powerful solution. ​


What is most valuable?

The new JSON data type that allows to use some NoSQL-like functionality.

This is great because brings some of the most valuable features of NoSQL databases to relational databases. You can have a column with JSON datatype and then query that JSON inside your regular SQL queries. 

So basically, you are mixing together the relational and NoSQL world in just one database, one powerful solution. 

How has it helped my organization?

We use it as main database for our SaaS product.

What needs improvement?

Scalability;

Although PostgreSQL is known for handling very well large amounts of workload, NoSQL databases performs better when scaling. NoSQL databases were built with scalability in mind, so it´s a natural advantage. 

PostgreSQL must keep improving their scalability and ability to work in HA (high availability).

For how long have I used the solution?

I've used this solution for four years. 

What do I think about the stability of the solution?

No. 

What do I think about the scalability of the solution?

See answer to 'Room for Improvement' question. 

Which solutions did we use previously?

We had several performance issues with MySQL.

Which other solutions did I evaluate?

Yes, MySQL.

What other advice do I have?

Explore all the features.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
1 visitor found this review helpful
1 Comment
Charlita DalebjörkReal User

Good review.
Plus that archive_command should have been built for handling multiple commands simultaneously to improve WAL processing

17 February 18
Guest
Sign Up with Email