--- 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-07-17' 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. Most reliable database **Rating:** 5.0/5.0 stars **Reviewed by:** Vladimir T. | Ingeniero y Desarrollador, Small-Business (50 or fewer emp.) **Reviewed Date:** May 22, 2023 **What do you like best about PostgreSQL?** Reliable: Even when there is no space in disk or with some hardware errors it can recover. Fast --it requires optimizing but it gives the tools to optimize. Open Source. Periodicaly updated. **What do you dislike about PostgreSQL?** For me that it uses Sql is a plus. But I guess for people who doesn't know Sql it may be hard, but it iw worth to learn it. **What problems is PostgreSQL solving and how is that benefiting you?** Keeping millions of records of clients integrally, reliabily and fast. ### 2. 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. ### 3. PostgreSQL: a good alternative to Oracle RDBMS **Rating:** 4.5/5.0 stars **Reviewed by:** Stefano A. | Direttore Ricerca & Sviluppo, Enterprise (> 1000 emp.) **Reviewed Date:** January 10, 2023 **What do you like best about PostgreSQL?** High compatibility with Oracle SQL and Oracle PL/SQL. With very few changes, you are able to migrate an Oracle Database to PostgreSQL. There are also a good choice for what concern high availability and load balancing solutions. **What do you dislike about PostgreSQL?** PostgreSQL is able to manage JSON data with native datatype and APIs. But if you need to query datasets over 10 Gbytes of raw data, consider transforming JSON documents to normalized tables because queries may have time-out issues. **What problems is PostgreSQL solving and how is that benefiting you?** Currently, PostgreSQL is solving the problem of not having the high cost of an Oracle Database installed on-premises. And it also solved the problem of having to rewrite all the PL/SQL code written in another language. ### 4. Open source Database -PostgreSQL **Rating:** 4.5/5.0 stars **Reviewed by:** Shubhi S. | ETL Developer - Talend, Enterprise (> 1000 emp.) **Reviewed Date:** October 04, 2023 **What do you like best about PostgreSQL?** It is open source and freely available, partitioning concept, sql compatibility , support **What do you dislike about PostgreSQL?** upgrade process support, complexity on performance tuning **What problems is PostgreSQL solving and how is that benefiting you?** Helping in Relational Data Management, performance optimization and partitioning on nodes ### 5. Great database with mature capabilities **Rating:** 4.5/5.0 stars **Reviewed by:** Yan A. | Mid-Market (51-1000 emp.) **Reviewed Date:** April 20, 2023 **What do you like best about PostgreSQL?** It has a rich and mature feature set where things like referential integrity weren't an afterthought (compared to MySQL). Documentation is also excellent, and modern ANSI SQL syntax is well supported. **What do you dislike about PostgreSQL?** It's not as widespread as MySQL is, so it can be harder to find people that are strong DBA skills or know the specifics of its internal workings, but it isn't that bad either. It's not like it's some unknown DBMS either, it's simply not as widespread as MySQL. **What problems is PostgreSQL solving and how is that benefiting you?** It allows us to store all of our application's data in a resilient and secure way and be accessible with standard programming languages and development tools such as Java, NodeJS, etc. ### 6. Best Relational DBMS in market **Rating:** 4.5/5.0 stars **Reviewed by:** Vivek D. | Associate Technical Engineer I, Enterprise (> 1000 emp.) **Reviewed Date:** May 04, 2023 **What do you like best about PostgreSQL?** PostgreSQL provides an open-source environment to all users. It's easy to use and easy to understand it's functionality. Creating your own data set for testing or exploring new data set both work in the best way. **What do you dislike about PostgreSQL?** PostgreSQL is good for beginners but its integration parts didn't work properly. Such as JSON data or others. PostgreSQL needs to work on the integration part of this tool. **What problems is PostgreSQL solving and how is that benefiting you?** We save data sets in tables and later explore data sets with the help of PostgreSQL. It makes the data analysis part easy and gives the required result with less effort. Easy working makes it the best. ### 7. 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. ### 8. Excellent Product **Rating:** 5.0/5.0 stars **Reviewed by:** Harsh P. | SDE2, Information Services, Enterprise (> 1000 emp.) **Reviewed Date:** April 24, 2023 **What do you like best about PostgreSQL?** I like the UI of it. The security part is amazing. I really loved the product, and I am continuously using it in day-to-day work, also **What do you dislike about PostgreSQL?** Nothing at all.Everything is just amazing **What problems is PostgreSQL solving and how is that benefiting you?** We have build a schma in our project and there are lot of tables which we are using in that Schema. And also we have integrated this SQL with multiple projects. Its efficiency is superb. ### 9. The default (and best) option **Rating:** 5.0/5.0 stars **Reviewed by:** Ronny D. | Analytics Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** March 05, 2023 **What do you like best about PostgreSQL?** The upsides of using PostgreSQL include its reliability, scalability, advanced features, open-source nature, and strong community. **What do you dislike about PostgreSQL?** Potential difficulties with setup and configuration, complexity that may not be necessary for smaller projects, challenging documentation, and potentially limited third-party integrations. **What problems is PostgreSQL solving and how is that benefiting you?** Regarding business problems, PostgreSQL can help us to manage our data, which is becoming increasingly important in today's data-driven world. It can also help us ensure data consistency and accuracy. Furthermore, its scalability and ability to handle large amounts of data make it well-suited for applications that require high availability and performance. ### 10. free and extreme ease of access **Rating:** 5.0/5.0 stars **Reviewed by:** Ansu A. | Data Analyst, Small-Business (50 or fewer emp.) **Reviewed Date:** February 26, 2023 **What do you like best about PostgreSQL?** The language used is universal to most query tools which makes it an easy tool to use and experiment. And learning ina free environment is super helpful **What do you dislike about PostgreSQL?** Drag and drop of data values in not available in the latest version, as this feature is available in other editors this was expected and would have been helpful **What problems is PostgreSQL solving and how is that benefiting you?** querying and experimenting with my work questions at home without tampering with mother data, in any environment. The sample data sets available help with using this tool to replicate problems with ease ### 11. Recommended Everyone To Use This Product Once. **Rating:** 5.0/5.0 stars **Reviewed by:** Divyarajsinh C. | Software Engineer , Information Technology and Services, Mid-Market (51-1000 emp.) **Reviewed Date:** April 06, 2023 **What do you like best about PostgreSQL?** - The cost(minimal) - Robust - Scalability **What do you dislike about PostgreSQL?** When I use some specific features, it gets stuck. **What problems is PostgreSQL solving and how is that benefiting you?** Actually, I am looking database that is faster, stable, reliable, and as well as provide me with better security so before this, I am using another product that is similar to PostgreSQL but because of the leak of features that I have mentioned earlier, PostgreSQL is preferable for me. ### 12. Exploring PostgreSQL **Rating:** 4.5/5.0 stars **Reviewed by:** Ayushi P. | Analyst, Enterprise (> 1000 emp.) **Reviewed Date:** December 23, 2022 **What do you like best about PostgreSQL?** PostgreSQL, or "Postgres", is an open-source relational database management system (RDBMS).PostgreSQL, or "Postgres", is an open source relational database management system (RDBMS). It supports multiple programming languages, making it easy to develop applications using your preferred language. Unlike some other popular database solutions, such as MySQL and Microsoft SQL Server, PostgreSQL is 100% free and open source. **What do you dislike about PostgreSQL?** One major disadvantage of PostgreSQL is that it doesn't enjoy as much support from software companies as other database systems like Microsoft SQL Server and Oracle. This can mean that you may find it difficult to find commercial software that supports PostgreSQL and that integrates well with your existing system. Another issue with PostgreSQL is that it can be difficult to upgrade to newer versions. If your company relies on upgrading its database system regularly in order to stay competitive, then you may not want to choose PostgreSQL.Finally, some businesses may find that they need more features than what's offered byPostgreSQL when compared to other enterprise-level database systems. These features may include complex security controls, data replication and mirroring, and advanced performance tuning options. **What problems is PostgreSQL solving and how is that benefiting you?** PostgreSQL offers advanced security features such as role-based access control and mandatory access control. This makes it an ideal choice for high-security environments.PostgreSQL supports robust data replication which enables you to replicate your data across multiple databases or clusters. This helps improve performance and availability. PostgreSQL offers powerful querying capabilities that allow you to query your data in any way you want. You can also use rich SQL functions to manipulate your data. ### 13. Postgres review **Rating:** 5.0/5.0 stars **Reviewed by:** Amir R. | Engineering Manager, Financial Services, Mid-Market (51-1000 emp.) **Reviewed Date:** July 28, 2023 **What do you like best about PostgreSQL?** It is a flexible, fast RDBMS, with a lot of features **What do you dislike about PostgreSQL?** There is nothing wrong with this databased server. **What problems is PostgreSQL solving and how is that benefiting you?** Serving as a data concentrator to keep all data from various database servers. ### 14. PostgreSQL Review Analysis **Rating:** 4.5/5.0 stars **Reviewed by:** Farhan S. | Software Developer, Mid-Market (51-1000 emp.) **Reviewed Date:** November 21, 2022 **What do you like best about PostgreSQL?** PostgreSQL is a fast, secure and reliable database to store relational data. It also supports ACID properties, so we stored sensitive data there. It is a open source platform so that we don't have to buy any subscription to use this database. **What do you dislike about PostgreSQL?** PostgreSQL is not suitable for using JSON-like data structures. Also, it's not always available to every server; you must install it explicitly. PostgreSQL has a relatively slow query speed as compared to MySQL database. **What problems is PostgreSQL solving and how is that benefiting you?** With the help of PostgreSQL, we are able to integrate our Springboot application to store user artwork along with their respective artwork pdf in our database and query them whenever we want to retrieve this. ### 15. Best Open-Source Relational Database Management System **Rating:** 4.5/5.0 stars **Reviewed by:** vijay b. | Software Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** November 05, 2022 **What do you like best about PostgreSQL?** PostgreSQL is an Open Source Database that is used for mainly Relational database Systems. We are mainly using this database because of the microservice structure. And in microservices, we have a lot of databases and also it's open source so that is good for our organization. And it's an object-relational database the performance of the database is pretty good. **What do you dislike about PostgreSQL?** The documentation of PostgreSQL is not great. For beginners, it will be complex. and the second thing is the interface of PostgreSQL is not great. **What problems is PostgreSQL solving and how is that benefiting you?** First Of all, PostgreSQL is an open source Application so it's cost-effective for our company. And using PostgreSQL improves the productivity of development. and also It's the best Relational database to develop a microservice structure. ### 16. Good for structure query language. Similar to MySQL **Rating:** 4.5/5.0 stars **Reviewed by:** Pulkit G. | Software Developer, Mid-Market (51-1000 emp.) **Reviewed Date:** March 30, 2023 **What do you like best about PostgreSQL?** It has a good viewing App in which you can see all your schemas, tables, sequences, and many more. **What do you dislike about PostgreSQL?** It is a bit difficult to integrate at the start. **What problems is PostgreSQL solving and how is that benefiting you?** Problem of saving data locally or on local server is being solved by PostgreSQL ### 17. Efficient and free **Rating:** 4.5/5.0 stars **Reviewed by:** Shoaib T. | Data Scientist and Analytics Consultant, Small-Business (50 or fewer emp.) **Reviewed Date:** November 05, 2022 **What do you like best about PostgreSQL?** The best part is that it is free to use and open-source. The installation was super easy because there are plenty of guides available online. We have been using this to gather tweets, and it has made our job easier. Not only that, but it is user-friendly. It also allows for scalability, which is a bonus. As tweets are saved in json it is easier to go through them without anything crashing. **What do you dislike about PostgreSQL?** There is just one teeny issue and that is when you are trying to configure it, there can be some errors which can't be fixed. I was unable to find the solution till I Googled it and found it on a tech website which explained how to sort it out. This configuration issue occurred a year ago and it has yet to be fixed in the new release. **What problems is PostgreSQL solving and how is that benefiting you?** It makes it easy to save tweets from hashtag campaigns and allows for a proper storage for analysis later. ### 18. PostgreSQL **Rating:** 5.0/5.0 stars **Reviewed by:** Praneel Kumar P. | Full time Research Scholar (Ph.D) , Small-Business (50 or fewer emp.) **Reviewed Date:** June 22, 2023 **What do you like best about PostgreSQL?** Ability to manage database securely and easily, easy to integrate to several applications. **What do you dislike about PostgreSQL?** Nothing, so far everything is fine going **What problems is PostgreSQL solving and how is that benefiting you?** Database management, backups and recoveries, easy administration and migration ### 19. Azure postgre **Rating:** 4.5/5.0 stars **Reviewed by:** UDDAGIRI S. | Assistant System Engineering, Enterprise (> 1000 emp.) **Reviewed Date:** June 06, 2023 **What do you like best about PostgreSQL?** I can store data in relational database in the form of tables, views and functions **What do you dislike about PostgreSQL?** Inserting row providing explicit value for Primary key even though default value defind **What problems is PostgreSQL solving and how is that benefiting you?** It help me to datawarehousing ### 20. 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 ### 21. Best free SQL DB out there **Rating:** 4.5/5.0 stars **Reviewed by:** Mauricio O. | Innovation and Technology Manager, Enterprise (> 1000 emp.) **Reviewed Date:** October 31, 2022 **What do you like best about PostgreSQL?** It is totally free; it has helped us to deploy our own web-based applications using RDBMS schemes; admin control is simple to deploy and maintain, it is also very well supported around the community **What do you dislike about PostgreSQL?** Currently we have not found anything to dislike about postgreSQL, coming from MySQL I think postgreSQL it is very straight forward to use, and we haven't had any issues with it. **What problems is PostgreSQL solving and how is that benefiting you?** It has provided us a Relational DataBase Management System for our web applications, we are using python and flask framework for development, and it is very simple to connect PostgreSQL to SQLAlchemy ### 22. The most safer and reliable database engine **Rating:** 5.0/5.0 stars **Reviewed by:** Alejandro C. | IT Head, Automotive, Mid-Market (51-1000 emp.) **Reviewed Date:** November 08, 2022 **What do you like best about PostgreSQL?** PostgreSQL is the most complete, safer, easier and more reliable database engine we use in the company. We administrate it through PG Admin, and we have allocated in the AWS instance. **What do you dislike about PostgreSQL?** It's tricky if you have invalid objects to assign permissions to different users o groups. But once you delete or repair the invalid objects, everything becomes more accessible. It is the only thing that i dislike. **What problems is PostgreSQL solving and how is that benefiting you?** Fastest access to my principal database schema. Secure the information of the company. Escalable trough the main support assistance. Easier to integrate with different apps. ### 23. Very convenient to use and supports wide range of query formats **Rating:** 4.5/5.0 stars **Reviewed by:** Shrijaya S. | Senior Software Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** December 22, 2022 **What do you like best about PostgreSQL?** Supports wide range of query syntax and best in terms if usability. **What do you dislike about PostgreSQL?** Too many reserved keywords. With these many keywords we dont get to chosse meaningful column names due to reserved keyword restrictions. **What problems is PostgreSQL solving and how is that benefiting you?** Helps store the data and is one of the best "structured query language" tools out there. Pretty versatile in supporting multiple formats of queries. ### 24. #1 open source object relational database management system **Rating:** 5.0/5.0 stars **Reviewed by:** Mansi M. | Software Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** November 06, 2022 **What do you like best about PostgreSQL?** I like the best that it is widely used for enterprise software development, it has been in the industry for very long, thus it is reliable, robust and highly performant. It is fast and very easy to use. It also provides very detailed documentation along with detailed feature matrix for each version release. **What do you dislike about PostgreSQL?** Nothing to dislike as such, but something that is very common in softwares is that latest version is never stable enough for production use. **What problems is PostgreSQL solving and how is that benefiting you?** It is a very easy to use object relational database management system, it is powerful and provides support for backend, different data types, indexing, JSON, backup, restore, data integrity, and much more all just in one product. ### 25. 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. ### 26. One of the most powerful RDBMS **Rating:** 5.0/5.0 stars **Reviewed by:** Deepak A. | Small-Business (50 or fewer emp.) **Reviewed Date:** April 22, 2023 **What do you like best about PostgreSQL?** I like its capability to handle multi vendors. **What do you dislike about PostgreSQL?** It takes more time to get hands on experience than other RDBMS **What problems is PostgreSQL solving and how is that benefiting you?** Multi vendors handling, we are getting more from it. ### 27. 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. ### 28. PostgreSQL An efficient SQL Database **Rating:** 3.0/5.0 stars **Reviewed by:** Arijit D. | Associate Software Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** September 01, 2022 **What do you like best about PostgreSQL?** A safe, dependable, and robust database is PostgreSQL. It is an open-source RDBMS that performs well while handling a lot of data. Both Linux and Windows operating systems support installing PostgreSQL. SQL expertise is not necessary if we understand the tool adequately. Any database may employ SQL knowledge as well. **What do you dislike about PostgreSQL?** For a newbie, PostgreSQL requires instruction. Through PgAdmin, a graphical application is used to manage it. Executing queries on an enormous database might sometimes be a bit sluggish. PostgreSQL installation ought to be simpler for users. Since few individuals utilize this technology, exchanging files or databases with others is challenging. **What problems is PostgreSQL solving and how is that benefiting you?** I can utilise PostgreSQL, an open-source RDBMS, for a variety of applications that will reduce the cost to the company. It is quick and straightforward to integrate with other applications and supports a variety of datastore capabilities, including JSON, etc. ### 29. Easy to use relational database system **Rating:** 5.0/5.0 stars **Reviewed by:** Josh S. | Analyst, Small-Business (50 or fewer emp.) **Reviewed Date:** February 16, 2023 **What do you like best about PostgreSQL?** Easy to use, simple to maintain for learning purposes. **What do you dislike about PostgreSQL?** I used it during a Data Analytics boot camp so I can't speak to how well it works for organizations and teams. No complaints from me. **What problems is PostgreSQL solving and how is that benefiting you?** I used it in a Data Analytics Boot Camp to learn SQL queries and creating databases. ### 30. 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. ### 31. Lightweight Opensource **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Enterprise (> 1000 emp.) **Reviewed Date:** April 06, 2023 **What do you like best about PostgreSQL?** PostgreSQL is a lightweight and open-source RDBMS. It is one of the most widely used Database engines and though it is open source, forward development continues. **What do you dislike about PostgreSQL?** Support is one thing that I don't like about PostgreSQL. **What problems is PostgreSQL solving and how is that benefiting you?** It is fast. We are using the DB for the analytical purpose also. ### 32. 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. ### 33. Easy-Data **Rating:** 4.5/5.0 stars **Reviewed by:** Nazim S. | Administration, Information Technology and Services, Mid-Market (51-1000 emp.) **Reviewed Date:** June 03, 2022 **What do you like best about PostgreSQL?** the best thing about the Postgres is the easiest database to learn and handle and the best quality is open source so we can manage or integrate the queries according our requirement easy to learn for fresher and the best thing is U can easily access the database using UI **What do you dislike about PostgreSQL?** sometimes it is difficult to manage unstructured data. the worst thing is consuming too many threads and processes if 20 queries are fired at a time then it it will consume 20 processes and 20 threads which might slow down the system some time Postgres is case sensitive which is difficult sometimes to executive a query **Recommendations to others considering PostgreSQL:** yes to my colleagues and friends **What problems is PostgreSQL solving and how is that benefiting you?** all my data problems are solved by Postgres we have too much-unstructured data which is managed by Postgres. my app is running using the PostgreSQL database which helps users to host a website and to make a call ### 34. Postgresql use in Bigdata space **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** November 02, 2022 **What do you like best about PostgreSQL?** We have been using postgres as a backend database to store critical metadata and schema efficiently for datalake and machine learning use cases with Cloudera products. Scalability and ease of configuration and use are some of the features that can be leveraged. **What do you dislike about PostgreSQL?** Database restart is required even for user and host level access is modified. A simple reload option or a refresh could have been a better option to deal with such situation. **What problems is PostgreSQL solving and how is that benefiting you?** Helping to store critical backend data for datalake and machine learning solutions. Storing all records and schema for tables and their metadata with good performance ### 35. PostgreSQL for a better database experience. **Rating:** 5.0/5.0 stars **Reviewed by:** Kr. G. | Database Developer (PA-III), Information Technology and Services, Small-Business (50 or fewer emp.) **Reviewed Date:** February 10, 2022 **What do you like best about PostgreSQL?** PostgreSQL is a best open source RDBMS for large data.Installation is easy, we can use it on any platfrom either on windows or linux . I have used it on windows OS with pgAdmin GUI tool for its management. Database backup and restoration is very easy through single pgsql command. **What do you dislike about PostgreSQL?** PostgreSQL command-line interface is not very much user-friendly so we normally use pgAdmin and its operation is slow with the GUI interface. datatype conversion should also be available with GUI. Scheduling agent is not available in the default installation and PostgreSQL is not convenient for the business intelligence or ETL operation. **Recommendations to others considering PostgreSQL:** Best open source database available. datatype and SQL operations are very much friendly with database developers. **What problems is PostgreSQL solving and how is that benefiting you?** We have switched from a widely used database to PostgreSQL and installed it on the Redhat Linux machine. We have used it for data analytics and data transaction purpose, Our international project database with millions of data transactions per day is now on PostgreSQL. ### 36. 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 ### 37. Best Open source relational database management system one can rely **Rating:** 4.5/5.0 stars **Reviewed by:** Sumanth S. | Senior Technical Support Specialist, Mid-Market (51-1000 emp.) **Reviewed Date:** December 09, 2022 **What do you like best about PostgreSQL?** Installation and setting up. Running queries, Ease of use with backup and restoration **What do you dislike about PostgreSQL?** Nothing as such. It's pretty good for common use cases. **What problems is PostgreSQL solving and how is that benefiting you?** Storing of the business records and retrieval using application codes ### 38. Great DB **Rating:** 5.0/5.0 stars **Reviewed by:** Or N. | Data Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** November 23, 2022 **What do you like best about PostgreSQL?** Fast, lean has all the functions you need to work with a DB. **What do you dislike about PostgreSQL?** Everything is working fine so far. if there will be a change I will update **What problems is PostgreSQL solving and how is that benefiting you?** Fast and lean DB for our Microservices transition ### 39. Database with PostgreSql **Rating:** 4.5/5.0 stars **Reviewed by:** Swetank S. | Lead Associate, Enterprise (> 1000 emp.) **Reviewed Date:** April 19, 2022 **What do you like best about PostgreSQL?** Best thing is its very easy to use and its training and support is easily available as one SQL language works same for almost all databases. If we know the tool well then sql knowledge is not much required. Also knolwedge of sql can be used in any databases. **What do you dislike about PostgreSQL?** This tool is not used by many people which makes it hard to share file or databases with others. Compared to ssms its not have that much features and creating keys are also hard. **Recommendations to others considering PostgreSQL:** If you want database which is free of cost and ease of use then go for it. A person not knowing sql also can work on this tool. **What problems is PostgreSQL solving and how is that benefiting you?** With basic training all my colleague are easily using this software for database. Plus this software is available at free of cost which makes it accessible for all. ### 40. PostgresSQL the best Open Source RDBMS **Rating:** 4.5/5.0 stars **Reviewed by:** Nitesh K. | Project Associate(II), Mid-Market (51-1000 emp.) **Reviewed Date:** February 25, 2022 **What do you like best about PostgreSQL?** PostgreSQL is a Secure, robust, and reliable database. It is an open-source RDBMS having great performance to handle a large amount of data. PostgreSQL can be installed on windows as well as Linux operating systems. **What do you dislike about PostgreSQL?** PostgreSQL requires training for the beginner. It is managed by using a graphical tool through PgAdmin. Sometimes it is a little bit slow on executing queries on a large database. Installing PostgreSQL should be more User-friendly. **Recommendations to others considering PostgreSQL:** Open Source RDBMS which can handle large databases. It is robust and secure. Just go with it. **What problems is PostgreSQL solving and how is that benefiting you?** PostgreSQL is an open-source RDBMS, I can use for various applications that will save the cost of the organization. It supports various datastore features like JSON etc and is easy to integrate with other applications, which saves time and effort. ### 41. PostgreSQL for Software **Rating:** 4.5/5.0 stars **Reviewed by:** Yash C. | Software Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** May 10, 2022 **What do you like best about PostgreSQL?** The thing which I like the most about PostgreSQL is it supports a wider variety of data types as compared to the others and it is also completely free to use and it also supports data warehousing **What do you dislike about PostgreSQL?** The thing which I like the most about PostgreSQL is it is slower while reading the data from the database compared to others. **What problems is PostgreSQL solving and how is that benefiting you?** With PostgreSQL, it is easier to perform the write operations on the database effectively and also it handles the concurrency better as compared to others. ### 42. 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. ### 43. PostgreSQL the great SQL databases **Rating:** 4.5/5.0 stars **Reviewed by:** Abhishek J. | Jr. Full Stack Developer, Enterprise (> 1000 emp.) **Reviewed Date:** March 09, 2022 **What do you like best about PostgreSQL?** PostgreSQL is a regional database management system which stores the structure data. Query execution speed is fast which helps to make over-all performance of the application fast. Backups and restoration process is very easy. It is secure, reliable and robust. **What do you dislike about PostgreSQL?** Sometimes it takes lot of time to execute complex quries. Installation process is little heavy as compare to other SQL databases. User interface can be improved. **Recommendations to others considering PostgreSQL:** Best for structured data. **What problems is PostgreSQL solving and how is that benefiting you?** I am using PostgreSQL for storing large amount of relation data. As it is object relational database it is very easy to perform operations like insert and select. Also it's performance and responce time is very good. It has strong comunity support. ### 44. Best Open Source RDBMS **Rating:** 5.0/5.0 stars **Reviewed by:** Manu V. | Senoir Software Developer, Small-Business (50 or fewer emp.) **Reviewed Date:** March 01, 2022 **What do you like best about PostgreSQL?** The thing I like most about PostgreSQL is that it has a dedicated database connection for all the fremwork. PostgreSQL has a reliable dependency for spring boot. It makes it easy to connect PostgreSQL to the backend and perform various operations through coding. When you compare it with other alternatives, it offers many features and, most importantly, provides up-to-date security. One more thing I like about PostgreSQL is its large support community. **What do you dislike about PostgreSQL?** To perform database-related tasks, you must have proper knowledge of PostgreSQL documentation. For fresher, it will be challenging to understand complex things in the documentation. One thing I noticed while using PostgreSQL was it becomes slow while handling huge transactions. **Recommendations to others considering PostgreSQL:** PostgreSQL is one of the top 5 RDBMS available in the market. It is a common database among developers, and it is easy to set up and configure. I will recommend others to try this product. **What problems is PostgreSQL solving and how is that benefiting you?** I use PostgreSQL as part of my spring boot project. My project uses PostgreSQL as well as CouchDB for storage purposes. PostgreSQL makes it easy for me to integrate with spring boot because of the PostgreSQL database connector and also supports spring JPA to perform fetching-related tasks. ### 45. The best open source database in the market **Rating:** 4.5/5.0 stars **Reviewed by:** Oscar C. | Software Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** May 19, 2022 **What do you like best about PostgreSQL?** How robust is postgres and how extensible it is. Despite being a database with lots of years in the market, it is up to date with the latest needs (for instance working with JSON data) **What do you dislike about PostgreSQL?** Nothing. Maybe the fact that mysql gets more popularity despite not being as robust as postgres **What problems is PostgreSQL solving and how is that benefiting you?** Basically to use it as a relational data storage for our microservices layer here at Pager ### 46. Best open source DB **Rating:** 4.5/5.0 stars **Reviewed by:** Kushal V. | Senior System Engineer - BI developer, Mid-Market (51-1000 emp.) **Reviewed Date:** June 08, 2022 **What do you like best about PostgreSQL?** Easy to build connection between postgreSql to other framework. **What do you dislike about PostgreSQL?** I feel the interface could be better. It took little time to open pgadmin. **Recommendations to others considering PostgreSQL:** It's open source. easy to run complex queries. Faster execution **What problems is PostgreSQL solving and how is that benefiting you?** You can load any excel file format and play around it. You can create your own DB in your laptop using this PG admin. ### 47. Open Source and Efficent Database for Enterprise business use **Rating:** 4.5/5.0 stars **Reviewed by:** Krishna Prasad J. | Talend Developer, Mid-Market (51-1000 emp.) **Reviewed Date:** February 06, 2022 **What do you like best about PostgreSQL?** --> Open Source Nature --> Easy to use and well-defined documentation and lots of tutorials for quick and fast learning --> Comparable with Oracle Database System --> Almost all features are available freely. You do not need any other database system if you use postgres. **What do you dislike about PostgreSQL?** Absolute beginners can feel difficulty learning and implementing it in real-time projects. Basic knowledge of database management systems is a must to learn any DBMS Software. **What problems is PostgreSQL solving and how is that benefiting you?** I use it in real-time projects such as designing database systems for E-Commerce Applications, and I mainly use it along with Node JS and Angular. I do not have to pay any amount I had to pay if I had used SQL Server OR Oracle Software. ### 48. PostgreSQL review **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** July 28, 2022 **What do you like best about PostgreSQL?** PostgreSQL is one of the best relational databases. It supports multiple data types and has good query and data management support. The documentation is maintained and is the best place to learn everything about the database. **What do you dislike about PostgreSQL?** PostgreSQL supports JSON datatype but the supporting methods are difficult to understand and work with. The documentation is present but there aren't enough examples that would help developers understand and use the methods. **What problems is PostgreSQL solving and how is that benefiting you?** PostgreSQL is solving the problem of maintaining data in tabular or relational format. Few applications and web services that I have worked on require relational database this is being fulfilled by PostgreSQL. ### 49. Powerful open source relational database **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Hospital & Health Care | Mid-Market (51-1000 emp.) **Reviewed Date:** June 16, 2022 **What do you like best about PostgreSQL?** It is an open-source relational database that supports a heavy range of workloads. it follows the ACID properties and SQL queries. PostgreSQL has views, tables, store procedures etc. The database can connect with multiple interfaces and supports python, java, C++, PHP and perl. **What do you dislike about PostgreSQL?** It has a slow Comparatively low reading speed. Its documentation is only available in English. In some circumstances, the lack of columnar stores renders PostgreSQL less capable in analytics tasks. **Recommendations to others considering PostgreSQL:** Highly scalable relational database. **What problems is PostgreSQL solving and how is that benefiting you?** PostgreSQL, help to store the data in the databases. It is highly programable and hence can load and transform the data in different stages using python. PostgresSQL procedural language PL/PgSQL is much more powerful than MySQL’s SQL and hence used to load the aggregated data into publishing layer tables. ### 50. Fast and Open Source RDBMS **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Chemicals | Enterprise (> 1000 emp.) **Reviewed Date:** June 30, 2022 **What do you like best about PostgreSQL?** Compared to MySQL, PostgreSQL is quicker and provides ACID characteristics. Storage procs can be created in PL/pgSQL, PL/Python, PL/Perl, and C/C++, and it has broader community support. It is a highly expandable database that handles large datasets, challenging queries, and read-write operations more quickly. **What do you dislike about PostgreSQL?** Only limited documentation is available in English. Additionally, the reading speed is really slow. PostgreSQL is one of the best open-source databases available besides this. **Recommendations to others considering PostgreSQL:** Good DB for storage purpose **What problems is PostgreSQL solving and how is that benefiting you?** We used PostgreSQL to accommodate a large amount of data. Establishing the Datawarehouse to transform the daily loads into tables and update the dimensions, Facts, and other tables. It's used for data analysis and running the transformation on multiple tables and layers. ## 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?page=3§ion=pricing&secure%5Bexpires_at%5D=2026-07-30+13%3A35%3A24+-0500&secure%5Bsession_id%5D=aa853282-88b0-48d5-8cdb-0e979fa34bdd&secure%5Btoken%5D=bd4116c3d74be02965d276c71ada3e16f8e66d138afe4cb1a9856447770d6db6&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,127 reviews) - [MySQL](https://www.g2.com/products/mysql/reviews) - 4.4/5.0 (1,581 reviews) - [Oracle Database](https://www.g2.com/products/oracle-database/reviews) - 4.3/5.0 (931 reviews)