it_user434967 - PeerSpot reviewer
Staff System Admin at a tech company with 5,001-10,000 employees
Real User
​From our use of it, its stability and performance are the best features. The fact that there's no downtime and that it functions quickly are very important to our workflow and business.

What is most valuable?

From our use of it, its stability and performance are the best features. The fact that there's no downtime and that it functions quickly are very important to our workflow and business.

How has it helped my organization?

We're in the evaluation period at my current company, so we haven't really seen improvement to our functioning.

What needs improvement?

The multi-master replication feature needs improvement.

For how long have I used the solution?

I've used it for eight years now.

Buyer's Guide
PostgreSQL
May 2024
Learn what your peers think about PostgreSQL. Get advice and tips from experienced pros sharing their opinions. Updated: May 2024.
771,157 professionals have used our research since 2012.

What was my experience with deployment of the solution?

We've had issues with deployment, but I can't share the details.

What do I think about the stability of the solution?

We've had issues with stability, but I can't share the details.

What do I think about the scalability of the solution?

We've had issues with scalability, but I can't share the details.

How are customer service and support?

We are running the open source version and haven't purchased technical support.

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

Yes, we evaluated other solutions, and we are moving away from PostgreSQL after the evaluation period.

How was the initial setup?

The initial setup is very straightforward.

What about the implementation team?

The implementation was done with our in-house team. My advice is to get training.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
PeerSpot user
Senior Production Support Engineer at a tech company with 501-1,000 employees
Consultant
It allows us to deploy test functionality on a very simple normal computer and not on a server.

What is most valuable?

It's reliability is key.

How has it helped my organization?

It allows us to deploy test functionality on a very simple normal computer and not on a server.

What needs improvement?

I'd like to have NoSQL available in this version. It is available in the latest one.

For how long have I used the solution?

I've been using it for six years.

What was my experience with deployment of the solution?

We had no issues with the deployment.

What do I think about the stability of the solution?

I've had no stability issues.

What do I think about the scalability of the solution?

It scaled for our needs.

How are customer service and technical support?

8/10

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

I switched as I needed to increase the volume of data.

How was the initial setup?

It was a bit complex to setup, although I think this was due to ignorance on the project.

What about the implementation team?

We did it in-house, but only to test different databases.

What other advice do I have?

Use it, to change the default database, it's a good option.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
PostgreSQL
May 2024
Learn what your peers think about PostgreSQL. Get advice and tips from experienced pros sharing their opinions. Updated: May 2024.
771,157 professionals have used our research since 2012.
it_user1077 - PeerSpot reviewer
Developer at a tech company with 51-200 employees
Vendor
PostgreSQL is one of the best Open Source, Object-Relational Data Base Management System available in the market with great features

Valuable Features:

1) Supports large part of SQL standards like Complex queries, stored procedures.2) As source code is free and open, it can be easily distributed, modified and extended according to user requirements.3) PostgreSQL also proves to be a cost-effective solution for organization's as this product is designed and created to have much lower maintenance without compromising on features.4) Excellent GUI tools available for PostgreSQL like pgAdmin III.

Room for Improvement:

1) It tends to be slower when processing a large number of records.2) Does not support the entire ANSI SQL 92' standard.3) More open source applications (software stacks) supports MySQL, but some of them may not support PostgreSQL4) Comparatively small user community than MySQL 5) Installation and setup is bit complex and requires technical know how. Though PostgreSQL is comparatively slower than MySQL, but can handle a heavier workload, and also supports various SQL features like foreign keys, triggers, stored procedures and transaction rollback.

Other Advice:

Great Documentation, active community support, excellent management & development tools and availability on various platforms makes PostgreSQL a good data base management system.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user6579 - PeerSpot reviewer
it_user6579Engineer at a tech services company with 1,001-5,000 employees
Consultant

Nice review by Engineer359. Yes PostgreSQL is one of the best Open Source RDBMS available in the market which doesn't need any license cost. Agree with author on pros and cons mentioned by him for the PostgreSQL. Even i would like to add some points based on my experience.
1) Complete support for sub queries
2) Great GUI tool PG Admin
3) Support Views
4) Extensible
5) Great Documentation available on internet

See all 2 comments