PostgreSQL Reviews

The spatial extension, PostGIS, is amazing and probably the gold standard. I also like the Key-Value column type and the JSON column type. Apart from this, it has all the other features you will need in an RDBMS and then some. It has a vibrant FOSS community with a great license and it has plenty of books and documentation

Rather than using Desktop GIS software we were able to carry out a lot of our spatial operations faster with larger datasets by moving the operations into PostgreSQL. We also save a ton of money on Oracle licenses. Finally, rather than having to give up my relational features, I can use the JSON data type and get everything I want.

They need to work towards making it work better in a cloud environment. Also, I would love to see them developm multi-master replication.

We have had no issues with the deployment.

There have been no performance issues.

It's been able to scale for our needs.

Get a good book so you can get exposed to all the great functionality in PostgreSQL. I would highly recommend looking at the postgresql.conf configuration settings when you are ready to go into production.

6 years

Authentication config could be made easier.

It's very stable.

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.

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

The multi-master replication feature needs improvement.

I've used it for eight years now.

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

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

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

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

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

The initial setup is very straightforward.

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

It's reliability is key.

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

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

I've been using it for six years.

We had no issues with the deployment.

I've had no stability issues.

It scaled for our needs.

8/10

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

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

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

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

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.

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.

Great Documentation, active community support, excellent management & development tools and availability on various platforms makes PostgreSQL a good data base management system.