# PostgreSQL Reviews **Vendor:** PostgreSQL **Category:** [Relational Databases](https://www.g2.com/categories/relational-databases) **Average Rating:** 4.4/5.0 **Total Reviews:** 677 ## 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 **robust reliability and extensive feature set** of PostgreSQL, making it an excellent choice for diverse applications. (16 reviews) - Users find **PostgreSQL easy to use** , offering straightforward setup and seamless integration with various platforms. (13 reviews) - Users value the **open-source nature** of PostgreSQL, enabling cost-effective use with impressive power and flexibility. (10 reviews) - Users commend PostgreSQL for its **unwavering reliability** , ensuring data integrity and performance in production environments. (10 reviews) - Users value PostgreSQL's **scalability** , allowing seamless adjustments from small applications to large enterprise systems effortlessly. (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 SQL syntax** in PostgreSQL challenging compared to simpler alternatives like MySQL. (6 reviews) - Users find the **learning curve steep** , particularly for beginners struggling with complex configurations and advanced features. (5 reviews) - Users face **slow performance** in PostgreSQL, especially with large databases and complex queries, impacting overall efficiency. (5 reviews) - Users find the **complex configuration** of PostgreSQL challenging, especially for performance tuning and managing replication. (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. Versatile, High-Performance PostgreSQL for Local and Cloud Development **Rating:** 5.0/5.0 stars **Reviewed by:** Gunther C. | Software Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** May 13, 2026 **What do you like best about PostgreSQL?** PostgreSQL offers robust database functionality that covers a wide variety of use cases. The ability to run this database locally for testing and development as well as in the cloud is imperative for ensuring that software runs as expected when it goes into production. The adoption of PostgreSQL by a wide variety of cloud providers has made this a great option for most software projects. **What do you dislike about PostgreSQL?** I have few complaints about PostgreSQL, it is one of the most versatile and performant databases that I've used **What problems is PostgreSQL solving and how is that benefiting you?** A critical problem PostgreSQL solves is the ability to run a production database setup locally, this makes testing and development significantly easier and helps engineers be confident that their chances will work as expected when they merge into production. The wide variety of functionality supported by PostgreSQL is also helpful, the ability to query unstructured JSON alongside relational data is an extremely valuable feature. ### 2. Enterprise-Grade Power with Open-Source Flexibility—Plus an Intuitive PgAdmin UI **Rating:** 5.0/5.0 stars **Reviewed by:** Aparajito P. | NA, Mid-Market (51-1000 emp.) **Reviewed Date:** April 21, 2026 **What do you like best about PostgreSQL?** What I like best about PostgreSQL is how it combines power, reliability, and flexibility in one platform. Its SQL standards compliance, strong performance, advanced indexing, and support for both relational and JSON workloads make it suitable for everything from transactional apps to analytics platforms. From a UI/UX standpoint, it works well with excellent tools like pgAdmin and many third-party clients. In terms of integrations, it connects easily with BI tools, ETL pipelines, cloud platforms, and programming languages. For pricing / ROI, being open-source significantly lowers total cost while still delivering enterprise-grade capabilities. It also has a large community for support / onboarding, with abundant documentation and tutorials. On AI / Intelligence, its growing ecosystem for vector extensions and ML integrations makes it increasingly relevant for modern AI-driven applications.ern AI-driven applications. **What do you dislike about PostgreSQL?** What I dislike about PostgreSQL is that while it is powerful, it can feel complex for new users. The UI / UX depends heavily on third-party tools rather than a polished native interface. In terms of performance, it may require careful tuning for very high write-volume workloads or large-scale horizontal scaling. Some integrations and enterprise features can need extra setup compared with fully managed commercial platforms. For support / onboarding, community resources are strong, but official hands-on vendor support is limited unless using a managed provider. On AI / Intelligence, capabilities often rely on extensions rather than built-in native features. **What problems is PostgreSQL solving and how is that benefiting you?** Before using PostgreSQL, we struggled with data being spread across multiple systems, slow report generation, and rising licensing costs from proprietary databases. Managing transactional data separately from analytics workloads created delays and frequent data inconsistencies. After implementing PostgreSQL, we consolidated those workloads into a single platform with stronger performance and reliability. We can now run operational transactions and reporting from one source of truth, which has reduced reporting time from hours to minutes and improved decision-making speed. From a pricing / ROI perspective, moving to an open-source platform cut annual database licensing costs by an estimated 40%. Its broad integrations with BI dashboards, ETL tools, and cloud services also reduced development effort and simplified workflows. For support / onboarding, the large community and available documentation helped our team ramp up quickly with minimal external consulting. Additionally, newer AI / Intelligence extensions gave us the ability to experiment with vector search and smarter analytics without adding another database stack. ### 3. 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. ### 4. 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. ### 5. 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. ### 6. Reliable, Powerful, and Perfect for Complex Applications **Rating:** 4.5/5.0 stars **Reviewed by:** Deepak S. | Software Developer, Small-Business (50 or fewer emp.) **Reviewed Date:** May 06, 2026 **What do you like best about PostgreSQL?** I like that PostgreSQL is reliable, fast, and very stable. It handles complex data well and has strong features while still being open-source and easy to use. Features like advanced queries, strong data integrity, and good performance help me manage applications smoothly. It handles large data reliably, reduces errors, and works well even as projects grow. **What do you dislike about PostgreSQL?** Sometimes PostgreSQL setup and optimization can feel complex for beginners. Managing performance tuning and large-scale configurations may take extra time and experience. **What problems is PostgreSQL solving and how is that benefiting you?** I use PostgreSQL to store and manage application data securely and efficiently. It handles large amounts of data well, supports complex queries, and keeps applications stable and reliable. ### 7. High-Performance Database That Handles Large Data Sets Effortlessly **Rating:** 4.5/5.0 stars **Reviewed by:** Paul M. | Owner, Computer Software, Small-Business (50 or fewer emp.) **Reviewed Date:** April 14, 2026 **What do you like best about PostgreSQL?** High-performance database that handles large data sets without any issues. **What do you dislike about PostgreSQL?** There’s nothing to dislike. It works well for everything we want it to do, and it meets our needs without any issues. **What problems is PostgreSQL solving and how is that benefiting you?** The previous database engine we used was limited to 4 GB of data, and it required a lot of manual maintenance. With PostgreSQL, the capacity is practically unlimited, it needs very little maintenance, and it runs on a wide variety of operating systems and platforms. ### 8. 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. ### 9. 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. ### 10. 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. ### 11. 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. ### 12. 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. ### 13. 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. ### 14. PostgreSQL: Production-Proven, Feature-Rich, and Free **Rating:** 5.0/5.0 stars **Reviewed by:** Pranav c. | Infrastructure Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** April 19, 2026 **What do you like best about PostgreSQL?** PostgreSQL is arguably the best general-purpose relational database available today. It's production-proven, feature-rich, and free. The operational complexity is the main trade-off, but managed services (AWS RDS, Supabase, Neon, Railway) largely eliminate that concern for most teams. **What do you dislike about PostgreSQL?** Extremely write-heavy workloads at massive scale **What problems is PostgreSQL solving and how is that benefiting you?** Financial & transactional systems requiring strict ACID guarantees ### 15. 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. ### 16. Powerful, Customizable, Yet Needs Speed Boost **Rating:** 5.0/5.0 stars **Reviewed by:** Nabin P. | CEO, Mid-Market (51-1000 emp.) **Reviewed Date:** December 16, 2025 **What do you like best about PostgreSQL?** 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. **What do you dislike about PostgreSQL?** 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. **What problems is PostgreSQL solving and how is that benefiting you?** I use PostgreSQL for scalability, ease of use, and cost savings. We switched to PostgreSQL for better control of our data sets, complex queries, and easier JSON handling. ### 17. A rock-solid, feature-rich database that grows with your needs **Rating:** 4.5/5.0 stars **Reviewed by:** Ravi P. | Senior Software Engineer, Computer Software, Small-Business (50 or fewer emp.) **Reviewed Date:** September 27, 2025 **What do you like best about PostgreSQL?** 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. **What do you dislike about PostgreSQL?** 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. **What problems is PostgreSQL solving and how is that benefiting you?** What problems is PostgreSQL solving and how is that benefiting you? ### 18. My Go-To Database for Every Project **Rating:** 5.0/5.0 stars **Reviewed by:** Isaac B. | Technical Support Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** November 07, 2025 **What do you like best about PostgreSQL?** 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. **What do you dislike about PostgreSQL?** Don’t have any dislikes at this point in time **What problems is PostgreSQL solving and how is that benefiting you?** Postgres meets all my database requirements. Whenever I need to record, access, or write data for any application, I rely on it. I also use it in automations, which makes it even more versatile. It effectively handles all my data management needs, whether for my dental practice, applications, or other uses. ### 19. Versatile Database for Advanced Integrations **Rating:** 3.5/5.0 stars **Reviewed by:** Vaibhav R. | Full Stack Developer - BA4, Enterprise (> 1000 emp.) **Reviewed Date:** December 20, 2025 **What do you like best about PostgreSQL?** I use PostgreSQL for every project, from small to large, as it integrates well with my back-end REST and GraphQL APIs. I really like how it allows me to perform advanced SQL queries beyond just the normal ones. The advanced analytical features in PostgreSQL is very useful for my projects. I also love that it allows me to work with JSON objects, simplifying tasks related to both NoSQL-like use cases and SQL databases. **What do you dislike about PostgreSQL?** Scaling and operational aspects could be better, as it's doable but could be much more straightforward. Also, much more customization should be there. **What problems is PostgreSQL solving and how is that benefiting you?** PostgreSQL simplifies my project integration, supports both NoSQL-like use cases and SQL, and handles JSON/JSONB objects effectively. It's functional and easy to integrate with my backend APIs. ### 20. Rock-Solid Stability, But Can Be Slower for Simple Reads **Rating:** 3.0/5.0 stars **Reviewed by:** Aashish G. | Full Stack Developer, Small-Business (50 or fewer emp.) **Reviewed Date:** December 09, 2025 **What do you like best about PostgreSQL?** Postgres is known for being super stable. It don’t easily lose data, and it handle crashes very well. For big, serious applications, this is very helpful. **What do you dislike about PostgreSQL?** If your app is super basic (just simple reads), MySQL can be faster. Postgres focus more on accuracy and complex queries, so sometimes speed feel a bit slower for small things. **What problems is PostgreSQL solving and how is that benefiting you?** Many apps today don’t have only simple tables. There is relational data, JSON data, search data, etc. Postgres handle all of this in one place. ### 21. Reliable and Scalable Open-Source Database for Complex Applications **Rating:** 4.0/5.0 stars **Reviewed by:** Anthony Manuel B. | Software Quality Assurance Team Lead | Sr. Software Developer In Test , Mid-Market (51-1000 emp.) **Reviewed Date:** October 07, 2025 **What do you like best about PostgreSQL?** 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. **What do you dislike about PostgreSQL?** 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. **What problems is PostgreSQL solving and how is that benefiting you?** PostgreSQL has helped our teams centralize and optimize data management across multiple services while maintaining strong consistency and performance. It’s been key for handling high-volume transactional systems and automating validations through APIs that depend on complex relational queries. Its JSONB and indexing capabilities allow us to combine structured and semi-structured data without sacrificing speed. As a QA and automation engineer, it simplifies integration testing and data verification thanks to its predictable behavior and stability across environments. ### 22. Deep Dive into PostgreSQL: A Comprehensive Review **Rating:** 4.0/5.0 stars **Reviewed by:** Balkishan N. | Senior Software Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** October 10, 2025 **What do you like best about PostgreSQL?** 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 **What do you dislike about PostgreSQL?** 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 **What problems is PostgreSQL solving and how is that benefiting you?** PostgreSQL solves problems of data integrity, complex queries, and concurrency while supporting both structured and unstructured data. It benefits you by providing reliable, scalable, and secure storage, enabling faster development without licensing costs. ### 23. PostgreSQL as a powerful database manager **Rating:** 5.0/5.0 stars **Reviewed by:** Jose Alfredo A. | Docente Postgrado (Cursos de Actualización), Information Technology and Services, Mid-Market (51-1000 emp.) **Reviewed Date:** October 14, 2025 **What do you like best about PostgreSQL?** 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. **What do you dislike about PostgreSQL?** It is somewhat slow in its performance, as for small databases it would be better to use another relational database manager. **What problems is PostgreSQL solving and how is that benefiting you?** I like how it allows structuring complex data, as it also has plugins that facilitate its use. It not only functions as a database for storing relational information, but it can also store geographic data thanks to its integration with the POSTGIS structure. ### 24. Solid database that just works - the gold standard for open-source RDBMS **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.) **Reviewed Date:** November 25, 2025 **What do you like best about PostgreSQL?** 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. **What do you dislike about PostgreSQL?** 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. **What problems is PostgreSQL solving and how is that benefiting you?** PostgreSQL serves as the backbone of our data infrastructure, reliably managing complex transactional workloads for our SaaS applications. Its outstanding query planner enables us to efficiently run analytical queries as well. We rely on PostgreSQL to store both structured relational data and semi-structured JSON data within a single database, which greatly streamlines our overall architecture. The advantages are clear: we experience lower operational costs compared to commercial databases, enjoy confidence in our data integrity, and benefit from the flexibility to scale seamlessly from small projects to enterprise-level deployments—all without needing to change our core technology stack. ### 25. Powerful, Flexible, and Reliable Relational Database Solution **Rating:** 5.0/5.0 stars **Reviewed by:** Sarthak D. | Software Development Engineer , Enterprise (> 1000 emp.) **Reviewed Date:** November 20, 2025 **What do you like best about PostgreSQL?** PostgreSQL is the most abstract form of relational databases that provides ease of normalization, handling multiple databases, and transactions. All ACID properties can easily be applied, and it provides tools, an easier way to automate tasks. Great Customer Support. APIs, adapters, and interfaces are readily available for integration. **What do you dislike about PostgreSQL?** Slow performance for large databases and complex queries. No horizontal scaling. No Columnar storage of tables and no optimal indexing and sharding. Beginner unfriendly for introduction to RDBMS. **What problems is PostgreSQL solving and how is that benefiting you?** Easily integrate all layers of derived metric analysis from data. Multiple sub-databases can be integrated, acting as a single data store service in a service-oriented architecture. Rollback and commit transactions make it simple to implement transactions. ### 26. Open-Source Database with World-Class Performance and Reliability **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Small-Business (50 or fewer emp.) **Reviewed Date:** April 28, 2026 **What do you like best about PostgreSQL?** It’s an open-source database that delivers world-class performance, innovation, and reliability. **What do you dislike about PostgreSQL?** Long, unoptimizable queries can happen from time to time. **What problems is PostgreSQL solving and how is that benefiting you?** Our data management has improved by consolidating all of our data in Postgres. ### 27. Rock-Solid Reliability and Data Integrity with PostgreSQL **Rating:** 5.0/5.0 stars **Reviewed by:** Sergey P. | Freelance Software Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** November 05, 2025 **What do you like best about PostgreSQL?** PostgreSQL strictly adheres to ACID principles, ensuring transactions are processed reliably even under high load or failures. Its write‑ahead logging (WAL) and crash recovery mechanisms mean data stays consistent and recoverable. **What do you dislike about PostgreSQL?** PostgreSQL’s rich feature set can overwhelm beginners. Understanding MVCC, WAL, and isolation levels requires time and effort. Configuring postgresql.conf optimally demands DBA expertise. Documentation is thorough but technical, making onboarding slower for less‑experienced teams. This complexity pays off long‑term but raises initial barriers. **What problems is PostgreSQL solving and how is that benefiting you?** Problem: Need for reliable, ACID‑compliant transactions Solution: Full ACID support with write‑ahead logging (WAL) and robust crash recovery. Benefit: I can trust data integrity even during high‑concurrency operations or system failures. Financial apps, order processing, and user account systems stay consistent without manual reconciliation. ### 28. Good Database for Web Applications **Rating:** 4.5/5.0 stars **Reviewed by:** Mahesh B. | data scientist, Mid-Market (51-1000 emp.) **Reviewed Date:** September 16, 2025 **What do you like best about PostgreSQL?** 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. **What do you dislike about PostgreSQL?** When the data is large , it is little slow and also we need maintain proper indexing for every thing. **What problems is PostgreSQL solving and how is that benefiting you?** For my analytical purpose i used the postgres , i have lots of transactional databases i used to store every data in different schemas. It is solved my datawarehousing problem for my analytics. ### 29. Open Source RDBMS **Rating:** 5.0/5.0 stars **Reviewed by:** Luca P. | Chief Operations Officer DEQUA Studio | Formerly CTO in MarTech, Marketing and Advertising, Small-Business (50 or fewer emp.) **Reviewed Date:** July 04, 2025 **What do you like best about PostgreSQL?** 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. **What do you dislike about PostgreSQL?** • 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. **What problems is PostgreSQL solving and how is that benefiting you?** PostgreSQL has provided a stable, extensible, and standards-compliant foundation for a variety of data-driven applications. The technical depth and active ecosystem have enabled me to address complex data requirements and adapt to changing project needs without being constrained by proprietary limitations or licensing models. ### 30. Robust PostgreSQL support with enterprise grade features **Rating:** 5.0/5.0 stars **Reviewed by:** Biruk T. | Sr. Database Administrator, Mid-Market (51-1000 emp.) **Reviewed Date:** May 08, 2025 **What do you like best about PostgreSQL?** 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. **What do you dislike about PostgreSQL?** 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. **What problems is PostgreSQL solving and how is that benefiting you?** PostgreSQL helps us manage large volumes of structured data reliably and securely without the high licensing costs of proprietary databases. It's solving key problems such as transactional integrity, high availability, and performance tuning for read-heavy workloads. With built-in replication features and extensions like pg_stat_statements and pg_partman, we're able to optimize queries, maintain uptime, and scale our applications more efficiently. ### 31. Postgres SQL: Great Database **Rating:** 3.5/5.0 stars **Reviewed by:** Anshu K. | Product specialist, Small-Business (50 or fewer emp.) **Reviewed Date:** September 18, 2025 **What do you like best about PostgreSQL?** It is very useful database to work with and very easy to use and can use by anyone. Simple SQL database and it is easy to Integrate. **What do you dislike about PostgreSQL?** It has more features so sometimes confuses us **What problems is PostgreSQL solving and how is that benefiting you?** To check the query live we can use postgres and run the query and check the output and it is simple database as compare with others and easy to use. ### 32. Comprehensive SQL Features That Exceed Expectations **Rating:** 5.0/5.0 stars **Reviewed by:** Chiradeep B. | Senior Software Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** November 28, 2025 **What do you like best about PostgreSQL?** The best part is the wide range of features enabling to execute complex sql queries in terms of working with function , trigger, cursor, views, materialized views and window function. **What do you dislike about PostgreSQL?** Nothing as such , everything at par my expectation. **What problems is PostgreSQL solving and how is that benefiting you?** It facilitated to analyze different data set , to derive insights from the data,and to execute complex query using Subquery, stored procedure, function, trigger, cursor and views ### 33. PostgreSQL: Excellent OLTP Performance, Fast Single-Query Speeds **Rating:** 4.5/5.0 stars **Reviewed by:** Aditya B. | Data Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** October 15, 2025 **What do you like best about PostgreSQL?** PostgreSQL is one of the best OLTP databases available. Its greatest strength is its fast single-query performance. **What do you dislike about PostgreSQL?** I find the SQL syntax used in the PostgreSQL CLI to be quite confusing, especially when compared to MySQL, which relies on more straightforward SQL commands for querying in its command-line interface as well. **What problems is PostgreSQL solving and how is that benefiting you?** Like any OLTP database, it helps to store data efficiently and it's fast reply reduces the time taken by API's to respond. ### 34. i am using this as my database since 2024 i love this product **Rating:** 5.0/5.0 stars **Reviewed by:** Akshaya K. | Member Technical Staff, Computer Software, Small-Business (50 or fewer emp.) **Reviewed Date:** July 09, 2025 **What do you like best about PostgreSQL?** we can automatically create a ER diagram of a databse with 2-3 clicks . its very easy install in my system the storage was very low and easy to integrate i use it frequently in a day . we can easily create delete and edit the tables, views etc . i mostly like the User Interface of this product. there is also a sql query writing screen which is very much useful in getting customized results and some basic views can be get by selecting the table button options it self. **What do you dislike about PostgreSQL?** when starting the pgadmin loading time was too long it takes upto 1 min to open **What problems is PostgreSQL solving and how is that benefiting you?** easy i can view the tables and data that are present ### 35. Powerful relational database easy to integrate **Rating:** 5.0/5.0 stars **Reviewed by:** Blas C. | Software Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** September 16, 2025 **What do you like best about PostgreSQL?** Offers all features you can expect from a relational database as well as a lot of features from NoSql. Easy to integrate with multiple clients. **What do you dislike about PostgreSQL?** Sometimes depending on the query the syntax is a little bit complex **What problems is PostgreSQL solving and how is that benefiting you?** Database for web applications and APIs. ### 36. Good SQL Database to handle the Relational DataBase **Rating:** 4.5/5.0 stars **Reviewed by:** Aravinth V. | Technical Lead, Mid-Market (51-1000 emp.) **Reviewed Date:** October 09, 2025 **What do you like best about PostgreSQL?** It is best to handle the RDBMS and it guarantees the Data Integrity using ACID property **What do you dislike about PostgreSQL?** It will use more resources like Memory and CPU compare to other DB **What problems is PostgreSQL solving and how is that benefiting you?** We can have backups and restore those backups using the pg_dump and pg_restore options. We have built in Full Text search option so it will be very helpful ### 37. Great Functionality, but Long Queries Can Slow Down the Database **Rating:** 4.5/5.0 stars **Reviewed by:** Arvind T. | Technical Leader, Mid-Market (51-1000 emp.) **Reviewed Date:** October 15, 2025 **What do you like best about PostgreSQL?** Support many functionalities like spatial database. **What do you dislike about PostgreSQL?** Actually postgresql used MVVM pattern and run query on core base so if any query take long time to run so it busy complete database. **What problems is PostgreSQL solving and how is that benefiting you?** So first it is open source postgis I used of this database to store the spatial data and display the map and query. ### 38. High Data integrity and complex query support with various data types choose postgres sql only **Rating:** 5.0/5.0 stars **Reviewed by:** Swapnil i. | Product Engineer, Computer Software, Enterprise (> 1000 emp.) **Reviewed Date:** September 17, 2025 **What do you like best about PostgreSQL?** We can play with many data types and we are in fintech domain so it is quite efficient in term of banking. **What do you dislike about PostgreSQL?** Sometime i need analytical processing then i lag somehow with postgre sql. **What problems is PostgreSQL solving and how is that benefiting you?** I am fintech developer and i need Higly ACID property supported system and postgres sql prove that. I did not see the breaches on my system. ### 39. Best DB workbench **Rating:** 5.0/5.0 stars **Reviewed by:** Dhiraj D. | Data Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** September 16, 2025 **What do you like best about PostgreSQL?** It's user interface is very friendly. It easily give data modification table , schema , views create scripts. **What do you dislike about PostgreSQL?** Sometimes it's crashes when we run heavy queries **What problems is PostgreSQL solving and how is that benefiting you?** It's easy query debug ..it gives error line number. ### 40. great software experience **Rating:** 4.5/5.0 stars **Reviewed by:** prathamesh s. | intern, Mid-Market (51-1000 emp.) **Reviewed Date:** September 23, 2025 **What do you like best about PostgreSQL?** NO LISCENCE COST, EASY TO HANDLE, FULL SUPPORTSFOR JOINS ,PROCEDURES AND WINDOW FUNCTIONS **What do you dislike about PostgreSQL?** HEAVY WORKLOAD, SLOWER WRITE PERFORMANCE **What problems is PostgreSQL solving and how is that benefiting you?** COMPLEX QUERY HANDLING FEATURES THATS BENEFITIARY . ### 41. very good database, a bit complicated user management **Rating:** 5.0/5.0 stars **Reviewed by:** Duvan Dario D. | Data Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** October 01, 2025 **What do you like best about PostgreSQL?** special features and integrations **What do you dislike about PostgreSQL?** role management and permission management for users **What problems is PostgreSQL solving and how is that benefiting you?** management of transactional databases ### 42. PostgreSQL: **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Accounting | Small-Business (50 or fewer emp.) **Reviewed Date:** April 30, 2025 **What do you like best about PostgreSQL?** Strong support for advanced indexing techniques like BRIN, GIN, and GiST, which optimize query performance for large datasets. Plus, its built-in JSON support makes it an excellent choice for handling semi-structured data without sacrificing relational capabilities. **What do you dislike about PostgreSQL?** Replication and clustering can be more manual compared to solutions like MySQL’s built-in replication **What problems is PostgreSQL solving and how is that benefiting you?** Using PostgreSQL in a corporate environment brings several benefits, as it addresses key challenges in data management, scalability, and performance. Reliable Data Integrity: PostgreSQL’s ACID compliance ensures transactions are processed reliably, which is crucial for maintaining consistency in business operations. Advanced Querying & Analytics: Its powerful SQL capabilities allow businesses to run complex queries efficiently, making data-driven decision-making smoother. ### 43. My Experience With PostgreSQL **Rating:** 5.0/5.0 stars **Reviewed by:** saif eddine m. | i can't tell, Enterprise (> 1000 emp.) **Reviewed Date:** February 27, 2025 **What do you like best about PostgreSQL?** What i like most about PostgreSQL is the ergonomic interface , easy to understand . **What do you dislike about PostgreSQL?** I didn't actually encounter any Problems or downsides . **What problems is PostgreSQL solving and how is that benefiting you?** Storing Data warehouses Securely ### 44. PostgreSQL Performance Insights **Rating:** 4.5/5.0 stars **Reviewed by:** Akshay P. | Data Science And Business Analytics intern, Retail, Small-Business (50 or fewer emp.) **Reviewed Date:** October 01, 2024 **What do you like best about PostgreSQL?** One of the best part is Open source, Handle large datasets, strong security, easy to use and most important community support. Also It provide advance features like: support complex qeries, Custom functions **What do you dislike about PostgreSQL?** one thing i.e. fewer GUI tools compared to other database like MySQL **What problems is PostgreSQL solving and how is that benefiting you?** It addresses the need for scalability by efficiently handling large datasets and supporting complex queries, making it ideal for big data and analytics. Additionally, PostgreSQL simplifies complex data handling with support for advanced data types like JSON and arrays, allowing businesses to manage structured and unstructured data seamlessly. ### 45. Simply an amazing tool **Rating:** 5.0/5.0 stars **Reviewed by:** Diego G. | Engineering Lead, Mid-Market (51-1000 emp.) **Reviewed Date:** November 22, 2024 **What do you like best about PostgreSQL?** It's very powerful and versatile, and has a huge ecosystem built around it. It's the de-facto solution for so many problems nowadays. **What do you dislike about PostgreSQL?** Not about PostgreSQL itself, but the fact that the major cloud providers don't keep well enough with all the latest developments **What problems is PostgreSQL solving and how is that benefiting you?** It stores all kinds and shapes of data and lets us query it in many ways ### 46. PostgreSQL: Most popular SQL DBMS Software **Rating:** 5.0/5.0 stars **Reviewed by:** NAYAN K. | Data Scientist, Mid-Market (51-1000 emp.) **Reviewed Date:** July 26, 2024 **What do you like best about PostgreSQL?** Simple and Easy to use. I really like the PG admin UI which is really very user friendly. Installed and Builder stack are easy to implement. Can connect with Python with ease. I use it frequently for my day to day RDBMS use. Canbe easily integrated with python. **What do you dislike about PostgreSQL?** There should be some more extensions with widely used open source software/apps. **What problems is PostgreSQL solving and how is that benefiting you?** RDBMS Application and Easy to use PG admin UI which can be easily integrated with Python for my data science projects. ### 47. Integrating Cube analytics in Postgresql **Rating:** 5.0/5.0 stars **Reviewed by:** CHIRADEEP B. | Associate Technology, Enterprise (> 1000 emp.) **Reviewed Date:** May 18, 2024 **What do you like best about PostgreSQL?** Very easy to use and set up PostgreSQL comes with a very easy to use UI ( User Interface ) tool like PG-Admin for every client to connect & Interact with the database. PG Admin is very easy to use & setup with just a mouse click unlike other traditional RDBMS . I highly recommend PostgreSQL for every client to connect & Interact, apart from MYSQL. **What do you dislike about PostgreSQL?** Nothing as such, sometimes query execution get delayed but that is very rare. Overally its a very light-weight & user friendly tool for ervery client who want to connect with the database seamlessly. I **What problems is PostgreSQL solving and how is that benefiting you?** It enables me to check transcation count of every user, enables all trigger , procedures, function and other PL/SQL operation seamlessly. It also helps to perform and execute multiple joins operation in the event of requirement of data from multiple table to retrieve the result. Postgresql also enables aggregate function( MIN, MAX, AVG, COUNT, SUM, AVG) and views, cursor, Index. ### 48. PostgreSQL : user review **Rating:** 5.0/5.0 stars **Reviewed by:** Ashwini B. | Software Developer, Small-Business (50 or fewer emp.) **Reviewed Date:** April 23, 2024 **What do you like best about PostgreSQL?** PostgreSQL is easy to use in daily development life. Developer can easily implement and integrate it into system by using gem postgres. It has different versions for operating system. It is open source relational database model and i can use it in operating system like window , ubuntu, mac ect. Most of the developer use it frequently. **What do you dislike about PostgreSQL?** When i execute large data query or complex query application stop responding. It has enormous number of users so customer support may take time to resolve query. **What problems is PostgreSQL solving and how is that benefiting you?** Its make my devlopment process smooth. It help to store users , orders data of my application, which help me to analyze data of users. Also i can hit complex queries to fetch data. It store tremendous data into it. ### 49. PostgreSQL is robust database to rely on. **Rating:** 4.5/5.0 stars **Reviewed by:** Aavinashh L. | Manager Dashboards and Business Intelligence , Enterprise (> 1000 emp.) **Reviewed Date:** October 13, 2024 **What do you like best about PostgreSQL?** Its wonderful DBMS that has wide range of extentions and relaibiility features with great customer support **What do you dislike about PostgreSQL?** It has one feature that needs improvement on resources useage as it uses lots of your system resources. **What problems is PostgreSQL solving and how is that benefiting you?** Its very trusted RDBMS and give me comfort on using it for day to day operational load without getting worried. ### 50. It has the most intuitive UI **Rating:** 4.5/5.0 stars **Reviewed by:** Rodrigo A. | Media Activation Manager, Mid-Market (51-1000 emp.) **Reviewed Date:** September 27, 2024 **What do you like best about PostgreSQL?** It's super easy to understand, implement, and adapt to any data lake. PostgreSQL has implemented many features to facilitate joint and data selections **What do you dislike about PostgreSQL?** I can't complain about anything about postgreSQL **What problems is PostgreSQL solving and how is that benefiting you?** Storing data, data relations, and Data Processing. Connect with Power Bi is a great feature ## 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 - [View PostgreSQL pricing details and edition comparison](https://www.g2.com/products/postgresql/reviews?section=pricing&secure%5Bexpires_at%5D=2026-05-16+02%3A19%3A30+-0500&secure%5Bsession_id%5D=af588aca-cc54-4029-9183-6db4fb7ba8b3&secure%5Btoken%5D=de28d3f4f44d4f5c6b966dc19e90a0e236475053c94090a5650a1af84e423925&format=llm_user) ## PostgreSQL Integrations - [Amazon Redshift](https://www.g2.com/products/amazon-redshift/reviews) - [Angular](https://www.g2.com/products/angular-dev-angular/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) - [Entity Framework Core](https://www.g2.com/products/entity-framework-core/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) - [Microsoft Power BI](https://www.g2.com/products/microsoft-microsoft-power-bi/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) - [Omnis Studio](https://www.g2.com/products/omnis-studio/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,112 reviews) - [MySQL](https://www.g2.com/products/mysql/reviews) - 4.4/5.0 (1,575 reviews) - [Oracle Database](https://www.g2.com/products/oracle-database/reviews) - 4.3/5.0 (927 reviews)