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.

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.

I like that PostgreSQL is free and open source. We can rely on it for scalability and ease of use, which saves a lot of money on database infrastructure. It's also very customizable, and we can run it on servers with minimal hardware configurations. Its advanced features allow us to have better control of our data sets, manage complex queries, and handle JSON more easily. The fact that we can contribute to its development gives us a sense of involvement and community. Review collected by and hosted on G2.com.

It's a bit slow compared to other specialized databases like MySQL or NoSQL databases for large data sets. Initial setup was a bit difficult because it was not supported for our legacy system hardware. Review collected by and hosted on G2.com.

PostgreSQL strikes a great balance between ease of use and depth of features. The initial setup and implementation are straightforward, and it integrates well with most programming languages, frameworks, and ORMs. I use it frequently because it offers rich features out of the box (CTEs, JSONB, full-text search, indexing options) without needing external add-ons. It’s very stable, reliable, and easy to scale once you get familiar with its ecosystem. Review collected by and hosted on G2.com.

The main challenge is that advanced tuning and optimization require expertise — features like partitioning, replication, or query optimization aren’t always beginner-friendly. Customer support depends heavily on community resources unless you opt for paid enterprise support, which might not suit smaller teams. GUI tools like pgAdmin are functional but not the most user-friendly compared to some commercial alternatives. Review collected by and hosted on G2.com.