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.
Staff System Admin at a tech company with 5,001-10,000 employees
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?
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.
Senior Production Support Engineer at a tech company with 501-1,000 employees
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.
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.
Developer at a tech company with 51-200 employees
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.
Buyer's Guide
Download our free PostgreSQL Report and get advice and tips from experienced pros
sharing their opinions.
Updated: May 2024
Popular Comparisons
MySQL
MariaDB
Firebird SQL
EDB Postgres Advanced Server
SQLite
Faiss
Percona Server
Chroma
YugabyteDB
OpenSearch
LanceDB
Oracle MySQL Cloud Service
Weaviate
Buyer's Guide
Download our free PostgreSQL Report and get advice and tips from experienced pros
sharing their opinions.
Quick Links
Learn More: Questions:
- What is the best GUI tool for development and management of a PostgreSQL database?
- How does Firebird SQL compare with PostgreSQL?
- When evaluating Open Source Databases, what aspect do you think is the most important to look for?
- Did you switch from a different solution to MySQL? Can you list a few pros and cons for making the move?
- Which database is the best for session cashing?
- Which low-code (no-code) database solution do you prefer?
- Why is Open Source Databases important for companies?
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