Open Source Databases » PostgreSQL Reviews » Version 8.0 to 9.5 » Review

PostgreSQL Review

Large open-source extensions, modules and software helpers eco-system.

What is most valuable?

Flexible stored procedures and external functions
WITH clauses
Partitioning
Large open-source extensions, modules and software helpers eco-system

How has it helped my organization?

The documentation is very well written and detailed, it helps to implement the right features for your needs in a timely manner.

What needs improvement?

Parallel processing of queries.

For how long have I used the solution?

I've used it for 12 years.

What was my experience with deployment of the solution?

There's been no issues deploying it.

What do I think about the stability of the solution?

The product always worked as described.

What do I think about the scalability of the solution?

We've had no issues scaling it.

How are customer service and technical support?

There is no tech support, however there is a lot of information available in forums or sites like serverfault.com.

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

I used MySQL. PostgreSQL syntax is much clearer and consistent, and its stored procedures are powerful and fast. The documentation is also much better and of more help.

How was the initial setup?

On Debian, the provided packages are very easy to install and provide automatic updates. On Mac OS X, EnterpriseDB provides packages that work very well but as not as well integrated than in Debian.

What about the implementation team?

I implemented in-house. PostgreSQL databases needs some maintenance but that can be easily automated by a skilled administrator.

What's my experience with pricing, setup cost, and licensing?

PostgreSQL is free and open source.

What other advice do I have?

Read the documentation.

**Disclosure: I am a real user, and this review is based on my own experience and opinions.

Last updated: Apr 28 2016