PostgreSQL Pros and Cons

What do you like best about PostgreSQL?

Its Free and Open Source. It is pretty fast and scalable Database Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

A Bit Steep Learning Curve.

Documentation needs to be be better Review collected by and hosted on G2.com.

What do you like best about PostgreSQL?

The Scalability and ease of use make it perfect fit. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

As such there is nothing that I can put here. Review collected by and hosted on G2.com.

What do you like best about PostgreSQL?

Easy to set up and it works! I also like the completeness of documentation. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Nothing really. Everything works smoothly. Review collected by and hosted on G2.com.

What do you like best about PostgreSQL?

Scalable. maintainable database which is opensource - Best. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Evolving - Need additional features to match MS and ORacle Review collected by and hosted on G2.com.

What do you like best about PostgreSQL?

Open source, easy to use and high scalability Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Unstable and alacking of technical support. Review collected by and hosted on G2.com.

What do you like best about PostgreSQL?

I am a huge fan of the robust data types and procedural capabilities in PostgreSQL. I used MySQL for many years simply because the setup process seemed easier than what PostgreSQL required. When PostgreSQL announced support for the JSON data type, I decided to bite the bullet and give PostgreSQL a more serious look. I've not touched MySQL since then.

In the years since JSON support landed in PostgreSQL, I've learned to appreciate the various options for implementing your own functionality using plpgsql and python. I've also experimented with various Foreign Data Wrappers (FDW) to expose data from other sources (filesystem, mysql, redis, other PostgreSQL instances, etc) as tables in PostgreSQL. I'm constantly impressed. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

In today's day and age, redundancy and clustering are very important. Plenty of other databases out there offer relatively simple options for setting up replication, sharding, and automated failover. PostgreSQL doesn't have much built in to address these concerns. There are myriad projects that facilitate these important features, but none of them feel great to me. Perhaps I just need more time to invest in them. Review collected by and hosted on G2.com.

What do you like best about PostgreSQL?

postgres allows for faster query execution Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

it does not have as powerful language as oracle. Review collected by and hosted on G2.com.

What do you like best about PostgreSQL?

I like that it is both lightweight and fast. It's pretty lean on resource consumption. Replication is easy to set up and pretty well documented by the Postgres Development Group. I like that it was easy to make changes to replication and access permissions without having to do a full restart of the database. I several times found my self impressed by how resilient the database was. Disk filled up? Add more storage and restart the database without data file corruption (YMMV). Your replication slave broke and you don't have the logs on disk for it to catch up? Blow it away, clone the master, and restart replication (don't use the postgres version in the AWS repo).

Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

In comparison to any other database technology that I've worked with, Postgres was easy to work with. "It wasn't implemented correctly", "replication was set up wrong", "the server capacity was misguessed when it was launched:" These are downsides to any technology where there is a general lack of knowledge. There's a simple way to avoid those problems: Hire a DBA, or experienced sysadmin and take their advice. There is problem with a lack of general knowledge when it comes to open source technologies combined with the fact experienced technologists all seem to have their own beloved biases. But those problems are not related to the technologies in use, but rather the people that use them.

Scalability never became an issue, but I haven't seen a lot of solutions for building hot-hot clusters, or putting multiple instances behind a connection manager for horizontal scalability, and trying to research multi node clusters will tell you how to set up synchronous/asynchronous master/slave replication at best or make you realize that a lot of the PG user community does not know the difference between high availability and scalability. Review collected by and hosted on G2.com.

What do you like best about PostgreSQL?

- Open source and liberal Open Source license

- Big community

- Active development

- Partition, JSON, streaming replication support

- Performance

- Master-Master

- Transaction safe DDLs Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

- Master-Master georeplication(BDR) not production ready yet.

- Missing Oracle-like stats reports(has 3rd party tools but not enough)

- Missing administration GUI(like Oracle's enterprise manager) Review collected by and hosted on G2.com.

What do you like best about PostgreSQL?

That's hard - I love how quickly it installs, I love that we get every feature we could hope for and more, it's fast, it's smart, the documentation is easily accessible and understandable without a "certification", when you get stuck on a problem, people that work on the product answer your questions on the forum!! Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Never sure how to pronounce the name!!!! Review collected by and hosted on G2.com.