PostgreSQL Reviews & Product Details

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

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

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

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

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

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

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.

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.

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

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

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.

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.

- 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.

- 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.

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.

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

Elegance, intuitive feel. Great manual. Endless improvements. Review collected by and hosted on G2.com.

hard to keep up with all the enhancements! Review collected by and hosted on G2.com.

PostgreSQL is well-documented, powerful, mature, and has a huge user base. Easy to find examples and forum postings when troubleshooting just about any scenario: the odd error message, problems using pgAdmin, figuring out how to integrate PostgreSQL into your node.js application. Review collected by and hosted on G2.com.

For some use-cases, PostgreSQL isn't the best option. It's worth considering your needs and looking at SQLite, MongoDB, and others. Review collected by and hosted on G2.com.