# PostgreSQL Reviews **Vendor:** PostgreSQL **Category:** [Relational Databases](https://www.g2.com/categories/relational-databases) **Average Rating:** 4.4/5.0 **Total Reviews:** 671 ## About PostgreSQL PostgreSQL is a powerful, open-source object-relational database system renowned for its reliability, extensibility, and adherence to SQL standards. Originating from the POSTGRES project at the University of California at Berkeley in 1986, it has evolved over nearly four decades into a robust platform capable of handling complex data workloads across various operating systems. PostgreSQL's architecture emphasizes data integrity and scalability, making it a preferred choice for developers and organizations worldwide. Key Features and Functionality: - Comprehensive Data Types: Supports a wide range of data types, including primitives (Integer, Numeric, String, Boolean), structured (Date/Time, Array, Range), document (JSON/JSONB, XML), and geometric types. - Advanced Data Integrity: Ensures data accuracy through features like UNIQUE constraints, primary and foreign keys, exclusion constraints, and various locking mechanisms. - High Performance and Concurrency: Utilizes advanced indexing methods (B-tree, GiST, GIN, BRIN), a sophisticated query planner, multi-version concurrency control (MVCC), parallel query execution, and table partitioning to optimize performance. - Reliability and Disaster Recovery: Offers write-ahead logging (WAL), various replication methods (asynchronous, synchronous, logical), point-in-time recovery (PITR), and active standbys to ensure data durability and availability. - Robust Security Measures: Provides multiple authentication methods (GSSAPI, SSPI, LDAP, SCRAM-SHA-256, Certificate, OAuth 2.0), a comprehensive access-control system, and supports multi-factor authentication. - Extensibility: Allows the creation of custom data types, functions, and operators. Supports procedural languages like PL/pgSQL, Perl, Python, and Tcl, with additional languages available through extensions. Primary Value and User Solutions: PostgreSQL addresses the needs of developers and organizations by offering a highly extensible and standards-compliant database system that ensures data integrity, scalability, and robust performance. Its open-source nature allows for continuous innovation and adaptability, enabling users to tailor the database to their specific requirements. Whether managing small applications or large-scale enterprise systems, PostgreSQL provides a reliable foundation for storing and processing data efficiently. ## PostgreSQL Pros & Cons **What users like:** - Users appreciate the **reliability and rich feature set** of PostgreSQL, highlighting its ACID compliance and extensive capabilities. (16 reviews) - Users find PostgreSQL to be **easy to use and integrate** , enjoying its straightforward setup and extensive features. (13 reviews) - Users value PostgreSQL for its **open-source flexibility** , allowing cost-effective and powerful data management solutions. (10 reviews) - Users value the **reliability and data integrity** of PostgreSQL, affirming it has never failed in production. (10 reviews) - Users value the **scalability** of PostgreSQL, finding it easy to manage growth for projects of any size. (10 reviews) - Users value the **flexibility** of PostgreSQL, appreciating its extensibility and customization options for diverse projects. (8 reviews) - Data Analytics (6 reviews) - Users find **easy integrations** with PostgreSQL, effortlessly implementing it across various systems and programming languages. (6 reviews) - Performance (6 reviews) - Query Speed (5 reviews) **What users dislike:** - Users find PostgreSQL's **beginner unfriendliness** daunting due to its steep learning curve and complex configurations. (7 reviews) - Users find the **complexity** of PostgreSQL's SQL syntax and management tasks challenging compared to simpler databases. (6 reviews) - Users find the **learning curve steep** for PostgreSQL, particularly with vacuum tuning and advanced configurations, hindering newcomers. (5 reviews) - Users report **slow performance** with large databases and complex queries, leading to challenges in efficiency and responsiveness. (5 reviews) - Users find **complex configuration** demands considerable attention, making PostgreSQL challenging for beginners and requiring deep technical expertise. (4 reviews) - Users find PostgreSQL's **difficult learning curve** daunting, particularly regarding advanced tuning and configuration for beginners. (4 reviews) - Users note the **high hardware requirements** of PostgreSQL, which can impact performance and resource utilization significantly. (4 reviews) - Complex Setup (2 reviews) - Difficult Setup (2 reviews) - Scaling Issues (2 reviews) ## PostgreSQL Reviews ### 1. PostgreSQL: robust, flexible, and scalable, with ACID, JSONB, and powerful extensions **Rating:** 5.0/5.0 stars **Reviewed by:** Axel U. | Software Engineer, Computer Software, Small-Business (50 or fewer emp.) **Reviewed Date:** February 17, 2026 **What do you like best about PostgreSQL?** 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. **What do you dislike about PostgreSQL?** 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. **What problems is PostgreSQL solving and how is that benefiting you?** PostgreSQL helps solve data integrity, concurrency, and scalability issues in critical systems. It allows managing complex transactions with guaranteed consistency and supports high volumes of information without losing performance, as long as the design is appropriate. In my case, it benefits me because it offers stability, security, and the flexibility needed to evolve the data model without having to change technology. ### 2. Powerful and reliable open-source database for scalable applications **Rating:** 4.5/5.0 stars **Reviewed by:** Jignesh A. P. | Delivery Manager, Mid-Market (51-1000 emp.) **Reviewed Date:** March 29, 2026 **What do you like best about PostgreSQL?** 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. **What do you dislike about PostgreSQL?** 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. **What problems is PostgreSQL solving and how is that benefiting you?** PostgreSQL helps manage large-scale relational data with high consistency and performance. It supports complex queries, reporting, and transactional operations in a single system, reducing the need for multiple databases. This improves performance, simplifies architecture, and lowers operational overhead. ### 3. Powerful, Extensible Postgres with ACID Guarantees and a Huge Ecosystem **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** March 14, 2026 **What do you like best about PostgreSQL?** 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 **What do you dislike about PostgreSQL?** 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. **What problems is PostgreSQL solving and how is that benefiting you?** PostgreSQL solves the problem of needing a single, reliable datastore that supports complex relational queries, strong ACID transactions, and rich extensibility (JSONB, PostGIS, TimescaleDB). That benefits me by letting me handle OLTP, analytics, geospatial and time-series needs in one engine, reducing integration pain, saving dev time, and keeping operations simpler. ### 4. Robust, Feature-Rich, and Secure Database Solution **Rating:** 5.0/5.0 stars **Reviewed by:** sai kiran narayana . | software engineer, Enterprise (> 1000 emp.) **Reviewed Date:** January 21, 2026 **What do you like best about PostgreSQL?** 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. **What do you dislike about PostgreSQL?** 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. **What problems is PostgreSQL solving and how is that benefiting you?** I use PostgreSQL to connect databases via Spring Boot, ensuring data integrity and reliability in production. It's more secure and feature-rich than MySQL Workbench, and it keeps our database practices up-to-date. ### 5. Reliable and Feature-Rich, But Requires Technical Know-How **Rating:** 5.0/5.0 stars **Reviewed by:** Maxman 0. | My current job title is Data Analyst, Information Technology and Services, Mid-Market (51-1000 emp.) **Reviewed Date:** November 04, 2025 **What do you like best about PostgreSQL?** 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. **What do you dislike about PostgreSQL?** 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. **What problems is PostgreSQL solving and how is that benefiting you?** PostgreSQL solves the problem of managing large and complex datasets efficiently while maintaining data integrity and security. It provides powerful features like advanced indexing, JSON support, and reliable ACID compliance, which ensure smooth transactional and analytical operations. For me, it simplifies data storage, querying, and integration with tools like Tableau and Django, enabling faster reporting, better performance, and easier scalability for enterprise applications. ### 6. Effortless Integration Across Multiple Platforms **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Entertainment | Mid-Market (51-1000 emp.) **Reviewed Date:** January 08, 2026 **What do you like best about PostgreSQL?** This is an easy way to work with and integrate multiple platforms. **What do you dislike about PostgreSQL?** So far, everything appears to be working perfectly. I haven't noticed any issues yet. **What problems is PostgreSQL solving and how is that benefiting you?** PostgreSQL is highly integration-friendly, offering support for a wide range of APIs, drivers, and connectors such as ODBC, JDBC, and REST. This flexibility makes it much easier to connect with various tools and enterprise systems. In terms of cost efficiency, PostgreSQL stands out because it does not require licensing fees, which helps lower operational expenses compared to proprietary databases. The platform also allows for the creation of custom functions and extensions, which is particularly useful for developing tailored solutions that meet specific workflow requirements. Its strong transactional integrity provides reliability, ensuring that automated processes and integrations operate smoothly without risking data corruption. Additionally, the active community and frequent updates contribute to future-proofing, guaranteeing ongoing support and continuous innovation. ### 7. Reliable, Powerful, and My Go-To Database **Rating:** 4.5/5.0 stars **Reviewed by:** Alvaro I. | Director of Web Development, Mid-Market (51-1000 emp.) **Reviewed Date:** October 09, 2025 **What do you like best about PostgreSQL?** 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. **What do you dislike about PostgreSQL?** 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. **What problems is PostgreSQL solving and how is that benefiting you?** PostgreSQL addresses the need for a dependable, affordable, and adaptable database solution for modern applications. It allows me to create everything from small prototypes to large-scale production systems, all without concerns about licensing fees, scalability limitations, or lacking essential features. ### 8. The absolute best database! **Rating:** 5.0/5.0 stars **Reviewed by:** Damien W. | President, Small-Business (50 or fewer emp.) **Reviewed Date:** October 09, 2025 **What do you like best about PostgreSQL?** 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. **What do you dislike about PostgreSQL?** 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. **What problems is PostgreSQL solving and how is that benefiting you?** As a developer, I work on many applications. Without a database, these applications wouldn't be helpful. Many companies are using PostgreSQL for their backends, including services that I use in my application. Running it locally, I'm able to develop tools for my clients daily. ### 9. Reliable DB System **Rating:** 4.5/5.0 stars **Reviewed by:** Conor M. | Frontend Developer, Small-Business (50 or fewer emp.) **Reviewed Date:** September 30, 2025 **What do you like best about PostgreSQL?** 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. **What do you dislike about PostgreSQL?** Nothing to dislike. Some of the ORMS for Typescript are lacking in features but that's not a PostgresQL issue **What problems is PostgreSQL solving and how is that benefiting you?** PostgreSQL solves the problem of needing one database that can handle both traditional structured data and newer, more flexible types of data. It gives you strong reliability for transactions, while also letting you store things like JSON alongside normal tables. That means you don’t have to juggle multiple databases or trade off between safety and flexibility. Because it’s easy to extend with custom functions and features, it avoids becoming a roadblock as needs grow. For me, this means less complexity to manage, fewer tools to maintain, and a database I can rely on to grow with the application. ### 10. Reliable, Feature-Rich, and Effortlessly Easy to Use **Rating:** 5.0/5.0 stars **Reviewed by:** Sharon A. | DevOps Engineer, Maritime, Enterprise (> 1000 emp.) **Reviewed Date:** January 11, 2026 **What do you like best about PostgreSQL?** 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. **What do you dislike about PostgreSQL?** Tasks such as tuning performance, managing vacuuming, and configuring replication require more attention than with some more straightforward databases. **What problems is PostgreSQL solving and how is that benefiting you?** PostgreSQL addresses the need for reliable, scalable, and feature-rich data management. It provides me with a stable database solution capable of handling complex queries, managing large datasets, and supporting production workloads securely, all without the risk of vendor lock-in. ## PostgreSQL Discussions - [Can we get some video tutorials on usage? Also how do we connect them over cloud ?](https://www.g2.com/discussions/can-we-get-some-video-tutorials-on-usage-also-how-do-we-connect-them-over-cloud) - 1 comment, 1 upvote - [What is PostgreSQL used for?](https://www.g2.com/discussions/what-is-postgresql-used-for) - 1 comment - [What is special about PostgreSQL?](https://www.g2.com/discussions/what-is-special-about-postgresql) - 1 comment - [What are the advantages and disadvantages of PostgreSQL?](https://www.g2.com/discussions/what-are-the-advantages-and-disadvantages-of-postgresql) - 2 comments - [What programs use PostgreSQL?](https://www.g2.com/discussions/what-programs-use-postgresql) - 1 comment ## PostgreSQL Integrations - [Amazon Redshift](https://www.g2.com/products/amazon-redshift/reviews) - [Apache Superset](https://www.g2.com/products/apache-superset/reviews) - [Apache Tomcat](https://www.g2.com/products/apache-tomcat/reviews) - [Azure Database for PostgreSQL](https://www.g2.com/products/azure-database-for-postgresql/reviews) - [cPanel](https://www.g2.com/products/cpanel/reviews) - [F5 NGINX](https://www.g2.com/products/f5-nginx/reviews) - [InMotion Hosting](https://www.g2.com/products/inmotion-hosting/reviews) - [Laravel](https://www.g2.com/products/laravel/reviews) - [MongoDB](https://www.g2.com/products/mongodb/reviews) - [n8n](https://www.g2.com/products/n8n/reviews) - [Next.js](https://www.g2.com/products/next-js/reviews) - [Node.js](https://www.g2.com/products/node-js/reviews) - [Oracle Database](https://www.g2.com/products/oracle-database/reviews) - [pandas python](https://www.g2.com/products/pandas-python/reviews) - [Pentaho Data Integration](https://www.g2.com/products/pentaho-data-integration/reviews) - [PostgreSQL](https://www.g2.com/products/postgresql/reviews) - [PostgreSQL on Amazon Linux 2](https://www.g2.com/products/postgresql-on-amazon-linux-2/reviews) - [PostgreSQL With Redhat 8](https://www.g2.com/products/postgresql-with-redhat-8/reviews) - [Prisma](https://www.g2.com/products/prisma-prisma/reviews) - [Python](https://www.g2.com/products/python/reviews) - [QGIS](https://www.g2.com/products/qgis/reviews) - [React Native](https://www.g2.com/products/react-native/reviews) - [Redis Software](https://www.g2.com/products/redis-software/reviews) - [Ruby on Rails](https://www.g2.com/products/ruby-on-rails/reviews) - [Tableau](https://www.g2.com/products/tableau/reviews) ## PostgreSQL Features **Management ** - Data Schema - Query Language - ACID - Complaint - Data Replication **Support ** - Text Search - Data Types - Languages - Operating Systems **Security** - Database Locking - Access Control - Encryption - Authentication **Performance ** - Disaster Recovery - Data Concurrency - Workload Management - Advanced Indexing - Query Optimizer **Database Features** - Storage - Availability - Stability - Scalability - Security - Data Manipulation - Query Language ## Top PostgreSQL Alternatives - [Microsoft SQL Server](https://www.g2.com/products/microsoft-sql-server/reviews) - 4.4/5.0 (2,106 reviews) - [MySQL](https://www.g2.com/products/mysql/reviews) - 4.4/5.0 (1,572 reviews) - [Oracle Database](https://www.g2.com/products/oracle-database/reviews) - 4.3/5.0 (918 reviews)