PostgreSQL Reviews & Product Details

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.

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.

I mainly used my postgres for storing my transactional data and also for some analytical data. It is very good database if we are using it for transactions. Review collected by and hosted on G2.com.

When the data is large , it is little slow and also we need maintain proper indexing for every thing. Review collected by and hosted on G2.com.

Mature, open source object-relational database management system (ORDBMS) with a long track record of reliability and technical depth. Its architecture and feature set are consistently robust, making it suitable for a wide range of workloads, from transactional systems to analytical platforms.

Key technical features that consistently perform well:

• Extensibility: PostgreSQL supports custom data types, operators, and functions. The extension ecosystem is rich, with modules like PostGIS for geospatial data and pgcrypto for cryptographic functions. The ability to define user-defined functions in multiple languages (PL/pgSQL, Python, Java, etc.) adds flexibility for advanced use cases.

• Advanced SQL compliance: The system implements a wide array of SQL standards, including support for window functions, common table expressions (CTEs), and recursive queries. This makes it possible to express complex business logic natively within the database.

• ACID transactions and data integrity: PostgreSQL enforces atomicity, consistency, isolation, and durability. Features like multi-version concurrency control (MVCC), foreign keys, triggers, and check constraints are implemented in a way that works reliably even under heavy concurrent loads.

• Native support for structured and semi-structured JSON, XML, HSTORE, and array data types are first-class citizens. This allows for flexible schema design and hybrid workloads that combine relational and document-oriented paradigms.

• Indexing and performance optimization: Multiple indexing strategies are available, including B-tree, GiST, GIN, and SP-GiST, which handle diverse query patterns efficiently. Full-text search and partial indexes are supported natively.

• Cross-platform and deployment flexibility: PostgreSQL runs on all major operating systems (Linux, Windows, macOS, BSD variants) and is available as a managed service from most cloud providers, as well as for on-premises deployment.

• Active and knowledgeable community: The documentation is comprehensive, and the global community is engaged and responsive. Frequent updates and a transparent development process ensure quick access to new features and security patches. Review collected by and hosted on G2.com.

• Enterprise-readiness out of the box: Core PostgreSQL does not include certain enterprise features natively, such as built-in sharding, advanced high-availability clustering, or automated failover. These require third-party tools or extensions, each with their own operational complexity and support models.

• Performance tuning complexity: Achieving optimal performance for large or highly concurrent workloads often demands careful configuration and ongoing monitoring. Autovacuum and query planner behaviors, in particular, may need manual adjustment in demanding environments. Review collected by and hosted on G2.com.

EDB provides a reliable PostgreSQL experience with extended enterprise tools like EDB Postgres Advanced Server. I specially appreciated the integration with tools like pgAdmin and support for Oracle compatibility. Their technical documentation and support response times were impressive during our migration phase. Review collected by and hosted on G2.com.

Pricing for some enterprise tools can be expensive for small teams. Also, while support is strong, initial onboarding for complex configurations (like replication or migration) could benefit from more hands-on guidance or clearer tutorials. Review collected by and hosted on G2.com.