PostgreSQL Review

Worked for years on Oracle, decided to move to PostgreSQL because it's a first class product. The partitioning is basic.

What is most valuable?

The SQL is very close to the standard, the richness of of procedural languages and the strong attitude to the data reliability.

How has it helped my organization?

The product is used to ensure the data delivery and the HA features are used to enforce a non stop service.

What needs improvement?

The partitioning, is still very basic and not touched for years.

For how long have I used the solution?

7 years

What was my experience with deployment of the solution?

More a lack of knowledge rather an issue. PostgreSQL implements the data management in a very peculiar way. Ignoring this can result in disasters. And often this does happens. A better explanation about the architecture will reduce the risk.

What do I think about the stability of the solution?

Not on the production side. I’ve seen a lot of bugs or misconceptions on the HA side. Same as question 7, It’s more a lack of information than an issue.

What do I think about the scalability of the solution?

The product scales pretty well.

How are customer service and technical support?

Customer Service: As this is an community managed system there’s no customer service. There are companies offering support, I never used as I don’t need it.Technical Support: Quite good. The mailing list are a good way to have quick response. What really lacks is a centralized knowledge base like the Oracle’s metalink/otn. That is what I’m really missing from the oracle universe.

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

I worked for years on Oracle. I decided to move on PostgreSQL because I think is a first class product.

How was the initial setup?

Using the packaged way is almost immediate to install the product. Even the compile from source is a task any system administrator or advanced linux user can do it without any problem.

What about the implementation team?

It’s an in house team.

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

Basically zero for both. The product is released under the BSD license and, apart from my salary, my employer have no extra costs on using PostgreSQL

Which other solutions did I evaluate?

I considered in the past MySQL and Firebird.

What other advice do I have?

Employ a DBA to work together with the developers.
**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
...who compared it with MySQL
Learn what your peers think about PostgreSQL. Get advice and tips from experienced pros sharing their opinions. Updated: July 2021.
521,637 professionals have used our research since 2012.
Add a Comment
ITCS user