PostgreSQL Review

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


Valuable Features

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

Improvements to My Organization

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

Room for Improvement

Parallel processing of queries.

Use of Solution

I've used it for 12 years.

Deployment Issues

There's been no issues deploying it.

Stability Issues

The product always worked as described.

Scalability Issues

We've had no issues scaling it.

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.

Previous Solutions

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.

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.

Implementation Team

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

Pricing, Setup Cost and Licensing

PostgreSQL is free and open source.

Other Advice

Read the documentation.

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