PostgreSQL Review

It is, in our experience, the best open source GIS enabled database, with good support from other open-source tools.


Valuable Features

The most valuable features are a good feature set, understandable, and good tuning features. It is, also in our experience, the best open source GIS enabled database, with good support from other open-source tools.

The product has easy installation procedures for the OSes we are working with and gives also a good possibility to tune the database for the given usage.

Improvements to My Organization

The database is used to set-up customers projects and is our standard database which we use.

Room for Improvement

One of the features it needs is a tighter integration with business intelligence software, so that the optimisation of the requests can be handled natively in the database. These features are on the roadmap, and are already partially released in the latest version.

Use of Solution

We have been using this database for about 18 years.

Deployment Issues

We have had no issues with the implementation. Most of the issues we have encountered in external installation where due to misconfiguration.

Stability Issues

There have been no issues with the stability. Most of the issues we have encountered in external installation where due to misconfiguration.

Scalability Issues

We had no issues scaling it for our needs. Most of the issues we have encountered in external installation where due to misconfiguration.

Customer Service and Technical Support

We have up until now not needed additional customer or technical support, these can be purchased by supporting companies.

Previous Solutions

We have been using Oracle software, and in some cases MS SQL server. The price difference between the used products and PostgreSQL was one of the issues. The second was the ease of installation and the availability on different platforms.

Initial Setup

The initial setup is easy to perform, but the tuning is a bit more complex. The installation support on Linux flavours is excellent and has native installation packages.

Implementation Team

Implementation and installation was carried out in house.

Pricing, Setup Cost and Licensing

The pricing of the database is open-source and our investment in the product is based on training.

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