PostgreSQL Review

HStore is a data type that gives the flexibility to store key/value pair.


Valuable Features

HStore is a data type in PostgreSQL database that gives the flexibility for storing sets of key/value pairs which is quite an awesome feature.

Room for Improvement

Slow count. As the number of rows exceed a couple million, the count query and queries which get to the depth of the data (like FTS) start taking too much time even with all the right indexes in place.

Use of Solution

I've used it for two and a half years.

Deployment Issues

We use RDS Multi - AZ deployment which takes care of it all for us.

Stability Issues

We've had no stability issues.

Scalability Issues

There have been no issues with scalability.

Customer Service and Technical Support

I've never had an issue with the product, and therefore never had to reach out.

Previous Solutions

We tried RethinkDB a couple of years back, and it was unstable at that time. Also, MySQL didn't have a JSON type back then. We switched to PostgreSQL and never looked back.

Initial Setup

I do remember facing problems with the initial setup, but the overall documentation and SO answers has increased since then. New users face much less problem now. But there is still scope for improvement here.

Other Advice

I'd recommend reading Greg Smith's PostgreSQL High Performance.

Disclosure: IT Central Station contacted the reviewer to collect the review and to validate authenticity. The reviewer was referred by the vendor, but the review is not subject to editing or approval by the vendor.
Add a Comment
Guest

Sign Up with Email