PostgreSQL Reviews & Product Details

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.

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

This is one of my favorite databases. It allows me to get set up fast and handle any workload. I love using it with Prisma, I love using it with Ruby on Rails and all my projects. I don't think there's even a project that I use without it. Review collected by and hosted on G2.com.

Don’t have any dislikes at this point in time Review collected by and hosted on G2.com.

PostgreSQL offers exceptional reliability and flexibility for both transactional and analytical workloads. I appreciate its strong ACID compliance, robust indexing strategies, and the ability to handle complex queries efficiently. The open-source ecosystem is very mature, and extensions like PostGIS and pgAdmin make it a versatile tool. Performance tuning and horizontal scaling are well-documented, and its integration with .NET, Node.js, and cloud providers (AWS RDS, Azure Database) is seamless. Review collected by and hosted on G2.com.

While PostgreSQL is extremely powerful, it can be intimidating for newcomers. Some advanced configurations—like connection pooling or query planner tuning—require deep database knowledge. The learning curve for replication and failover setup is also steep, and GUI tools are not as intuitive as those for MySQL or SQL Server. However, once mastered, its capabilities easily outweigh the initial challenges. Review collected by and hosted on G2.com.

1) Open-source and free

2) Highly reliable and ACID compliant

3) Supports complex queries and JSONB

4) Extensible (custom types, functions, extensions)

5) Strong concurrency with MVCC

6) Cross-platform and cloud compatible

7) Advanced security features

8) Good scalability and replication

9) Large and active community Review collected by and hosted on G2.com.

1) Slower for simple read-heavy workloads

2) Requires manual tuning for performance

3) Replication/sharding setup is complex

4) Steeper learning curve

5) Higher memory and disk usage

6)Fewer managed hosting options Review collected by and hosted on G2.com.

The robustness with which the data is handled, the ease of managing tables, in addition to the fact that several database GUIs integrate easily to manage all the information handled within PostgreSQL. Review collected by and hosted on G2.com.

It is somewhat slow in its performance, as for small databases it would be better to use another relational database manager. Review collected by and hosted on G2.com.

What truly distinguishes PostgreSQL for me is its reliability and data integrity. After more than five years of using it in production environments, I can say it has never failed me. Its ACID compliance is exceptionally robust, and the way it manages concurrent transactions continues to impress. I also value its extensive feature set, such as JSONB support, full-text search, and the ability to extend functionality with custom functions and types. The community is another strong point—whenever I encounter an edge case, I can usually find a well-documented solution or a helpful discussion in the mailing lists. Review collected by and hosted on G2.com.

The learning curve can be quite steep for newcomers, particularly when it comes to grasping the nuances of vacuum and autovacuum tuning to achieve optimal performance. Managing configurations across various environments demands close attention, as the default settings are not always suitable for production workloads. While replication is a strong feature, its setup tends to be more complicated than with some other options. Review collected by and hosted on G2.com.