--- 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-04' 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. 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. ### 2. PostgreSQL review **Rating:** 4.5/5.0 stars **Reviewed by:** Sakchi . | Intern, Small-Business (50 or fewer emp.) **Reviewed Date:** April 28, 2022 **What do you like best about PostgreSQL?** The best thing i liked about PostgreSQL is that it's very easy to use and can handle various complex queries. It is also helpful when you need to run huge queries such as trigger. **What do you dislike about PostgreSQL?** As such there is no dislike about PostgreSQL but yes, for a beginner who have no or less Knowledge about SQL, it will be very difficult for him/her to work on PostgreSQL. **What problems is PostgreSQL solving and how is that benefiting you?** I have used it in one if my University project where I have used MySQL as database. I have used it handle Trigger queries and much more. I have realised that learning PostgreSQL will give you an edge over other query langauges. ### 3. For me this is the best and most robust RDBMS in the market **Rating:** 5.0/5.0 stars **Reviewed by:** Raj P. | Software Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** November 08, 2021 **What do you like best about PostgreSQL?** This is the most versatile and advanced DB system in the market available for free of cost. This DB system is similar to MySQL or Oracle DB system but it is more popular and has a bigger community than those. It has a convenient command-line interface for both Linux and Windows OS. It has intuitive commands that do what they sound like e.g., create table, create database, etc. For those who are not good with command-line interfaces, it also has GUI based management tool called pgAdmin for easier use. It has easy integration with Python and Golang and its frameworks like Django for Python. You can easily export table data in CSV. The best thing is, it has a detailed documentation website where you can explore all of its functionalities easily and release-wise. **What do you dislike about PostgreSQL?** Honestly, I don't think this RDBMS has any significant flaw or issue. One thing is, there are fewer drivers available for this database for integration in frameworks e.g. Python Django framework literally has one driver called psycopg2 which can create license issues. Another thing is, it has a huge number of commands that can be difficult for some people to grasp. **Recommendations to others considering PostgreSQL:** For other PostgreSQL users, I can recommend this DB system as it is a general-purpose DB system but still the selection of a DB system mostly depends on the requirement. **What problems is PostgreSQL solving and how is that benefiting you?** I use PostgreSQL in a web application that needs to store a large amount of JSON data with very frequent access. PostgreSQL can also be used in data analysis which also requires the storage of a large amount of complex data. ### 4. PostgreSQL DBA and trainer **Rating:** 5.0/5.0 stars **Reviewed by:** Jean-Marie R. | Open Source Database Technical leader, Enterprise (> 1000 emp.) **Reviewed Date:** September 17, 2020 **What do you like best about PostgreSQL?** SQL standards Stable configuration settings per version Improvments over time A lot of tools around PostgreSQL: as pgAdmin4, programmaing language connectors, pgbadger, pgbackrest, patroni, ... PostgreSQL is an Open source piece of software. **What do you dislike about PostgreSQL?** A lot of different projets around PostgreSQL himself for same purpose. No full featured and supported clustering solution embedded natively. Long new features development cycle. **What problems is PostgreSQL solving and how is that benefiting you?** Save and retrieve structured datas in a good way. Consistent tools allowing long term working procedure Same SQL and client behaviour when upgrading databases ### 5. 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. ### 6. 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. ### 7. Highly reliable and scalable RDBMS available to use. **Rating:** 4.5/5.0 stars **Reviewed by:** Ekta S. | Senior Software Developer, Mid-Market (51-1000 emp.) **Reviewed Date:** February 15, 2022 **What do you like best about PostgreSQL?** Easy to install and integrate with the application. It uses standard SQL and also supports object-oriented SQL programming and we can also perform JSON-based data transactions with this dbms. Client-Server network architecture support is the best thing is with Postgresql and of-course it is open source DBMS **What do you dislike about PostgreSQL?** Some speed issues with PostgreSQL when we perform data transactions on very large numbers. Backup features should be improved and PostgreSQL should provide some own GUI for DB operation, normally we use pgAdmin for the same purpose. **Recommendations to others considering PostgreSQL:** Scalable, Robust, and Reliable database. must use one time for better database exeperience. **What problems is PostgreSQL solving and how is that benefiting you?** I have used Postgresql for data analytics purposes, I have created a data warehouse for my project and due to it comes with a powerful SQL engine, it manages a large amount of data very easily. ### 8. Review of PostgreSQL **Rating:** 4.5/5.0 stars **Reviewed by:** Aayush B. | Software Intern, Small-Business (50 or fewer emp.) **Reviewed Date:** April 22, 2022 **What do you like best about PostgreSQL?** It is very robust and easy to install and configure. there are large number of add ons which can be used in this database. Overall it is best db for a developer. **What do you dislike about PostgreSQL?** the queries which requires large calculations are very slow. Many a times i faced problem with the way its indexing work for a particular table in database which is headache for developers. **What problems is PostgreSQL solving and how is that benefiting you?** I am using PostgreSQL for my database queries. the trigger handling property using PostgreSQL makes it very easy as compared to other db langauges. I found it very reliable and easy to use. ### 9. 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. ### 10. Efficient Database for Enterprise use **Rating:** 5.0/5.0 stars **Reviewed by:** Akash K. | SDE-1, Small-Business (50 or fewer emp.) **Reviewed Date:** March 26, 2022 **What do you like best about PostgreSQL?** First of all it is open source and has dedicated database connections for all mostly used web frameworks, It also provides up to date security with newer updates and almost all features are free of cost **What do you dislike about PostgreSQL?** Speed issues with PostgreSQL performing data transactions on very large numbers.If you have worked with any other SQL, you will find PostgreSQL is similar to other SQL **What problems is PostgreSQL solving and how is that benefiting you?** In the education field, Postgres is used over other databases because of its ease of access and quality of support in all languages. It has stronger API compatibility, cheaper support and more robust scalability ### 11. Useful open source database **Rating:** 4.5/5.0 stars **Reviewed by:** Biswadeb M. | Application Development Senior Analyst, Mid-Market (51-1000 emp.) **Reviewed Date:** April 03, 2022 **What do you like best about PostgreSQL?** Open source, ready-made ide as PgAdmin tool, lightweight and easy to use **What do you dislike about PostgreSQL?** Faced alot of database crashing and hang issues despite configuring with runnable solutions. **What problems is PostgreSQL solving and how is that benefiting you?** Problems based on my project. Easy to use, PGadmin tool makes it easier to create and modify tables also. ### 12. PostgreSQL Review **Rating:** 5.0/5.0 stars **Reviewed by:** AMIT J. | Data Scientist L3, Small-Business (50 or fewer emp.) **Reviewed Date:** January 17, 2022 **What do you like best about PostgreSQL?** I have used PostgreSQL in one of my projects. Before that, I have not used postgresql. As per clients' requirements, we have to use the PostgreSQL database. So We learned it quickly Since I have worked with other SQL previously. And find it very easy to work with PostgreSQL. **What do you dislike about PostgreSQL?** If you have worked with any other SQL, you will find PostgreSQL is similar to other SQL also, but the main advantage is it is very convenient for structured data. **Recommendations to others considering PostgreSQL:** I will highly recommend PostgreSQL for your work, learning, career. **What problems is PostgreSQL solving and how is that benefiting you?** We are saving data in a structured format. And quickly, we can make ER Diagram also. Excellent experience working with PostgreSQL. The client is also satisfied with our work. ### 13. Best Relational database with memory cache and utilisation with json column type which lacks in SQL **Rating:** 4.5/5.0 stars **Reviewed by:** SHALABH S. | Senior Software Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** January 02, 2022 **What do you like best about PostgreSQL?** Ability to use Json type columns which lets us use it like non - Relational dbs. Also it's completely open source. Good for students and freelancers **What do you dislike about PostgreSQL?** Difficulty to perform groupBy query on JSON type columns using SLICK. Not enough documentation available for postgres using SLICK **Recommendations to others considering PostgreSQL:** Best for students, start-ups or even service based companies. **What problems is PostgreSQL solving and how is that benefiting you?** Able to use it for open source project. Best for web site and web application products. Rich documentation for learning. Performs faster than MySQL ans SQL. Multiple opensource management tool available for POSTGRES ### 14. 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 ### 15. Experience using Postgresql as database management software in industry. **Rating:** 4.5/5.0 stars **Reviewed by:** Haripriya B. | Summer Intern, Internet, Enterprise (> 1000 emp.) **Reviewed Date:** July 30, 2018 **What do you like best about PostgreSQL?** It is free and open DBMS software and has a good GUI feature. PostgreSQL is the world’s most advanced open source database. Developed over 25 years by a vibrant and independent open source community, PostgreSQL was born from the same research as Oracle and DB2 and contained comparable enterprise-class features such as full ACID compliance for outstanding transaction reliability and Multi-Version Concurrency Control for supporting high concurrent loads. On top of it, there is a vibrant community of PostgreSQL professionals and enthusiasts that your staff can draw upon and contribute to. **What do you dislike about PostgreSQL?** It sometimes crashed when I open it in normal mode. I need to open it in admin mode to open it. It is considerably slower than MySQL, and it does not support the entire ANSI SQL 92' standard, much less the ANSI SQL 99' standard, which is widely used in the industry. PostgreSQL is not good when it comes to performance, and It is not much popular than other database management systems, making replication is more complex. **Recommendations to others considering PostgreSQL:** It is highly recommended for the education field because of its good GUI feature and straightforward learning environment. I would suggest the computer science engineering people use this constantly. It's a little hard for beginners but best for professionals. **What problems is PostgreSQL solving and how is that benefiting you?** In the education field, Postgres is used over other databases because of its ease of access and quality of support in all languages. PostgreSQL is available for almost every brand of Unix (34 platforms with the latest stable release), and Windows compatibility is available via the Cygwin framework. Native Windows compatibility is also available with version 8.0 and above. The source code is open to all at no charge. PostgreSQL is available for almost every brand of Unix (34 platforms with the latest stable release), and Windows compatibility is available via the Cygwin framework. Native Windows compatibility is also available with version 8.0 and above. ### 16. 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. ### 17. Great open-source database system **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Small-Business (50 or fewer emp.) **Reviewed Date:** April 21, 2022 **What do you like best about PostgreSQL?** It is completely free, easy to set up, extremely robust, and has great performances on concurrency, transactions, and schema. It is also well-supported so new features and improvements are rolled out frequently. **What do you dislike about PostgreSQL?** For large-scale enterprise applications, PostgreSQL is slow. Horizontal scaling is difficult and a culprit. Could use improvements for JSON. Not a lot of online documentation and resources available compared to MySQL. **What problems is PostgreSQL solving and how is that benefiting you?** Storing and querying a large amount of data across applications. PostgreSQL makes the ETL process very easy along with being able to onboard new team members. Overall, it enabled us to store and utilize our data well. ### 18. Not just another SQL **Rating:** 5.0/5.0 stars **Reviewed by:** Anish Mahesh S. | Gasoline Blend Optimization Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** April 24, 2022 **What do you like best about PostgreSQL?** Intuitive front end and GUI. Quickly becoming an industry favourite **What do you dislike about PostgreSQL?** The interface could be an acquired taste to some but it does take some while to get used to **Recommendations to others considering PostgreSQL:** Don't think this as any other generic SQL it has a league of its own. **What problems is PostgreSQL solving and how is that benefiting you?** Being using it to back all of our databases. It is secure and trustworthy. ### 19. 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 ### 20. Invaluable RDBMS with MVCC **Rating:** 4.5/5.0 stars **Reviewed by:** Savan S. | Senior Software Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** January 30, 2022 **What do you like best about PostgreSQL?** In terms of security, it has one of the most advanced locking mechanisms available. It has a large amount of storage space and is well-known for the integrity of its data. Server-Side Programming features that are mature. Due to robustness, many dynamic websites and online apps rely on PostgreSQL as their back-end database. **What do you dislike about PostgreSQL?** Column re-ordering is not available, slower than MySQL **What problems is PostgreSQL solving and how is that benefiting you?** PostgreSQL provides the ability to manage metadata. As a result of PostgreSQL's catalogue-driven design, it can be expanded. PostgreSQL's catalogues hold information of tables, columns, data types, functions, and access methods. ### 21. Very complete and stable database **Rating:** 5.0/5.0 stars **Reviewed by:** Gajendra K. | Technical Team Lead, Enterprise (> 1000 emp.) **Reviewed Date:** March 05, 2022 **What do you like best about PostgreSQL?** It is very complete for any type of project or application. It is stable, easy to use and can handle a lot of structured data. It is free software and is very well documented It is very popular and has a very varied community around the project **What do you dislike about PostgreSQL?** Installment and handelling of initial infrastructure is big complex. **What problems is PostgreSQL solving and how is that benefiting you?** I am using this for handling structured data for an airline. It have various advanced features and stability. ### 22. 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. ### 23. Cheap and Fast alternative to Enterprise Level DB requirements (beats MSSQL) **Rating:** 2.5/5.0 stars **Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.) **Reviewed Date:** February 09, 2022 **What do you like best about PostgreSQL?** I like that its free, open source, and very fast. **What do you dislike about PostgreSQL?** Connecting requires a local daemon running and using the web browser (they have a windows app, but it is just the browser wrapped in the app using Electron). Deployment is a bit trickier than MySQL but easier than MSSQL Server, considering the price being free, its not much of a concern) **What problems is PostgreSQL solving and how is that benefiting you?** I am personally resolving the licensing budget problems that I have with MSSQL. ### 24. PostgreSQL **Rating:** 3.0/5.0 stars **Reviewed by:** Verified User in Music | Mid-Market (51-1000 emp.) **Reviewed Date:** January 11, 2022 **What do you like best about PostgreSQL?** I have used this as this was free and so to save product cost client wanted to migrate from SQL to PostgreSQL. There are some offcourse syntax changes but overall logic remains same. **What do you dislike about PostgreSQL?** Nothing to dislike as such but ya but 1 thing i would like to point out, it doesn't contain every method which is used is sql. So there are some changes which you need to do if you are looking for a migration. Not all collation such as sql latin1_general_ci_as for eg are nt available. **What problems is PostgreSQL solving and how is that benefiting you?** Cost - the main factor, we used it in gcp - google cloud platform and it was free, if u compare it with sql that is very costly. Efficiency - it is as effective as other databases. ### 25. 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. ### 26. One of the best solution for RDBMS **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** May 09, 2022 **What do you like best about PostgreSQL?** PostgreSQL is one of the best available open-source relational database management systems. Available on all the platforms. GUI is also available which is again the best thing. **What do you dislike about PostgreSQL?** PostgreSQL CLI commands are not very commonly used. It is hard to remember on initial stage. **What problems is PostgreSQL solving and how is that benefiting you?** We are using PostgreSQL for our large production database where millions of transactions happen on regular basis. We are using data analytics also. ### 27. PostgresSQL is a powerful database **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Education Management | Small-Business (50 or fewer emp.) **Reviewed Date:** April 19, 2022 **What do you like best about PostgreSQL?** It's very easy to set up, especially when using a managed service from a cloud provider. **What do you dislike about PostgreSQL?** Migrating when there are version upgrades can be a bit of a pain. **What problems is PostgreSQL solving and how is that benefiting you?** It's the primary datastore used for the project. ### 28. 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 ### 29. 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 ### 30. Working on SQL with PostgreSQL **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Automotive | Enterprise (> 1000 emp.) **Reviewed Date:** December 26, 2021 **What do you like best about PostgreSQL?** The code/Query you type in the database, if overwritten by another new query by user, the previous query /Queries will still be available in the history, which you can easily refer to and copy the old code **What do you dislike about PostgreSQL?** There's not much to Dislike to be honest - but every database may have some or the other query restricted limitations. Such as, in PostgreSQL I could'nt use the LIMIT command and few more - which were working in MySQL server. But other major things were working fine only. **What problems is PostgreSQL solving and how is that benefiting you?** I used to practice SQL for personal skill development on both MYSQL server and PostgreSQl and in that I used to analyse the auto market database, to dig out insights related to recent and historical trends ### 31. SQL with most user friendly behaviour. **Rating:** 5.0/5.0 stars **Reviewed by:** Prasad B. | Principal Consultant, Enterprise (> 1000 emp.) **Reviewed Date:** April 27, 2022 **What do you like best about PostgreSQL?** - Easy to code and interpret. - DB compatible **What do you dislike about PostgreSQL?** - Need to get more in-built libraries and opcodes. **What problems is PostgreSQL solving and how is that benefiting you?** - performance engineering and migration ### 32. Postgresql solve it for free **Rating:** 5.0/5.0 stars **Reviewed by:** Franco M. | PLSQL Developer, Small-Business (50 or fewer emp.) **Reviewed Date:** April 21, 2022 **What do you like best about PostgreSQL?** It's similar to oracle and mysql but it's free **What do you dislike about PostgreSQL?** UI is not the best. Could be even better. **What problems is PostgreSQL solving and how is that benefiting you?** Database for a labor union implementing Adempiere ### 33. PostgreSQL Review and experience on my point of view **Rating:** 4.5/5.0 stars **Reviewed by:** Jagruti P. | Senior Analyst, Enterprise (> 1000 emp.) **Reviewed Date:** July 25, 2021 **What do you like best about PostgreSQL?** - Simplicity and flexibility compared to other SQL databases. - Logging is available for each and every activity if you eneabled that so its easy to understand if some users has changed any data. - We can use complex data types which is available in postgres like geographic objects which help us to manage location data in the database if your application needs to manage user or other location. - English Documenetation available for easy of use and that will not take much time to learn this database Software. **What do you dislike about PostgreSQL?** - The speed of fetching data is very low compare to others. - Each and every open source software not support PostgreSQL compare to mySQL which support most of each and every open source sotware. **Recommendations to others considering PostgreSQL:** Check your requirement before choosing this database or any other relational database. If your condition is to read data from the database too frequently, then it might be slowness shows in your whole application. **What problems is PostgreSQL solving and how is that benefiting you?** - Firstly, I solved many issues using this database. I like it the most because we can use both the console and User interface to manage the database. - Secondly, we can use easily use AWS RDS to manage this database as RDS contains its configurations. - Third, My requirement is to read data from Queue and then process data and store in database based on schdeuler which is run timely basis so I didnt find any slowness in my system bacase all things are managed at background level. ### 34. 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. ### 35. I've learned to use Postgres for everything unless there's very good reason not to **Rating:** 5.0/5.0 stars **Reviewed by:** Charlie O. | CTO, Small-Business (50 or fewer emp.) **Reviewed Date:** November 16, 2021 **What do you like best about PostgreSQL?** Postgres is rock solid, widely available, and very performant. In my opinion it is usually best to start with everything in Postgres and spin things out as you scale. **What do you dislike about PostgreSQL?** Not much; integrated connection pooling would be nice. And a native column store option. **What problems is PostgreSQL solving and how is that benefiting you?** Full stack webapp deployment. Postgres has allowed us to deploy and iterate rapidly. ### 36. THE preferred solution for an open source relation database **Rating:** 5.0/5.0 stars **Reviewed by:** Wade W. | Director of Information and Analytics, Mid-Market (51-1000 emp.) **Reviewed Date:** July 27, 2021 **What do you like best about PostgreSQL?** Postgres has many of the features that I have come to enjoy in more enterprise-scale databases, with the benefit of an open-source pricetag and community support. **What do you dislike about PostgreSQL?** If you are looking for a vendor, Postgres isn't your tool. In many ways though, that is a positive. **Recommendations to others considering PostgreSQL:** If you are comfortable doing a little sys admin work to get it up and running, you probably already know that Postgres is the way to go. **What problems is PostgreSQL solving and how is that benefiting you?** Postgres was our primary data store for many years for our centralized data warehouse. Any relational data can be stored in Postgres, and there is broad support for clients and other tools to interact with that data. ### 37. Great choice database for relational model structurr **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** May 15, 2022 **What do you like best about PostgreSQL?** Dynamic creation of tables/models differenciate from other databases **What do you dislike about PostgreSQL?** Nothing which I can think of and its best and mostly used database **Recommendations to others considering PostgreSQL:** PostgreSQL is most widely used database worldwise **What problems is PostgreSQL solving and how is that benefiting you?** Relational database structure with dynamic model generation ### 38. PostgreSQL - is the greatest database software **Rating:** 4.5/5.0 stars **Reviewed by:** Krinal P. | Software Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** September 11, 2021 **What do you like best about PostgreSQL?** The bash shell script may be used to perform psql commands. Execution time notifications should be shown in the data/log folder's log file. In order to maximise performance, a prepared statement is used. PostgreSQL comes with built-in extensions. PostgreSQL offers a great deal of flexibility. Data types, indexes, functional languages, etc. may be customised. **What do you dislike about PostgreSQL?** few tools can be integrated with MySQL but not with PostgreSQL. **What problems is PostgreSQL solving and how is that benefiting you?** A relational database management system, PostgreSQL is a sophisticated, enterprise-class, open-source database management system. Data is saved in RDBMS tables, which are database objects that contain data. In a table, the columns and rows are used to group related data items. As a result of PostgreSQL, you may access and alter databases. ### 39. Good Database You Need **Rating:** 4.5/5.0 stars **Reviewed by:** Chandresh M. | System Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** September 07, 2021 **What do you like best about PostgreSQL?** The thing I like about the PostgreSQL database is it is open-source available. So, I can modify it based on my business requirement. Another thing is, it is very easy to learn. You don't need any extra time to learn if you know a little bit of SQL. You can also import/export databases in PostgreSQL. **What do you dislike about PostgreSQL?** The Dashboard of PostgreSQL is very complex. Sometimes, you need to find what are the options you want to use. So first I have to read its documentation, then I'll understand, which required more time. **Recommendations to others considering PostgreSQL:** I would recommend if you have basic knowledge of SQL, then you should use this database. **What problems is PostgreSQL solving and how is that benefiting you?** I am using PostgreSQL for creating websites and other applications. ### 40. OpenSource DB **Rating:** 5.0/5.0 stars **Reviewed by:** ercument y. | ERP Software Development Specialist, Mid-Market (51-1000 emp.) **Reviewed Date:** November 19, 2021 **What do you like best about PostgreSQL?** Being open source is very good in terms of license fees. It is advantageous to have easy backup and restore in postgre. **What do you dislike about PostgreSQL?** postgre is a little weak compared to its alternatives in performance metrics. **Recommendations to others considering PostgreSQL:** It is free and open source software. This means that you will never have to pay anything for this service. **What problems is PostgreSQL solving and how is that benefiting you?** I am using the mobile application to keep the web service log information. The fast work of successful inquiries was a factor in my preference. ### 41. Easy to use **Rating:** 4.5/5.0 stars **Reviewed by:** Akshay P. | Freelance, Small-Business (50 or fewer emp.) **Reviewed Date:** January 24, 2022 **What do you like best about PostgreSQL?** Easy to use and simple. I have used it couple of times but it doesn't feel like i am working on it for the first time **What do you dislike about PostgreSQL?** The think which i dislike is the side panel which is congested **What problems is PostgreSQL solving and how is that benefiting you?** Problems related database for my projects ### 42. Postgresql is the Excellent ORDBMS **Rating:** 5.0/5.0 stars **Reviewed by:** Jimesh S. | Senior Software Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** October 10, 2021 **What do you like best about PostgreSQL?** PostgreSQL supports geographic objects, which enables it to be used for location-aware services and geographic information systems. Queries are simple to write since they do not need any training. Additionally, PostgreSQL supports multiversion concurrency control(mvcc). **What do you dislike about PostgreSQL?** In order to complete the upgrade procedure, more storage will be needed. **What problems is PostgreSQL solving and how is that benefiting you?** PostgreSQL is a commonly used Object-Relational Database Management System (ORDBMS) (ORDBMS). As a result, businesses are increasingly turning towards PostgreSQL because it can handle massive amounts of complex data. This is the foremost reason behind PostgreSQL is more capable of coping with very stressful database conditions. ### 43. 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 ### 44. Great Data storage tool **Rating:** 5.0/5.0 stars **Reviewed by:** Shubham M. | S, Small-Business (50 or fewer emp.) **Reviewed Date:** October 28, 2021 **What do you like best about PostgreSQL?** The easy to install and use database app for local storage or web applications **What do you dislike about PostgreSQL?** I wish we could install postgres integrated in Visual Studio or Pycharm so it would be easy to check and not go back and forth. **What problems is PostgreSQL solving and how is that benefiting you?** using it for developing full-stack web applications. ### 45. Super great value database **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Financial Services | Mid-Market (51-1000 emp.) **Reviewed Date:** April 29, 2022 **What do you like best about PostgreSQL?** PostgreSQL is open source so great value **What do you dislike about PostgreSQL?** There isn't anything I didn't like about it. **Recommendations to others considering PostgreSQL:** Do it - fully functional open source product **What problems is PostgreSQL solving and how is that benefiting you?** Using to power DevOps tooling ### 46. Very advanced RDBMS with a wide variety of data types to use **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Small-Business (50 or fewer emp.) **Reviewed Date:** February 18, 2022 **What do you like best about PostgreSQL?** It is very easy to use for people who already know some basic SQL. **What do you dislike about PostgreSQL?** performance-wise it is slower than MySQL **Recommendations to others considering PostgreSQL:** It is the best relational database amongst the options I feel **What problems is PostgreSQL solving and how is that benefiting you?** I have loved working with Postgres as knowing SQL has definitely helped due to similar syntax. The join makes it all the more interesting once you start using them. ### 47. PostgreSQL as persistence provider with IOT Platform -Thingworx **Rating:** 4.5/5.0 stars **Reviewed by:** Abdulla C. | Senior Manager - Digital Transformation Solutions , Enterprise (> 1000 emp.) **Reviewed Date:** January 24, 2022 **What do you like best about PostgreSQL?** Performance and Ease of working with PostgreSQL with small to medium application development **What do you dislike about PostgreSQL?** Scalability is limited, and performance degrades as scaled to large applications **What problems is PostgreSQL solving and how is that benefiting you?** Storing data and value streams for reports and analytics ### 48. Best database in market **Rating:** 4.5/5.0 stars **Reviewed by:** Rahul N. | Data Research Analyst, Mid-Market (51-1000 emp.) **Reviewed Date:** September 05, 2021 **What do you like best about PostgreSQL?** It works robustly, Well supported by backend frameworks. Stability and ability to handle structured data are pretty good. **What do you dislike about PostgreSQL?** Configuration can be a little overwhelming for those who are new, but users can refer - https://www.postgresql.org/docs/ for better understanding. **What problems is PostgreSQL solving and how is that benefiting you?** I use it for database management; it is reliable and safe to use. New users can learn from - https://www.youtube.com/watch?v=eMIxuk0nOkU ### 49. 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. ### 50. Best Relational Database **Rating:** 5.0/5.0 stars **Reviewed by:** Kishan K. | Data Analyst, Mid-Market (51-1000 emp.) **Reviewed Date:** June 17, 2021 **What do you like best about PostgreSQL?** 1) It is a free and open-source database system. 2) It is secure and robust compared to other relational database systems. 3) Easy to store large amount of structured data in the database system. 4) Querying time is super fast and quick. 5) Frequent updates from time to time. **What do you dislike about PostgreSQL?** 1) It is a bit confusing compared to other database systems. 2) Sometimes slow with big queries. 3) Apart from these cons, it's a great relational database system. **What problems is PostgreSQL solving and how is that benefiting you?** 1) Free SQL Database system 2) History of queries 3) Data analysis 4) Temporary tables querying ## 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=4&qs=pros-and-cons§ion=pricing&secure%5Bexpires_at%5D=2026-08-05+12%3A47%3A10+-0500&secure%5Bsession_id%5D=4893c3e9-55c1-4c10-a375-4cad8ec97982&secure%5Btoken%5D=2815cf20caddbf3087e574a63f0debf4cca384a7e4fb14e4694d1554f4a94cb3&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,583 reviews) - [Oracle Database](https://www.g2.com/products/oracle-database/reviews) - 4.3/5.0 (933 reviews)