--- title: PostgreSQL Reviews meta_title: 'PostgreSQL Reviews 2026: Details, Pricing, & Features | G2' meta_description: Filter 684 reviews by the users' company size, role or industry to find out how PostgreSQL works for a business like yours. aggregate_rating: rating_value: 4.4 review_count: 684 scale: '5' date_modified: '2026-08-07' parent_category: name: Database Software url: https://www.g2.com/categories/database-software --- # PostgreSQL Reviews **Vendor:** PostgreSQL **Category:** [Relational Databases](https://www.g2.com/categories/relational-databases) **Average Rating:** 4.4/5.0 **Total Reviews:** 684 ## 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 praise PostgreSQL for its **reliability and extensive feature set** , enhancing both performance and user experience. (16 reviews) - Users value the **ease of use** of PostgreSQL, appreciating its integration capabilities and straightforward setup. (13 reviews) - Users value the **reliability and flexibility** of PostgreSQL, praising its powerful features and open-source advantages. (10 reviews) - Users highlight the **incredible reliability** of PostgreSQL, praising its performance, ACID compliance, and data integrity. (10 reviews) - Users applaud the **scalability** of PostgreSQL, appreciating its ability to adapt to both small and large projects effortlessly. (10 reviews) - Users value the **flexibility** of PostgreSQL, appreciating its customization and adaptability for diverse project needs. (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, with a steep learning curve and complex configuration requirements. (7 reviews) - Users find the **complexity** of PostgreSQL's management tasks and SQL syntax to be challenging compared to simpler databases. (6 reviews) - Users face a **steep learning curve** with PostgreSQL, complicating onboarding and requiring significant time to master. (5 reviews) - Users experience **slow performance** with large databases and complex queries, impacting their overall satisfaction. (5 reviews) - Users find the **complex configuration** of PostgreSQL challenging, particularly 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. 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. ### 2. 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. ### 3. 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. ### 4. 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. ### 5. 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. ### 6. A great open source database **Rating:** 4.0/5.0 stars **Reviewed by:** Henry C. | Mid-Market (51-1000 emp.) **Reviewed Date:** December 19, 2023 **What do you like best about PostgreSQL?** I think it is really well documented, you can find lots of free tutorials en webpages and youtube. You can configure it to fit your requirements. It also has a lot of functionalities, I think it is one of the most advanced databases available right now. You can integrate PostgreSQL with a lot of different tools, and it provides great advantages for your use. **What do you dislike about PostgreSQL?** It can be a little tricky for starters, because the inital configuration can be a little cumbersome, but I think it is not a big deal since you have support online where you can find a lot of tutorials. **What problems is PostgreSQL solving and how is that benefiting you?** Some of our databases are running using PostgresSQL as engine. We use them through RDS in AWS. ### 7. A great free and open source RDBMS tool for your database needs **Rating:** 4.0/5.0 stars **Reviewed by:** Ashish A. | QA Engineer, Computer Software, Small-Business (50 or fewer emp.) **Reviewed Date:** September 25, 2023 **What do you like best about PostgreSQL?** - It's an open source and free platform for creating and managing relation databases, we used this for all our RDBS needs and since we are a start-up it saved a lot of cost for us in terms of being free and open source. - It's easy to use and syntactically similar to popular databases like SQL and it helps anyone in the term to learn and quickly adept. -It's easy to setup even if you are using this on a Google cloud, just do a SSH and you will be able to connect to the postgres instance. **What do you dislike about PostgreSQL?** The default user interface is not very feature rich and keeps disconnecting after some session time, there are tools which can be used deparately but if PostgreSQL can improve their user interface it'll be lot better. Even though I am used to command line tool. **What problems is PostgreSQL solving and how is that benefiting you?** - We are using it to store all our user data, catalog data and analytics in the DB. So we are solving the problem of storage, and being free and open source it gives us more flexibility to use (without costing us any money) - This data is then passed on to the NOSQL DB like Bigquery - We also use Postgres to load data which is shared by the external business vendors like catalog data providers ### 8. An opensource and reliable DB with essential functionalities **Rating:** 4.0/5.0 stars **Reviewed by:** Jainesh K. | Senior Software Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** August 31, 2023 **What do you like best about PostgreSQL?** - It's open-source which means without paying a penny we can leverage a variety of database features with regular improvements and bug fixes provided by community members. - It's a scalable database that can be used for a variety of applications. -Its JSONB support makes It easier to work with JSON types and we can work on relational as well as non-relational data on the same system. - Full text search feature is also provided by PostgreSQL which can help in a variety of applications. **What do you dislike about PostgreSQL?** - There are some opensource apps that might not support PostgreSQL but MySQL because It is not owned by a single entity and hence lacks the recognition It deserve. - Might not be a good solution for the shared dataset as there is no out of the box approach available for it in PostgreSQL. - It might have a steep learning curve for beginners. **What problems is PostgreSQL solving and how is that benefiting you?** - Using relational and non-relational data on the same system as It handles JSON data type very gracefully thanks to JSONB. - It can significantly help in improving your application cost as Its available free of cost. - Works well with large data/applications as well. - Strong support from a larger developers community makes It reliable and easy to use. ### 9. Great services and simple db to use **Rating:** 4.0/5.0 stars **Reviewed by:** Kaustubh K. | Devops Engineer, Computer Software, Mid-Market (51-1000 emp.) **Reviewed Date:** August 24, 2023 **What do you like best about PostgreSQL?** PostgreSQL is open source database management solution. For SQL queries, it supports both SQL and JSON. Also we can use complex data types and performance optimisation tools that we would normally only find in pricey commercial databases. And as per the develoeprs view we can create custom data types , functions and all and if configured correctly , we can perform complex data operation , recursive queries and many more. **What do you dislike about PostgreSQL?** If we talk. About the speed then mysql is works beeter in that but PostgreSQL works more on compatibility. And also just one thing that many open source application support needs to be given in PostgreSQL.to add this just one thing if it is not configured correctly , it can give issues while optimisation. **What problems is PostgreSQL solving and how is that benefiting you?** I've used that in web apps and websites.As it is open source so we can use it it without any limitation without any restrictions.Also I didn't get too much of training to use PostgreSQL. As it is very easy to use. ### 10. manage high volume of data and support RDBMS **Rating:** 4.0/5.0 stars **Reviewed by:** Manthan V. | SDE-2 Frontend Developer , Mid-Market (51-1000 emp.) **Reviewed Date:** June 09, 2023 **What do you like best about PostgreSQL?** => SQL database => Open-source database it means we can do customization and get community support => Easy to manage large volumes of data => Allow creating custom data types, operators, events and function => Large community so you can solve you problem fast => Provide jsonb data type for store json data **What do you dislike about PostgreSQL?** => database is based on project and requirement so if your project is small then I suggest use MongoDB => Need the training to understand database functionality => Need more storage and computing power to execute query **What problems is PostgreSQL solving and how is that benefiting you?** => Allow writing complex queries so we can get more meaningful full data in a single query instead of executing multiple queries => Multiple users can access the DB in the same time without any issue so its not block users => Create custom type, event, functional, and operator it means base on requirements we can create and reuse instead of writing custom logic ### 11. Best open source relational database for geo location and data migration **Rating:** 3.5/5.0 stars **Reviewed by:** Ankit A. | Senior Technical Consultant Database, Enterprise (> 1000 emp.) **Reviewed Date:** February 10, 2023 **What do you like best about PostgreSQL?** What I like most about PostgreSQL is its open source. Being an open-source relational database, it also provides value to the customer and their users in terms of fast and internal precalculated libraries and functions that help developers and users retrieve data fastly without any hurdle. Postgresql is also helping us with fast query execution and efficient use of memory. **What do you dislike about PostgreSQL?** Being an open-source relational database, the area of improvement is its inability to handle large-volume database application support. Another thing is its limited community or ecosystem compared to premium databases like oracle and SQL servers. The query execution explanation plan is also not good in PostgreSQL. Postgresql does not have any run-time debugger, so some time to hard to find the error's root cause. **What problems is PostgreSQL solving and how is that benefiting you?** Postgresql provides a relational database system that is helping startups and developers to learn databases and adopt new technologies that can't pay licensing fees. It helped me to generate a geo-tagging platform that required a fast and accurate lat-long calculation that couldn't be completed without the PostgreSQL / PostGIS. Postgresql helped me to learn how we could integrate json with RDBMS. ### 12. Great database system to use for beginners. **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** January 01, 2024 **What do you like best about PostgreSQL?** Very reliable tool to use and easy to understand plus its consistent and also adapts to changing infrastructure in the market. **What do you dislike about PostgreSQL?** The documentation is very dense which is nit easy to understand by beginners. **What problems is PostgreSQL solving and how is that benefiting you?** It helped to solve the business queries and business cases and it can also deal with a wide range of data types including specialised ones. ### 13. The most powerful, feature-rich open-source relational database management system **Rating:** 4.0/5.0 stars **Reviewed by:** Paresh K. | Junior Software Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** February 22, 2023 **What do you like best about PostgreSQL?** The main plus point about PostgreSQL is that it's an open-source R-DBMS that is very reliable, making it a first choice for startups and other organizations. Also, it has gained a high reputation for its high performance while handling high volumes of datasets very efficiently. **What do you dislike about PostgreSQL?** One thing I feel that's a downside in PostgreSQL is that its GUI functionality is very limited and not that user-friendly, making it challenging for first-timers to use its complete functionalities, especially when they are not used to the command-line interface. **What problems is PostgreSQL solving and how is that benefiting you?** PostgreSQL helped us while working on a web application as the backend database management system, which was built on top of Java the main reason I chose this was that it was open-source and had a vast community, which was needed when we got stuck in some problem. Also because of the flexibility and its performance, it was the best option for us. ### 14. PostgreSQL in my eye **Rating:** 4.0/5.0 stars **Reviewed by:** Ayesh N. | Senior Software Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** September 18, 2023 **What do you like best about PostgreSQL?** Since this is an open-source product, this really helps with day-to-day database development. **What do you dislike about PostgreSQL?** I don't really like the user interface, compared to other popular products like SSMS. Sometimes the UI lags. **What problems is PostgreSQL solving and how is that benefiting you?** Overpriced services. ### 15. Solid and reliable performance **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Marketing and Advertising | Mid-Market (51-1000 emp.) **Reviewed Date:** May 19, 2023 **What do you like best about PostgreSQL?** For the most part PostgreSQL performs well and does not catch you out too often. Various tuning options and ways to analyse performance so is not too tricky to keep it working well as you scale vertically. **What do you dislike about PostgreSQL?** Lack of horizontal scaling options in the market make it tricky once you've either exhausted vertical scaling or are encountering issues with multiple read replicas. **What problems is PostgreSQL solving and how is that benefiting you?** Need somewhere to store transactional data and that is what it does best ### 16. PostgreSQL Review **Rating:** 4.0/5.0 stars **Reviewed by:** Mubeen A. | SOC - Security Engineering Lead, Mid-Market (51-1000 emp.) **Reviewed Date:** December 12, 2022 **What do you like best about PostgreSQL?** PostgreSQL is a very robust and tested relational database known for its simple implementation and great features like fault tolerance, self recovery and detailed logging capabilities. **What do you dislike about PostgreSQL?** It is a very old relational database which is not very efficient, it has not aged well and the current technology relevance is very limited. It is slow, not compatible with modern applications and lacks proper support and documentation. **What problems is PostgreSQL solving and how is that benefiting you?** PostgreSQL is part of ArcSight, one of the SIEM solutions we currently use. It is light-weight, easy to use and serves the purpose as there is no much operational overhead. ### 17. More memory usage for complex queries **Rating:** 3.5/5.0 stars **Reviewed by:** Shrijaya S. | Mid-Market (51-1000 emp.) **Reviewed Date:** April 05, 2023 **What do you like best about PostgreSQL?** Ease of use and too many features. Like the varchar limit is way more than we have in oracle **What do you dislike about PostgreSQL?** It uses too much memory for processing complex queries **What problems is PostgreSQL solving and how is that benefiting you?** Its helping us store data for our web application. ### 18. Best open-source and easy to setup RDBMS **Rating:** 4.0/5.0 stars **Reviewed by:** Ashutosh O. | Project Manager, Enterprise (> 1000 emp.) **Reviewed Date:** October 23, 2022 **What do you like best about PostgreSQL?** Easy to use, setup and secure database. We are using it for our Secure Java based application since many years. Multi application Integration and deployment is very easy, secure and fast. **What do you dislike about PostgreSQL?** Sometimes it is difficult to extract or modify multilevel json data due to syntax. It takes losts of space when deal with json data. Some open-source application doesn't support postgresql. It is slower as compared to mysql. **What problems is PostgreSQL solving and how is that benefiting you?** We are using PostgreSQL for multiple dynamic websites and web apps as java stack option. We are using it for heavy spatial data. Easy to use quick fetching and secure. Great community for quick support. ### 19. Thinking about prod go for PostgreSQL **Rating:** 4.0/5.0 stars **Reviewed by:** ajay k. | Backend Software Developer, Small-Business (50 or fewer emp.) **Reviewed Date:** December 30, 2022 **What do you like best about PostgreSQL?** PostgreSQL works awesome in production environments. It's secure and scalable relational database. **What do you dislike about PostgreSQL?** PG store data in storage in it's own cluster which means you also have to keep eyes on directory space. **What problems is PostgreSQL solving and how is that benefiting you?** Production scalability and secure easily managed by this database. Admin interface is nice. ### 20. Better to Use SQL in new technology **Rating:** 4.0/5.0 stars **Reviewed by:** Sunil P. | Sr Database Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** August 11, 2022 **What do you like best about PostgreSQL?** PostgreSQL is helpful in getting aggregate functionality using different predefined functions like string_to_agg(), json aggregate **What do you dislike about PostgreSQL?** Not a such as of now i found yet. Something can be better for output and message in proper way to handle running queries. **What problems is PostgreSQL solving and how is that benefiting you?** PostgreSQL is used to solve a business problem by aggregating into a different way to send output to the requestor ### 21. PostgreSQL Review **Rating:** 4.0/5.0 stars **Reviewed by:** Mashmuma Q. | Lead Data Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** April 20, 2022 **What do you like best about PostgreSQL?** PostgreSQL is a good option as an object-related database since it's free it is very convenient for us to request management to use it. One can use it for data storage and analysis both. **What do you dislike about PostgreSQL?** Some features are missing which we can find in other database systems. If I compare MYSQL and PostgreSQL in terms of optimization help through explain plan than MYSQL provides a more readable way than Postgre, after reading the MYSQL plan one can change its query to optimize it very easily while it's a bit difficult in Postgre explain plan. **What problems is PostgreSQL solving and how is that benefiting you?** I'm using it for data storage and data analysis both. ### 22. Very simple and clean UI **Rating:** 4.0/5.0 stars **Reviewed by:** Saurabh K. | Software Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** May 09, 2022 **What do you like best about PostgreSQL?** PostgresSQL has very clean UI and very simple to use. Anyone can open multiple tabs. Developer can write custom queries in it. It is unique sql software for developers. **What do you dislike about PostgreSQL?** PostgresSQL sql is not very famous and it is not used by many companies. But it deserves to be part of every company. PostgresSQL can more work on its UI. So that it would be competitive in the market. **What problems is PostgreSQL solving and how is that benefiting you?** It is quite a useful application to run any query without writing any line. By its UI structure we can easily select the command by the help of mouse. It is increases the performance as well. ### 23. Postgresql - the object relational database system **Rating:** 3.5/5.0 stars **Reviewed by:** Priya B. | Senior Software Engineer| Business Intelligence Developer, Enterprise (> 1000 emp.) **Reviewed Date:** May 10, 2022 **What do you like best about PostgreSQL?** Postgresql is a flexible relational database solution for transactional/statistical data and can also be used as a NoSQL solution. Postgresql has the best capabilities for handling spatial data. **What do you dislike about PostgreSQL?** Postgresql database management system requires expertise and has certain limitations using it in the cloud. Also, cost and time are the two biggest challenges to be aware of when adopting this database. **What problems is PostgreSQL solving and how is that benefiting you?** Postgresql for dynamic websites and web apps. PostgreSQL source code is freely available under an open-source license. This allows you the freedom to use, modify, and implement it as per your business needs. ### 24. Known for Performance, Easy management & Schema Control **Rating:** 4.0/5.0 stars **Reviewed by:** Tabassum K. | Senior Data Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** March 24, 2022 **What do you like best about PostgreSQL?** I liked this database because of easily schema control and very robust to setting the process, it is also less risky and hard to break out the security layers. Features like multi-inversion concurrency control help in fluid changes to be made to the system. data management is also very easy. **What do you dislike about PostgreSQL?** As such no disadvantages at all but we need to take care of so many things at the time of implementation. It could be improved by using parallization and need distributed computing. **What problems is PostgreSQL solving and how is that benefiting you?** I implemented one of the projects where I used Postgre SQL database for the storing of relational data. It didn't associate with any cost so was easy to implement the project without any pressure. ### 25. Open source SQL DB **Rating:** 4.0/5.0 stars **Reviewed by:** Rahul S. | Software Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** August 22, 2022 **What do you like best about PostgreSQL?** It is open source and support all SQL Operations. **What do you dislike about PostgreSQL?** I think there are not much to dislike about. **What problems is PostgreSQL solving and how is that benefiting you?** It helps in storing tabular data. ### 26. A friend of any application **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Enterprise (> 1000 emp.) **Reviewed Date:** September 04, 2022 **What do you like best about PostgreSQL?** Object relative, good expanding,nice features, open source and large community **What do you dislike about PostgreSQL?** Sometimes it takes more time, opensource it is a disadvantage at the same time **What problems is PostgreSQL solving and how is that benefiting you?** Object oriented data storage is easy handling with our application, easly interfere with external languages python ### 27. User-friendly Database **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** June 15, 2022 **What do you like best about PostgreSQL?** Postgres database gives us more and more column fields that are very useful, like uuid and boolen, that other database doesn't provide. **What do you dislike about PostgreSQL?** It is very slow compare to other databases like Oracle, MySQL, etc. **What problems is PostgreSQL solving and how is that benefiting you?** Postgres stores the data of the organisation or a software that is used in companies. ### 28. PostgreSQL Review **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** June 10, 2022 **What do you like best about PostgreSQL?** PostgreSQL provides us much more Datatypes that are not present in Oracle or Mysql **What do you dislike about PostgreSQL?** It is slow as compared to Oracle Database **What problems is PostgreSQL solving and how is that benefiting you?** I manage data of the systems that I develop ### 29. Found helpful for storing large transactional logs **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Enterprise (> 1000 emp.) **Reviewed Date:** February 12, 2022 **What do you like best about PostgreSQL?** PostgreSQL was a cost effective option to choose from RDBMS. It was easy to configure and get setup. As it is similar to other RDBMS in market so learning this by other team members was not complicated. **What do you dislike about PostgreSQL?** We want to move some of our workloads from other RDBMS to Postgres, but couldn't find any suitable tool. Also, some dashboard to see the health and statistics of Server, DB and table would be helpful. **What problems is PostgreSQL solving and how is that benefiting you?** We wanted some way of storing our large logs that are generated frequently and also wanted to query them when needed. So we choose Postgres and it has met our needs and we are also using it to generate dashboards of those logs. ### 30. Great scalable db for small and large project **Rating:** 4.0/5.0 stars **Reviewed by:** Sagar D. | Software Architect and developer, Small-Business (50 or fewer emp.) **Reviewed Date:** June 21, 2021 **What do you like best about PostgreSQL?** I like how this database could handle extensive data and small data. I have been using it for lots of small projects as well as for large project that handles data processing and event-driven projects. It's good to see such flexibility in heavily read-write processes. **What do you dislike about PostgreSQL?** What I dislike about it is the GUI to handle all the operations are not that user-friendly compared to what mongo DB or MySQL has. I wonder if the Postgres team gets to have some good UI UX for postgres as well. **Recommendations to others considering PostgreSQL:** GUI for managing Postgres is a bit complicated, and you should continue considering that you might have some bad experience with Postgres. Other than that, Postgres is excellent if you have huge read and write operations. **What problems is PostgreSQL solving and how is that benefiting you?** I am using PostgresSQL on heavy read write application, and analytics project for huge data. Along with that working on projects for small scale project general management project. The main benefit that I saw with using PostgreSQL is that its good for small and large project. I could use the same db server for large project while development and also small projects as well without having to thinking much on performance changes for small and large project. ### 31. PostgreSQL is open source for all OS **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** February 08, 2022 **What do you like best about PostgreSQL?** PostgreSQL is open source, and we can use it in any OS like Windows, Linux, etc. **What do you dislike about PostgreSQL?** A stored procedure is not fully supported here, and we can not return a dynamic table. Also, his output window returns only a single query result. **What problems is PostgreSQL solving and how is that benefiting you?** With PostgreSQL and dot Net Core, we have built health care products, and because of his multi-support features, we can run our application into many OS ### 32. PostGreSQL Developer Experience **Rating:** 4.0/5.0 stars **Reviewed by:** Naveed A. | Angular & React Developer, Small-Business (50 or fewer emp.) **Reviewed Date:** April 20, 2022 **What do you like best about PostgreSQL?** The relations among the tables to avoid duplicate data **What do you dislike about PostgreSQL?** Limited JSON data support therefore we need many number of tables **What problems is PostgreSQL solving and how is that benefiting you?** ERP issues by using DB in a relational way ### 33. Performance packed database **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** April 22, 2022 **What do you like best about PostgreSQL?** When you think about the performance of a database and it's robustness postgresql is the best option. **What do you dislike about PostgreSQL?** Pg admin should be simplified,some times split windows are too crowded to look at. **What problems is PostgreSQL solving and how is that benefiting you?** As the system gets bigger the queries got complicated then postgresql is game changer. Data analysis is also a great boost to system. ### 34. Good database for django **Rating:** 4.0/5.0 stars **Reviewed by:** adwaith p. | Python Developer, Mid-Market (51-1000 emp.) **Reviewed Date:** October 26, 2021 **What do you like best about PostgreSQL?** It is very simple to use. It is easy to use for a begginer compared to xamp **What do you dislike about PostgreSQL?** In some hosting platforms postgresql have payment to use **What problems is PostgreSQL solving and how is that benefiting you?** Postgresql solved the need of simple and effective database system It is easy to use. It can be studied very fastly ### 35. Powerful RDBMS **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Hospital & Health Care | Enterprise (> 1000 emp.) **Reviewed Date:** March 29, 2022 **What do you like best about PostgreSQL?** Opensource DB, Highly Secure, Stability, Scalability, Highly performance-oriented. **What do you dislike about PostgreSQL?** Data compression, Columns reordering, its default availability on all hosts. **What problems is PostgreSQL solving and how is that benefiting you?** We use this as a relational database management system for enterprise applications. ### 36. PostgreSQL - Advanced open source database **Rating:** 3.5/5.0 stars **Reviewed by:** Animesh K. | Technical Test Lead (ABC Financials), Enterprise (> 1000 emp.) **Reviewed Date:** April 20, 2021 **What do you like best about PostgreSQL?** Easy Installation and Configuration, supports multi-platforms like Windows, macOS, Linux, use existing applications. Highly reliable open source RDBMS. Lots of features compared to its competitors. **What do you dislike about PostgreSQL?** Lacks schema versioning, Parallel data query, Feels lacking in performance compared to competitors especially in writing to the database. Postgre upgrade from 9 to 10 was not that great, there was a lot of downtime. Lacks in-memory modes. Less documentation which may be impediment to new users. **Recommendations to others considering PostgreSQL:** PostgreSQL is best suited for small and medium development projects. While there is a bit of a learning curve compared to MySQL and SQL server, which may be an issue for the beginner but if you are an experienced software developer or database admin, it is almost perfect for you. It provides broad feature sets, which are handy for incremental development. The best part is it's free, so it is a cheap and almost equal alternative to SQL Server since you need to pay a lot for licensing costs of SQL Server for businesses and enterprises. **What problems is PostgreSQL solving and how is that benefiting you?** I work as a consultant and we work on providing technical solution to our clients. We suggested PostgreSQL to one small company we were working with. I believe PostgreSQL is best suited for smaller and medium sized development project. Since this is open source, it has all the features which are needed for smaller and medium development project. This is also easy to administrate. Postgres has an incredibly flexible and simple-to-use user/role management system. Postgres usage is increasing in the industry and I believe its market share has increaed to 6% lately. It is really easy to integrate PostgreSQL into our stack. Because of high adoption rate, hiring a developer to implement or service Postgres is easy. Most of the major database libraries of common web frameworks are out there like Rails - ActiveRecord, Spring-Hibernate, Play Scala-Slick. These libraries have out of the box Postgres support, thus no extra configuration is needed for our web applications to read or write to PostgresSQL. ### 37. Good Database to integrate with Go **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.) **Reviewed Date:** February 04, 2022 **What do you like best about PostgreSQL?** - Querying time is considerably faster - Free and open-source database - Easy to install and configure **What do you dislike about PostgreSQL?** - Consumes somewhat higher CPU usage so that efficiency is a bit low **What problems is PostgreSQL solving and how is that benefiting you?** - Using the database with a Go API - Database used for Enterprise application ### 38. Excellent for complex data queries **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Computer & Network Security | Small-Business (50 or fewer emp.) **Reviewed Date:** November 01, 2021 **What do you like best about PostgreSQL?** Highly compliant with SQL standards, able to handle large complex queries. Supported by the majority of platforms such as Amazon Redshift and DynamoDB. Great for application data processing. **What do you dislike about PostgreSQL?** Slow process speed, not a good fit for real-time data processing **What problems is PostgreSQL solving and how is that benefiting you?** Largely complex data queries, ROR used PostgreSQL as a backend database. ### 39. A friendly Database **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Insurance | Enterprise (> 1000 emp.) **Reviewed Date:** January 04, 2022 **What do you like best about PostgreSQL?** Is a good database for non-critical applications that required less level of effort for administration and support. **What do you dislike about PostgreSQL?** At the moment i do not find any dislike whatsoever **What problems is PostgreSQL solving and how is that benefiting you?** Some applications were using SQL Express and with his limitation, on some occasions the application start crashing because the database was full, performance issues, etc. ### 40. PostgreSQL Review **Rating:** 4.0/5.0 stars **Reviewed by:** Elizabeth J. | Software Developer, Information Technology and Services, Mid-Market (51-1000 emp.) **Reviewed Date:** December 29, 2020 ### 41. Easy to use - Nice and provided feeling of organization **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Airlines/Aviation | Enterprise (> 1000 emp.) **Reviewed Date:** October 11, 2021 **What do you like best about PostgreSQL?** Felt organized, easy to understand and to use. Could keep several databases within eyes reach **What do you dislike about PostgreSQL?** Occasional technical glitches, brief learning curve before becoming fluent with their system **What problems is PostgreSQL solving and how is that benefiting you?** Being able to use SQL to find business solutions and automatically store useful data in a database ### 42. PostgreSQL Review **Rating:** 3.5/5.0 stars **Reviewed by:** Atul F. | sql, Enterprise (> 1000 emp.) **Reviewed Date:** December 28, 2020 ### 43. Best relational database system choice for new app developers **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Financial Services | Enterprise (> 1000 emp.) **Reviewed Date:** May 04, 2021 **What do you like best about PostgreSQL?** The performance of the database is topnotch relating to transactions, concurrency and schema controls **What do you dislike about PostgreSQL?** It is diffcult to resolve issues/errors as a lot of documentation is not available around this **Recommendations to others considering PostgreSQL:** There are a lot of tools for coverting other SQL scripts to prostgreSQL scripts. So if you are looking to switch it's not that diffcult. Also it will significantly reduce your cost **What problems is PostgreSQL solving and how is that benefiting you?** We tried to find a low cost alternative db system for a client. So we moved from Oracle to prostgreSQL. This brought the cost down substantially ### 44. PostgreSQL **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Education Management | Enterprise (> 1000 emp.) **Reviewed Date:** March 30, 2021 **What do you like best about PostgreSQL?** The cost point on PostgreSQL is significantly better than the big guns like Oracle. **What do you dislike about PostgreSQL?** I don't think this is as redundant a solution or as high capacity as other databases. **What problems is PostgreSQL solving and how is that benefiting you?** I wouldn't say that we're solving problems with it, but it met our need for a database at reduced cost. ### 45. Great To Manage Multiple Databases **Rating:** 4.0/5.0 stars **Reviewed by:** zahit B. | BI & DWH Consultant, Mid-Market (51-1000 emp.) **Reviewed Date:** November 18, 2019 **What do you like best about PostgreSQL?** I think PostgreSQL is a good Enterprise Class data management. It has good amount of features like integration, migration, flexible deployment options, has good tool kits for management. We've almost about 10+ databases including master and managing them via PostgreSQL is very easy. One good thing with PostgreSQL is that we can have multiple databases in single server and having different configurations for them. Overall we are most satisfied with PostgreSQL and their services. **What do you dislike about PostgreSQL?** Ability to have multiple databases on single server. Having database users which are permission based Integration between multiple databases. **What problems is PostgreSQL solving and how is that benefiting you?** Max connection timeouts are too frequent. Much frequently we do see problems like queries are in waiting status and goes idle after some time. We had to manually kill those transactions.I can't say the technical support team is very good ### 46. Best scalable and stable RDBMS i ever use **Rating:** 4.0/5.0 stars **Reviewed by:** Andy Larry R. | Informaticien études et développement, Small-Business (50 or fewer emp.) **Reviewed Date:** September 27, 2019 **What do you like best about PostgreSQL?** - A very scalable data management system with powerful tools to exploit data - A strong stability when execute complex request (trigger, ) and long term data archive - A great stability for data storage, no data corrupted, no crash, it can store big data - Open source and free, you can deploy PostgreSQL anywhere and anytime with sevral users as you want - Very best support team with community **What do you dislike about PostgreSQL?** - You must regularly execute autovacuum to insure performance - It 'is a little complicated to implement logshipping master/slave clusterization - Not as speed as Mysql for data selection (SELECT) - Detailed documentation only available in English version **What problems is PostgreSQL solving and how is that benefiting you?** - I use PostgreSQL for projects which need a strong stability in data storage like banking transaction management, employee salary management and others, with PostgreSQL, you insure data availability. - I also use PostgreSQL for business intelligence projects because it support complex SQL request mix with triggers and stored procedure which are powerful tools for making strong data analysis. ### 47. Good database system, worth learning and implementation is easy with PostgresSQL **Rating:** 4.0/5.0 stars **Reviewed by:** Javed A. | Head of Technology, Small-Business (50 or fewer emp.) **Reviewed Date:** September 24, 2019 **What do you like best about PostgreSQL?** Features in Postgres are equivalent to Oracle RDBMS, although some of the features like JSON support were not present till Oracle 11g which is a part of PostgresSQL. Documentation is extensive and easily available. **What do you dislike about PostgreSQL?** PGAdmin can be made more user-friendly like search for specific keyword for existing database objects like table or function name which is not available. **Recommendations to others considering PostgreSQL:** PostgresSQL is a complete database which can be used to build an application for any mid-size organization. Postgres documentation is easily available and one of the best databases I have ever worked. **What problems is PostgreSQL solving and how is that benefiting you?** After working on Oracle for almost a decade, moving to Postgres SQL was very easy and we are using Postgres database within the organisation to develop an application database and interface is built on Microsoft technologies. ### 48. RDBMS For Everyone! **Rating:** 3.5/5.0 stars **Reviewed by:** Alonso C. | Developer, Apparel & Fashion, Enterprise (> 1000 emp.) **Reviewed Date:** August 31, 2019 **What do you like best about PostgreSQL?** It's free. Done! The best of something is when you get what you want without paying, this is the case of PostgreSQL. There will be a time when you need to create an application/software, and no matter if it will be used for 5 or 1000 users, different geographic locations, you will get an easy setup, strong documentation and a great community behind PostgreSQL. Finally, it is a multi-platform software, so you can have multiple instances either in linux or windows, it comes down to your personal preference, personally, I always use Debian and I haven't ever had any big issue. **What do you dislike about PostgreSQL?** Replication process. Last time I checked, I had to use Slony or something outside PostgreSQL to accomplish this process. I would like that there would have been a way to do it native n the core of PostgreSQL. Also, the documentation is really strong, you will find it quick and easy and in a really neat way, but I would like that it was more easy to read, maybe it's just me, but I like for example the way ReactJS documentation is made, I believe that it gives you a clear idea without using weird and rare words. **Recommendations to others considering PostgreSQL:** At least try it, you won't regret it. **What problems is PostgreSQL solving and how is that benefiting you?** Basically, not paying and Enterprise expensive license for our company, I work in a small manufacturing company, and the IT department is not the one who gets more money to improve the infrastructure, but having PostgreSQL it gives us more margin to improve in other areas, for example, servers, security, and professional growth through buying courses on line. . ### 49. Best opensource database **Rating:** 3.5/5.0 stars **Reviewed by:** Vasu G. | R&D Engineer, Information Technology and Services, Enterprise (> 1000 emp.) **Reviewed Date:** August 19, 2019 **What do you like best about PostgreSQL?** PostgreSQL supports json data and transaction control that helps in development of modern complex web apps. Also, pgadmin built in support for dump backup is an important feature for critical applications. PgAdmin is good tool for managing and viewing database data along with support for complex SQL queries. **What do you dislike about PostgreSQL?** The PostgreSQL has some rigid migration rules while updating the database that can cause data loss **What problems is PostgreSQL solving and how is that benefiting you?** PostgreSQL has provided a reliable database for django web application with regular automated data backup and required scalability for growing users of the application ### 50. PostgreSQL database server **Rating:** 4.0/5.0 stars **Reviewed by:** HECTOR FRANCO G. | desarrollador de software en butterflies design web, Small-Business (50 or fewer emp.) **Reviewed Date:** June 16, 2019 **What do you like best about PostgreSQL?** One of the main reasons why I use PostgreSQL is that it is developed under open source (Open Source), besides that if we require a database to work on our project, the most common is that we ask ourselves which database to use provide performance, security and in turn we can use it both in the office and outside it, and one of the most common cases is that we do not all have the same operating system. It also has a management facility PgAdmin is the main base administrator Postgres data is very simple to use, this tool practically does everything with a few simple clicks, being optimal for people who do not have much experience, either because they are starting in the world of databases or because they simply need a database for your project. **What do you dislike about PostgreSQL?** PostgreSQL It is relatively slow there are things like these that I also dislike in insertions and updates in small databases, also PostgreSQL is designed for high volume environments. This makes the response speed seem slow compared to small databases. **Recommendations to others considering PostgreSQL:** As we can see when using PostgreSQL we obtain security, reliability, stability and the opportunity to improve and provide functional developments to make an even more optimal database manager. These simple reasons are more than enough to place Postgres among the main options to take into account when working with databases. **What problems is PostgreSQL solving and how is that benefiting you?** Higher performance. Greater speed both when connecting to the server and serving selects and others. Better administration utilities (backup, error recovery, etc). Even if it hangs up, it does not usually lose information or corrupt the data. Better integration with PHP. There are no limits on the size of the records. Better access control, in the sense of which users have access to which tables and with which permissions. MySQL behaves better than Postgres when modifying or adding fields to a "hot" table. ## 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?filters%5Bnps_score%5D%5B%5D=4§ion=pricing&secure%5Bexpires_at%5D=2026-08-07+10%3A33%3A13+-0500&secure%5Bsession_id%5D=d7cb6a69-77e9-43bc-ab81-9bcfb05602d4&secure%5Btoken%5D=d8218b7f921cb36dca09c994e1f79f6c94c4dbe799390731afb110116484d93f&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) - [cPanel](https://www.g2.com/products/cpanel/reviews) - [Databricks](https://www.g2.com/products/databricks/reviews) - [Docker](https://www.g2.com/products/docker-inc-docker/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) - [Jenkins](https://www.g2.com/products/jenkins/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) - [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) - [Visual Studio Code](https://www.g2.com/products/visual-studio-code/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,128 reviews) - [MySQL](https://www.g2.com/products/mysql/reviews) - 4.4/5.0 (1,583 reviews) - [Oracle Database](https://www.g2.com/products/oracle-database/reviews) - 4.3/5.0 (935 reviews)