PostgreSQL Reviews & Product Details

What I like most about PostgreSQL is the balance it achieves between robustness and flexibility. It offers reliable ACID transactions, strong referential integrity, and a powerful query optimizer. Additionally, it supports JSONB, advanced indexes, and extensions, allowing the combination of the relational model with semi-structured cases without the need to change engines. Overall, I find it a stable, scalable, and suitable option for both small projects and critical systems. Review collected by and hosted on G2.com.

PostgreSQL may require more careful initial configuration and optimization compared to simpler databases. In teams without experience in tuning, indexes, and query planning, performance can degrade if the schema is not designed correctly from the start. Additionally, some advanced administrative tasks demand a deeper technical knowledge. Review collected by and hosted on G2.com.

PostgreSQL offers strong performance, reliability, and advanced SQL capabilities. Features like JSONB support, indexing options, window functions, and extensions make it highly flexible for both transactional and analytical workloads. It integrates well with modern stacks and handles large datasets efficiently while maintaining data integrity. Review collected by and hosted on G2.com.

Initial configuration and tuning can be complex, especially for high-traffic systems. Some administrative tasks require deeper database knowledge, and horizontal scaling is not as straightforward compared to certain distributed databases. Review collected by and hosted on G2.com.

It is easy to extent with something like TimescaleDB you can turn Postgres into a hybrid row + columnar database without changing much in your application, which is pretty powerful.

it is feature rich with true ACID guarantees, and a huge ecosystem (PostGIS, JSONB, extensions) that make it both reliable and flexible.

Easy to Setup. Our goto database for most production workloads Review collected by and hosted on G2.com.

Connection pooling isn’t built in, so in most real production setups adding something like PgBouncer becomes almost mandatory. It’s not hard to do, but it feels like something that could have been native. Review collected by and hosted on G2.com.

I like using PostgreSQL for maintaining data integrity across all our customers. I also appreciate staying up to date with the PostgreSQL version through AWS. The ability to maintain relational integrity between tables and connect to the database via Spring Boot applications is very helpful. PG Admin is useful for connecting and has an interface that's different from MySQL Workbench. I can run multiple queries in a single tab, use filters, and connect to various databases easily. The query results are quick, and the updates provided by the PostgreSQL team are fast, which motivates us. I feel confident that my data is safe with PostgreSQL's fail-safe features. Additionally, the interface is easy to navigate, especially with the help of client ID and client secret in the UI. It's also easy to update without needing to rewrite queries. The ease of setup and documentation make it quick to get started, and it's easier to connect to open source details. Review collected by and hosted on G2.com.

I feel like the user interface could be improved. Also, I think there isn't much awareness about PostgreSQL; the marketing seems slow, and many people, including undergraduates, aren't sure about what PostgreSQL is. It might be beneficial to focus more on providing courses. Review collected by and hosted on G2.com.

What I like best about PostgreSQL is its stability, reliability, and advanced feature set. It supports complex queries, JSON data types, and powerful indexing options, making it ideal for both analytical and transactional workloads. The open-source nature, strong community support, and compatibility with many tools like Tableau and Django make it highly flexible. Its performance, scalability, and security features make PostgreSQL a dependable choice for enterprise-grade applications. Review collected by and hosted on G2.com.

One thing I dislike about PostgreSQL is that performance tuning and configuration can be complex, especially for beginners. Managing replication, optimizing queries, and handling large-scale data requires deeper technical expertise. Also, compared to some commercial databases, built-in monitoring and GUI tools are limited, so additional tools are often needed. Despite this, its overall reliability and flexibility still make it a top choice for database management. Review collected by and hosted on G2.com.

This is an easy way to work with and integrate multiple platforms. Review collected by and hosted on G2.com.

So far, everything appears to be working perfectly. I haven't noticed any issues yet. Review collected by and hosted on G2.com.

PostgreSQL is always my go-to option when beginning a new project. Being open-source, it allows you to cut costs while still offering impressive power and flexibility. A major advantage is its support for extensions, which lets you customize the database to fit your unique requirements. Additionally, PostgreSQL includes strong built-in security features, making it a reliable solution for projects ranging from small applications to large enterprise systems. Review collected by and hosted on G2.com.

The only aspects I’m not completely satisfied with are the process-per-connection model and the tendency for PostgreSQL to demand significant hardware resources, particularly when operating at scale. Despite these drawbacks, PostgreSQL continues to be one of the most reliable and flexible databases I have ever worked with. Review collected by and hosted on G2.com.

It's super powerful and open-sourced. Its performance is unmatched and competes with solutions that cost thousands of dollars. The number of features is simply amazing. I use this every day to accomplish my work. It was super easy to set up. I'm a developer and use this for clients and my own applications. On my Mac, I use TablePlus to manage my Postgres databases. I have many connections to manage in the app. It works so flawlessly in my applications, it's hard not to rave over it. Review collected by and hosted on G2.com.

There really isn't any negative to using PostgreSQL. I suppose customer support would be the biggest downfall since it's an open-source project. Review collected by and hosted on G2.com.

What I like best about PostgreSQL is that it feels like a complete database out of the box while still being incredibly flexible. It has strong support for standards, which makes queries predictable, and it includes a wide range of useful data types like JSONB, arrays, and ranges without needing third-party add-ons. Its extensibility is a major strength, letting you define your own data types, functions, and operators so the database can adapt to your needs. Reliability is another big factor, with its multi-version concurrency control ensuring safe transactions and reducing locking issues. On top of that, it offers excellent performance without sacrificing correctness, and the active community keeps improving it with new features, extensions, and tooling. PostgreSQL manages to combine enterprise-grade robustness with developer-friendly features. Review collected by and hosted on G2.com.

Nothing to dislike. Some of the ORMS for Typescript are lacking in features but that's not a PostgresQL issue Review collected by and hosted on G2.com.

PostgreSQL is my top choice because it is extremely reliable, offers a wide range of powerful features, and remains fully open-source and flexible. I also find it very straightforward to use and easy to understand. Review collected by and hosted on G2.com.

Tasks such as tuning performance, managing vacuuming, and configuring replication require more attention than with some more straightforward databases. Review collected by and hosted on G2.com.