PostgreSQL Review

All our company data is stored in it with a BI solution on top, but it lacks the ability to do distributed queries across multiple installations out of the box.


Valuable Features

It supports full text search, and windows functions.

Improvements to My Organization

All our data is stored in PostgreSQL, and we use a BI solution on top to gather all the important metrics to our business, so the whole company has a clear picture of what is going on.

Room for Improvement

It lacks the ability to distribute queries across multiple installations out of the box.

Use of Solution

I've used it for seven years.

Deployment Issues

No issues encountered.

Stability Issues

I've never experienced any data loss.

Scalability Issues

No issues encountered, even when querying through third-party applications.

Customer Service and Technical Support

Customer Service:

I've never had to deal with customer service.

Technical Support:

The support in the community is excellent, the documentation is great, and questions submitted to the mailing list are quickly answered. The IRC support is also excellent.

Previous Solutions

I used MySQL, but I needed support for full text search. PostgreSQL adds this, and also many more advanced SQL functions.

Initial Setup

Setup was very easy on all platforms that I use - Linux, Mac OSX, and Windows. It is a simple walk-through installation.

Implementation Team

It was done in-house.

ROI

It's a free solution, and we use it as a data store, it's all return.

Pricing, Setup Cost and Licensing

PostgreSQL is free software. The only cost of setup was a few developer hours, and with it being stable, we don't have any day-to-day costs.

Other Solutions Considered

  • MySQL
  • Microsoft SQL Server

Other Advice

PostgreSQL is one of the most stable data sources out there, and it offers you the most advance and modern functions on SQL so you can do more with less.

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