PostgreSQL Review

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

What is most valuable?

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

How has it helped my organization?

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

What needs improvement?

Parallel processing of queries.

For how long have I used the solution?

I've used it for 12 years.

What was my experience with deployment of the solution?

There's been no issues deploying it.

What do I think about the stability of the solution?

The product always worked as described.

What do I think about the scalability of the solution?

We've had no issues scaling it.

How are 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.

Which solution did I use previously and why did I switch?

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.

How was the 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.

What about the implementation team?

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

What's my experience with pricing, setup cost, and licensing?

PostgreSQL is free and open source.

What other advice do I have?

Read the documentation.

Which version of this solution are you currently using?

8.0 to 9.5
**Disclosure: I am a real user, and this review is based on my own experience and opinions.
More PostgreSQL reviews from users
...who work at a Comms Service Provider
...at Small Businesses
...who compared it with MySQL
Free Report: PostgreSQL Reviews and More
Learn what your peers think about PostgreSQL. Get advice and tips from experienced pros sharing their opinions. Updated: February 2021.
Download now
464,369 professionals have used our research since 2012.
Add a Comment
Guest
Author
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.
See more »
Product Categories
Open Source Databases
Buyer's Guide
Download our free PostgreSQL Report and get advice and tips from experienced pros sharing their opinions.
Download Now
Quick Links
Learn More: