The h-stores are very powerful for handling collections of key-value pairs. The query syntax and functions are well documented and easy to use.
PostgreSQL Review
The query syntax and functions are well documented and easy to use.
What is most valuable?
How has it helped my organization?
PostgreSQL is a powerful and open source database, which is central all data processing.
What needs improvement?
We'd like to be able to start using JSON objects for easy code representation. This feature is available in v10.4.
For how long have I used the solution?
I've been using it for eight years.
What was my experience with deployment of the solution?
We've had no issues with the deployment.
What do I think about the stability of the solution?
There have been no stability issues.
What do I think about the scalability of the solution?
It's been able to scale for our needs.
How are customer service and technical support?
I use online documentation, which met my needs.
Which solution did I use previously and why did I switch?
We were using version 8 before, and also an earlier Oracle instance. We chose the product because it is powerful, well documented, and open source.
How was the initial setup?
I did not set up the actual installation. I did set up the schema, tables, foreign keys, etc. That was straightforward in that it was well documented.
What about the implementation team?
In house. You do need someone that knows PostgreSQL or that can spend time learning about the product.
What was our ROI?
It's open source. ROI is a matter of time.
What other advice do I have?
The challenge with this product would be finding the IT resource that can implement the product.
Which version of this solution are you currently using?
9.4
**Disclosure: I am a real user, and this review is based on my own experience and opinions.
Last updated: Apr 27 2016
More PostgreSQL reviews from users
Learn what your peers think about PostgreSQL. Get advice and tips from experienced pros sharing their opinions. Updated: January 2021.
455,164 professionals have used our research since 2012.
Author
it_user246798
Director of Client Integration at a financial services firm with 51-200 employees
Vendor
Highlights
The most valuable features are the price, stability, it is scalable and is used by our clients in small business environments, and it is a simple product to use.
The database has excellent performance.
It is easy to install and easy to manage. There is no license on it, so it is free. There is high compatibility with Oracle, and there are many tools for the migration of data from Oracle to Postgre.
Clustering will be the number 1 feature. It is also open-source so it is free. It can also be clustered, to allow fault tolerance.
With the database, you can provide a multi-component at the same service with the same performance, scalability, or all those things.
The product is quite flexible.
What I like is that it's quite powerful in terms of performance.
Product Categories
Open Source DatabasesPopular Comparisons
Firebird SQL
EDB Postgres Advanced Server
MariaDB
Percona Server
MySQL
SQLite
Buyer's Guide
Download our free PostgreSQL Report and get advice and tips from experienced pros
sharing their opinions.
Quick Links