--- title: PostgreSQL Reviews meta_title: 'PostgreSQL Reviews 2026: Details, Pricing, & Features | G2' meta_description: Filter 683 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: 683 scale: '5' date_modified: '2026-06-25' 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:** 683 ## About PostgreSQL PostgreSQL is a powerful, open-source object-relational database system renowned for its reliability, extensibility, and adherence to SQL standards. Originating from the POSTGRES project at the University of California at Berkeley in 1986, it has evolved over nearly four decades into a robust platform capable of handling complex data workloads across various operating systems. PostgreSQL's architecture emphasizes data integrity and scalability, making it a preferred choice for developers and organizations worldwide. Key Features and Functionality: - Comprehensive Data Types: Supports a wide range of data types, including primitives (Integer, Numeric, String, Boolean), structured (Date/Time, Array, Range), document (JSON/JSONB, XML), and geometric types. - Advanced Data Integrity: Ensures data accuracy through features like UNIQUE constraints, primary and foreign keys, exclusion constraints, and various locking mechanisms. - High Performance and Concurrency: Utilizes advanced indexing methods (B-tree, GiST, GIN, BRIN), a sophisticated query planner, multi-version concurrency control (MVCC), parallel query execution, and table partitioning to optimize performance. - Reliability and Disaster Recovery: Offers write-ahead logging (WAL), various replication methods (asynchronous, synchronous, logical), point-in-time recovery (PITR), and active standbys to ensure data durability and availability. - Robust Security Measures: Provides multiple authentication methods (GSSAPI, SSPI, LDAP, SCRAM-SHA-256, Certificate, OAuth 2.0), a comprehensive access-control system, and supports multi-factor authentication. - Extensibility: Allows the creation of custom data types, functions, and operators. Supports procedural languages like PL/pgSQL, Perl, Python, and Tcl, with additional languages available through extensions. Primary Value and User Solutions: PostgreSQL addresses the needs of developers and organizations by offering a highly extensible and standards-compliant database system that ensures data integrity, scalability, and robust performance. Its open-source nature allows for continuous innovation and adaptability, enabling users to tailor the database to their specific requirements. Whether managing small applications or large-scale enterprise systems, PostgreSQL provides a reliable foundation for storing and processing data efficiently. ## PostgreSQL Pros & Cons **What users like:** - Users appreciate the **powerful and flexible features** of PostgreSQL, enhancing control and simplifying complex data management. (13 reviews) - Users find PostgreSQL to have a **user-friendly interface** , making it easy to handle and integrate for all levels. (11 reviews) - Users commend the **reliability** of PostgreSQL, noting its data integrity and impressive crash handling capabilities. (9 reviews) - Users appreciate the **flexibility** of PostgreSQL, enabling customization and scalability for diverse project needs. (8 reviews) - Users appreciate the **open-source flexibility** of PostgreSQL, enabling cost-effective solutions with robust features and strong community support. (8 reviews) - Users highlight the **scalability** of PostgreSQL, noting its stability and ease of scaling for diverse projects. (8 reviews) - Data Analytics (6 reviews) - Users find **easy integrations** with PostgreSQL, effortlessly implementing it across various systems and programming languages. (6 reviews) - Performance (6 reviews) - Data Security (4 reviews) **What users dislike:** - Users find PostgreSQL **beginner unfriendly** due to its steep learning curve and complex configuration requirements. (7 reviews) - Users find PostgreSQL's **complexity in performance tuning and configuration** challenging, especially for those unfamiliar with advanced setups. (6 reviews) - Users find the **learning curve steep** for PostgreSQL, especially regarding performance tuning and advanced configurations. (5 reviews) - Users find the **slow performance** of PostgreSQL frustrating, especially with large datasets and complex queries. (5 reviews) - Users find **complex configuration** requirements challenging, especially for tuning performance and managing replication effectively. (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. (3 reviews) - Complex Setup (2 reviews) - Difficult Setup (2 reviews) - Scaling Issues (2 reviews) ## PostgreSQL Reviews ### 1. Simply an amazing tool **Rating:** 5.0/5.0 stars **Reviewed by:** Diego G. | Engineering Lead, Mid-Market (51-1000 emp.) **Reviewed Date:** November 22, 2024 **What do you like best about PostgreSQL?** It's very powerful and versatile, and has a huge ecosystem built around it. It's the de-facto solution for so many problems nowadays. **What do you dislike about PostgreSQL?** Not about PostgreSQL itself, but the fact that the major cloud providers don't keep well enough with all the latest developments **What problems is PostgreSQL solving and how is that benefiting you?** It stores all kinds and shapes of data and lets us query it in many ways ### 2. PostgreSQL: Most popular SQL DBMS Software **Rating:** 5.0/5.0 stars **Reviewed by:** NAYAN K. | Data Scientist, Mid-Market (51-1000 emp.) **Reviewed Date:** July 26, 2024 **What do you like best about PostgreSQL?** Simple and Easy to use. I really like the PG admin UI which is really very user friendly. Installed and Builder stack are easy to implement. Can connect with Python with ease. I use it frequently for my day to day RDBMS use. Canbe easily integrated with python. **What do you dislike about PostgreSQL?** There should be some more extensions with widely used open source software/apps. **What problems is PostgreSQL solving and how is that benefiting you?** RDBMS Application and Easy to use PG admin UI which can be easily integrated with Python for my data science projects. ### 3. Integrating Cube analytics in Postgresql **Rating:** 5.0/5.0 stars **Reviewed by:** CHIRADEEP B. | Associate Technology, Enterprise (> 1000 emp.) **Reviewed Date:** May 18, 2024 **What do you like best about PostgreSQL?** Very easy to use and set up PostgreSQL comes with a very easy to use UI ( User Interface ) tool like PG-Admin for every client to connect & Interact with the database. PG Admin is very easy to use & setup with just a mouse click unlike other traditional RDBMS . I highly recommend PostgreSQL for every client to connect & Interact, apart from MYSQL. **What do you dislike about PostgreSQL?** Nothing as such, sometimes query execution get delayed but that is very rare. Overally its a very light-weight & user friendly tool for ervery client who want to connect with the database seamlessly. I **What problems is PostgreSQL solving and how is that benefiting you?** It enables me to check transcation count of every user, enables all trigger , procedures, function and other PL/SQL operation seamlessly. It also helps to perform and execute multiple joins operation in the event of requirement of data from multiple table to retrieve the result. Postgresql also enables aggregate function( MIN, MAX, AVG, COUNT, SUM, AVG) and views, cursor, Index. ### 4. PostgreSQL : user review **Rating:** 5.0/5.0 stars **Reviewed by:** Ashwini B. | Software Developer, Small-Business (50 or fewer emp.) **Reviewed Date:** April 23, 2024 **What do you like best about PostgreSQL?** PostgreSQL is easy to use in daily development life. Developer can easily implement and integrate it into system by using gem postgres. It has different versions for operating system. It is open source relational database model and i can use it in operating system like window , ubuntu, mac ect. Most of the developer use it frequently. **What do you dislike about PostgreSQL?** When i execute large data query or complex query application stop responding. It has enormous number of users so customer support may take time to resolve query. **What problems is PostgreSQL solving and how is that benefiting you?** Its make my devlopment process smooth. It help to store users , orders data of my application, which help me to analyze data of users. Also i can hit complex queries to fetch data. It store tremendous data into it. ### 5. PostgreSQL is robust database to rely on. **Rating:** 4.5/5.0 stars **Reviewed by:** Aavinashh L. | Manager Dashboards and Business Intelligence , Enterprise (> 1000 emp.) **Reviewed Date:** October 13, 2024 **What do you like best about PostgreSQL?** Its wonderful DBMS that has wide range of extentions and relaibiility features with great customer support **What do you dislike about PostgreSQL?** It has one feature that needs improvement on resources useage as it uses lots of your system resources. **What problems is PostgreSQL solving and how is that benefiting you?** Its very trusted RDBMS and give me comfort on using it for day to day operational load without getting worried. ### 6. It has the most intuitive UI **Rating:** 4.5/5.0 stars **Reviewed by:** Rodrigo A. | Media Activation Manager, Mid-Market (51-1000 emp.) **Reviewed Date:** September 27, 2024 **What do you like best about PostgreSQL?** It's super easy to understand, implement, and adapt to any data lake. PostgreSQL has implemented many features to facilitate joint and data selections **What do you dislike about PostgreSQL?** I can't complain about anything about postgreSQL **What problems is PostgreSQL solving and how is that benefiting you?** Storing data, data relations, and Data Processing. Connect with Power Bi is a great feature ### 7. Powerful Open Source RDBMS **Rating:** 4.5/5.0 stars **Reviewed by:** madhusudan rao y. | Vice President Of Engineering, Small-Business (50 or fewer emp.) **Reviewed Date:** September 14, 2023 **What do you like best about PostgreSQL?** Open Source database with a very active and passionate community. Supports SQL and enterprise applications. One of the best relational databases around that can be used to support various multimedia. Very fast and able to provide access based user logins to the database **What do you dislike about PostgreSQL?** Initial setup is not straightforward. Getting through the very customizable options is difficult if you are just starting out. Not an easy task for a beginner to start with. Limited GUI tools. Puts off many new users who are just starting on this journey as most of the new programmers are more habituated to a visual interface. **What problems is PostgreSQL solving and how is that benefiting you?** Postgres was the option we chose as it has extensive support for working with JSON type and JSON blobs apart from other multimedia support. Has a very active and passionate community supporting the project. Documentation is very helpful. ### 8. Better than non-free RDMBS **Rating:** 4.5/5.0 stars **Reviewed by:** Antonio H. | Jefe de proyecto , Telecommunications, Enterprise (> 1000 emp.) **Reviewed Date:** March 27, 2024 **What do you like best about PostgreSQL?** PostgreSQL allows us to manage our Dashboards generated using OLAP cubes with amazing speed and reliability. Also, its possibility of using it in Cluster format provides us with a lot of value, guaranteeing accessibility and availability of data, as well as backup copies. The beauty of this software is in the simplicity. **What do you dislike about PostgreSQL?** Very few systems can compare with PostgreSQL in my opinion (and integrated with PostGIS, it is great!). But it is true that payment systems such as SQL Server or Oracle have more configuration options, which can be useful for advanced installations. **What problems is PostgreSQL solving and how is that benefiting you?** In certain RDMBS, when processing needs increase, real speed bottlenecks occur. With PostgreSQL this has never happened to us, and its management system is exceptional, and always with the information very accessible and displayed in a simple and intuitive way. ### 9. PostgreSQL : Top Open Source RDBMS Choice **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** January 18, 2024 **What do you like best about PostgreSQL?** Its best thing is , it is open source. Other things i like about postgreSQL is its vast range of Data Types like JSON, Arrays, Custom data types, custom functions and operators. It gives good flexiblity. It can handle huge amount of data, high traffic loads. It is suitable for both large and small scale applications. I love its command line interface. It is easy to setup. It can be integrated everywhere. As it has large and active community it provides regular updates and bug fixes. **What do you dislike about PostgreSQL?** As it has wide range of feature it may take some time to learn for beginners. Its UI tool is not that user-friendly, I rarely use it. 1 Feature they can have is distributed computing. **What problems is PostgreSQL solving and how is that benefiting you?** PostgreSQL provides a open source RDBMS. Its open source feature benifits everyone. Also it handle huge amount of data, as it is RDBMD it is quite faster than other databases. It offeres advanced indexing. It provides wide range of data types and also custom data types. ### 10. Postgresql :- A New Trendy Relational and Open source database management tool **Rating:** 4.5/5.0 stars **Reviewed by:** Subrat P. | Project Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** January 29, 2024 **What do you like best about PostgreSQL?** Postgresql is very easy to use in its pgAdmin and also in other enterprise application like DBeaver. I most like about its connectivety with clouds like AWS's RDS service etc. Best relational and open source database in term of easy to use, database recovery, backup, maintenance and its connectivety. **What do you dislike about PostgreSQL?** For beginners its initial setup complexity or the learning curve for advanced features and it's configurations little bit hard because its initial setup is not straightforword specially its port availibilty. Some user may get confused with icons of Postgresql because it may differ from MySQL, Oracle. **What problems is PostgreSQL solving and how is that benefiting you?** PostgreSQL addresses various database challenges, offering benefits like scalability like table partitioning and built-in replication , open-source , flexibility that supports various data types , indexing methods, and procedural languages . Users find it valuable for their applications, enabling them to manage data effectively and reliably. ### 11. PostgreSQL is very help for me to find the Accurate data **Rating:** 5.0/5.0 stars **Reviewed by:** Nitin G. | Business analyst, Small-Business (50 or fewer emp.) **Reviewed Date:** April 24, 2024 **What do you like best about PostgreSQL?** PostgreSQL is very easy to use and eady to implementation but i can use cusotmer support of this tools its very frquent to use any person can easy learn and very fast way lots of features available in PostgreSQL like how to import data in very easy way and very easy to integration also customer support might be good not sure about this. **What do you dislike about PostgreSQL?** It will take some time to open and import data from CSV file **What problems is PostgreSQL solving and how is that benefiting you?** PostgreSQL is very help to find the accurate data from data sheet like excel and provide perfect data that client required. ### 12. PostgreSQL gives you more flexibility in data types, scalability, concurrency, and data integrity. **Rating:** 4.5/5.0 stars **Reviewed by:** Riyas R. | Manager, Information Technology and Services, Small-Business (50 or fewer emp.) **Reviewed Date:** April 01, 2024 **What do you like best about PostgreSQL?** PostgreSQL offers a powerful GIS extension called "PostGIS" that provides hundreds of functions for processing geometric data. **What do you dislike about PostgreSQL?** PostgreSQL may have slower performance than other RDBMS like SQL Server and MySQL. **What problems is PostgreSQL solving and how is that benefiting you?** PostgreSQL is known for its stability and low data corruption rate, making it suitable for large-scale applications that require high availability and uptime. It can help with business problems such as data organization, data accessibility, data security, data analysis, and compliance. ### 13. Review related to postgresql **Rating:** 5.0/5.0 stars **Reviewed by:** ANUJ R. | Technical Lead, Small-Business (50 or fewer emp.) **Reviewed Date:** July 11, 2024 **What do you like best about PostgreSQL?** Best RDBMS tool in the market. Its simple to install, configure and use. It support sql language do DDL DML operations , which supports both OLAP and OLTP workload **What do you dislike about PostgreSQL?** Nothing I felt. Everything is simple and easy. **What problems is PostgreSQL solving and how is that benefiting you?** It provide database solution for my OLAP AND OLTP workload . Helps to save records in form of tables in database ### 14. One of the best database **Rating:** 4.5/5.0 stars **Reviewed by:** Vaibhav K. | Associate Software Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** February 15, 2024 **What do you like best about PostgreSQL?** If you are finding databases alternatives to use with your env then postgresql is one of the best choice i can say. Because it provides a robust and powerful architecture. Anybody want to start to have the knowledge of databases then i can say use the postgresql so that you will have the lots of think clear in your mind and also by passing sometime you definetily love the postgresql database. Quering to postgresql is very much simple and anybody can understand. there are lot to add but you should use postgresql. **What do you dislike about PostgreSQL?** Sometimes launching pg admin takes sometime. **What problems is PostgreSQL solving and how is that benefiting you?** It has ighly reliable RDMS and its opensource so anybody can use it for free. Also it has high transaction speed and fast data aggregation. Also quering to postgres is much simpler. ### 15. A great open source database **Rating:** 4.0/5.0 stars **Reviewed by:** Henry C. | Mid-Market (51-1000 emp.) **Reviewed Date:** December 19, 2023 **What do you like best about PostgreSQL?** I think it is really well documented, you can find lots of free tutorials en webpages and youtube. You can configure it to fit your requirements. It also has a lot of functionalities, I think it is one of the most advanced databases available right now. You can integrate PostgreSQL with a lot of different tools, and it provides great advantages for your use. **What do you dislike about PostgreSQL?** It can be a little tricky for starters, because the inital configuration can be a little cumbersome, but I think it is not a big deal since you have support online where you can find a lot of tutorials. **What problems is PostgreSQL solving and how is that benefiting you?** Some of our databases are running using PostgresSQL as engine. We use them through RDS in AWS. ### 16. PostgreSQL: The world's most advanced open source database **Rating:** 5.0/5.0 stars **Reviewed by:** Shwetank S. | Software Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** September 29, 2023 **What do you like best about PostgreSQL?** postgresql is highly secured.it has SSL certificates for encrypted connections which tells us how secure is it. you can give the accesss basd on role and define the custom rules.i like the perfomance of it in terms of how fast it is it provides you the facilities like indexing, query optimisation etc. so performance wise its beating its competitors in the market. its reliable and stable many companies use this in the production which tells us the trust of companies on its security aspects.its easy to use as a beginner anyone can understand it easily. **What do you dislike about PostgreSQL?** its setp and configurations are little bit complex.when you will trigger big queries it occupies larges space so its kind of resource intensive so you may see sometimes performance scaling becomes the major concern. **What problems is PostgreSQL solving and how is that benefiting you?** i work as a full-stack developer so i use postrgesql for storing and fetching the data throun api's which i create for my full-stack application ### 17. Awesome Relational Database management tool! **Rating:** 4.5/5.0 stars **Reviewed by:** Rohit M. | Cloud Analyst, Mid-Market (51-1000 emp.) **Reviewed Date:** September 26, 2023 **What do you like best about PostgreSQL?** PostgreSQL is a great open source Relational database managent tool,it supports Query langueage which is way similar to famous SQL languages that means if anybody have ever worked on SQL then moving onto the PostgreSQL wont take much efforts.it supports all the major data types used in database processing and also gives security related features like role based access and authentication which is the most important feature because it is going to store the confidential information. **What do you dislike about PostgreSQL?** i have used postgreSQL locally and over a cloud enviroment, the setup was easy on cloud enviroment but i was continuesly facing a issue for very long time, it was throwing me out of the current session for no reason, i was not able to identify the root cause of this problem but this is something any user wont want to face when he is working on database or storage related tool. locally i have found no issue at all. **What problems is PostgreSQL solving and how is that benefiting you?** PostgreSQL is offers a storage solutions for users and related feature to maintain and process the information and files stored in the databases. it support relational databases and we can stores informartion in the form of tables and schemas. security wise PostgreSQL offer very good services we have a very good experience with this tool. ### 18. Unveiling the Power and versatility of an open source database solution **Rating:** 4.5/5.0 stars **Reviewed by:** Shree P. | Small-Business (50 or fewer emp.) **Reviewed Date:** January 18, 2024 **What do you like best about PostgreSQL?** PostgreSQL impresses with its robustness, ACID Compliance , and extensibility . Its commitment to standards, comprehensive documentation and strong community support contribute to a reliable and feature rich database management system . The flexibility to handle diverse data types and advanced indexing capabilities further solidify postgreSQL standing as a top choice for data driven applications **What do you dislike about PostgreSQL?** While postgreSQL is feature-rich,its initial setup complexity can be a drawback for newcomers. Additionally, certain performances optimizations may require fine tuning , demanding a deeper nuances, the benifits often outweigh these challenges in the long run **What problems is PostgreSQL solving and how is that benefiting you?** PostgreSQL addresses data management challenges by providing a scalable , open source solution with robust features , ensuring data integrity and flexibility in handling diverse workloads, ultimately benifiting users with a reliable and adaptable database platform ### 19. PostgreSQL: A Balanced Assessment of Its Strengths and Challenges **Rating:** 5.0/5.0 stars **Reviewed by:** Alexandre G. | Analista de dados, Small-Business (50 or fewer emp.) **Reviewed Date:** August 29, 2023 **What do you like best about PostgreSQL?** PostgreSQL is recognized as one of the most advanced and robust open-source relational database management systems available. Strengths: Open Source: Being under an open-source license allows the community to actively contribute to its development, which accelerates the introduction of new features and fixes. SQL Compliance: PostgreSQL offers a high degree of compliance with the ANSI SQL standard, which facilitates migration from other database management systems. Extensibility: PostgreSQL supports the definition of custom types, functions, and operators. This allows developers to expand its capabilities according to specific needs. Advanced Features: It offers advanced features such as the ability to store JSON data, support for full-text search, partitions, triggers, materialized views, and geospatial extensions (PostGIS). Security: It offers a variety of security mechanisms, including authentication, role-based access control, and encryption of data at rest and in transit. **What do you dislike about PostgreSQL?** Performance Under Extremely High Loads: Compared to some commercial solutions, PostgreSQL may not be as optimized for extreme load scenarios, although for most applications, it is more than adequate. Management Tools: While PostgreSQL has PgAdmin as its main graphical interface, it may not be as refined or as feature-rich as some commercial tools available for other database management systems. Replication and High Availability: Although PostgreSQL offers solutions for replication and high availability, the configuration and management of these solutions can be more complex compared to some integrated commercial solutions. Documentation: Although PostgreSQL's documentation is comprehensive, it can be dense and sometimes difficult for beginners. It could benefit from more practical tutorials or usage examples. Complexity: Due to its extensibility and wealth of features, PostgreSQL can be perceived as complex for new users or for those coming from simpler solutions. **What problems is PostgreSQL solving and how is that benefiting you?** Cost Economy: As an open-source solution, PostgreSQL offers a robust alternative to often expensive commercial database management systems. This allows companies and individual developers to have a powerful option without the associated costs. Extensibility: PostgreSQL allows developers to create custom types, functions, and operators. This is extremely valuable for applications that require deep customization or that work with unconventional data types. Standards Compliance: Its high compliance with the ANSI SQL standard makes it easier for developers to work with PostgreSQL and transfer knowledge from other database management systems. Advanced Features: PostgreSQL supports advanced features such as JSON data, full-text search, and geospatial extensions (PostGIS). This makes it suitable for a variety of modern applications, from content management systems to geolocation solutions. Security: PostgreSQL has multiple layers of security, including authentication, role-based access control, and data encryption. This benefits applications that require a high level of security for sensitive data. Scale and Performance: While there are other database management systems that excel specifically in high-load scenarios, PostgreSQL is suitable for a wide variety of applications, from small projects to medium-sized enterprise systems. ### 20. Postgres is so amazing, I started a company around it :) **Rating:** 5.0/5.0 stars **Reviewed by:** Ry W. | Founder/CEO, Computer Software, Small-Business (50 or fewer emp.) **Reviewed Date:** June 04, 2024 **What do you like best about PostgreSQL?** There are many valuable Postgres extensions. **What do you dislike about PostgreSQL?** There is nothing that I dislike about Postgres. **What problems is PostgreSQL solving and how is that benefiting you?** Postgres is the most beloved relational database for good reason. It's now capable to help with not just transactional workloads, but also analytical and AI workloads as well. ### 21. PostgreSQL Review: Exploring the Power of Open Source Database **Rating:** 5.0/5.0 stars **Reviewed by:** Crysthel Jane S. | Junior Software Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** April 22, 2024 **What do you like best about PostgreSQL?** I do really appreciate it's robustness, extensibility and it's strong community support. **What do you dislike about PostgreSQL?** Maybe what I dislike on it is the complexity for beginners but once tou got it, it's incredibly powerful. **What problems is PostgreSQL solving and how is that benefiting you?** It solves data storage, offers reliability and advance features which helps me by providing a solid foundation for building efficient applications. ### 22. A great free and open source RDBMS tool for your database needs **Rating:** 4.0/5.0 stars **Reviewed by:** Ashish A. | QA Engineer, Computer Software, Small-Business (50 or fewer emp.) **Reviewed Date:** September 25, 2023 **What do you like best about PostgreSQL?** - It's an open source and free platform for creating and managing relation databases, we used this for all our RDBS needs and since we are a start-up it saved a lot of cost for us in terms of being free and open source. - It's easy to use and syntactically similar to popular databases like SQL and it helps anyone in the term to learn and quickly adept. -It's easy to setup even if you are using this on a Google cloud, just do a SSH and you will be able to connect to the postgres instance. **What do you dislike about PostgreSQL?** The default user interface is not very feature rich and keeps disconnecting after some session time, there are tools which can be used deparately but if PostgreSQL can improve their user interface it'll be lot better. Even though I am used to command line tool. **What problems is PostgreSQL solving and how is that benefiting you?** - We are using it to store all our user data, catalog data and analytics in the DB. So we are solving the problem of storage, and being free and open source it gives us more flexibility to use (without costing us any money) - This data is then passed on to the NOSQL DB like Bigquery - We also use Postgres to load data which is shared by the external business vendors like catalog data providers ### 23. Enterprise-grade open source RDBMS with extension **Rating:** 4.5/5.0 stars **Reviewed by:** Frantisek B. | CTO, Information Technology and Services, Small-Business (50 or fewer emp.) **Reviewed Date:** November 27, 2023 **What do you like best about PostgreSQL?** Probably the best open source SQL solution, universal use due to the possibility of installing extensions. Easy administration and High availability in combination with patroni and etcd. Commercial support by some companies. Useful extensions: PostGIS : geography data TimescaleDB: time series data with automatic partitions, automatic aggregation and deletion Several options for HA. Several options for backup and recovery, i personally user Barman (pgbarman.org) Easy of deployment with containers (Docker, podman, Kubernetes). **What do you dislike about PostgreSQL?** Does not support automatic creation of partitions. For automatic partition it is possible to use triggers and PL/pgSQL, extension pg_partman (you have to do manually while locking the database tables) a my preferred way timescaleDB extension and hypertables. **What problems is PostgreSQL solving and how is that benefiting you?** Open source replacement of Oracle RDBMS ### 24. Secure, Powerful and Open-source database management system **Rating:** 5.0/5.0 stars **Reviewed by:** Michelle C. | Director KPMG, Information Technology and Services, Mid-Market (51-1000 emp.) **Reviewed Date:** July 04, 2023 **What do you like best about PostgreSQL?** PostgreSQL is a powerful open-source object-relational database management system. It is one of the highly used databases across different organizations worldwide. It can run all operating systems and manage data held in relational databases. It provides support for a variety of data such as images, text, video, audio, and more. It is very easy to learn for new developers as it supports all SQL features and we can add extensions to enable additional functions. A user can work with PostgreSQL either through the CLI interface or through the pgAdmin desktop application. Once you enter the credentials to connect pgAdmin app with the database all the queries and operations will be in sync with the CLI interface as well. **What do you dislike about PostgreSQL?** The only drawback I found using PostgreSQL is that the initial setup is a bit challenging. Sometimes it creates difficulties in creating new users for PostgreSQL and setting up credentials to log in to the database. If this could be made easy it will really help and save us a lot of hours of configuration time. **What problems is PostgreSQL solving and how is that benefiting you?** My organization uses PostgreSQL as a primary solution for storing, retrieving, and manipulating data in Relational databases. We store users' data such as profile information, images, texts, and transaction details in the PostgreSQL database. We integrated PostgreSQL with DataGrip by Jetbrains to get a UI view of data that saves a lot of time and resources in running queries to view data. It can perform queries in milliseconds in petabytes of data. It maintains data integrity, security, and validation on the go and is easily scalable to size limits. Also, it allows developers to run it on container and virtual machines. The multiple language support and similarity with SQL make it easy to onboard new developers. ### 25. An opensource and reliable DB with essential functionalities **Rating:** 4.0/5.0 stars **Reviewed by:** Jainesh K. | Senior Software Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** August 31, 2023 **What do you like best about PostgreSQL?** - It's open-source which means without paying a penny we can leverage a variety of database features with regular improvements and bug fixes provided by community members. - It's a scalable database that can be used for a variety of applications. -Its JSONB support makes It easier to work with JSON types and we can work on relational as well as non-relational data on the same system. - Full text search feature is also provided by PostgreSQL which can help in a variety of applications. **What do you dislike about PostgreSQL?** - There are some opensource apps that might not support PostgreSQL but MySQL because It is not owned by a single entity and hence lacks the recognition It deserve. - Might not be a good solution for the shared dataset as there is no out of the box approach available for it in PostgreSQL. - It might have a steep learning curve for beginners. **What problems is PostgreSQL solving and how is that benefiting you?** - Using relational and non-relational data on the same system as It handles JSON data type very gracefully thanks to JSONB. - It can significantly help in improving your application cost as Its available free of cost. - Works well with large data/applications as well. - Strong support from a larger developers community makes It reliable and easy to use. ### 26. Great services and simple db to use **Rating:** 4.0/5.0 stars **Reviewed by:** Kaustubh K. | Devops Engineer, Computer Software, Mid-Market (51-1000 emp.) **Reviewed Date:** August 24, 2023 **What do you like best about PostgreSQL?** PostgreSQL is open source database management solution. For SQL queries, it supports both SQL and JSON. Also we can use complex data types and performance optimisation tools that we would normally only find in pricey commercial databases. And as per the develoeprs view we can create custom data types , functions and all and if configured correctly , we can perform complex data operation , recursive queries and many more. **What do you dislike about PostgreSQL?** If we talk. About the speed then mysql is works beeter in that but PostgreSQL works more on compatibility. And also just one thing that many open source application support needs to be given in PostgreSQL.to add this just one thing if it is not configured correctly , it can give issues while optimisation. **What problems is PostgreSQL solving and how is that benefiting you?** I've used that in web apps and websites.As it is open source so we can use it it without any limitation without any restrictions.Also I didn't get too much of training to use PostgreSQL. As it is very easy to use. ### 27. powerful object-relational database: PostgreSQL **Rating:** 5.0/5.0 stars **Reviewed by:** Deepak o. | Software Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** September 29, 2023 **What do you like best about PostgreSQL?** 1- its perfomance is awesome. 2- its response time analysis of query 3- its features like indexing to optimse your query. 4- its easy to use 5- its beginner friendly **What do you dislike about PostgreSQL?** 1- resource intensive and sometimes it lags 2-once the data is lost then it becomes diffucult and complex to back it 3- when i started working with it i found its setup and configuration is little bit difficult. **What problems is PostgreSQL solving and how is that benefiting you?** i work on backend application so i connect my application with postgresql and use it for data transfer and storing the data for my organisation ### 28. Postgre SQL Review **Rating:** 4.5/5.0 stars **Reviewed by:** Dinesh S. | Team leader, Information Technology and Services, Small-Business (50 or fewer emp.) **Reviewed Date:** October 26, 2023 **What do you like best about PostgreSQL?** Postgre is a database where we have execllent features in wrinting the complex sql queries and easy connection of databases by database integration.The application installation and implementation is easy and the saved data and query does not erase whcih makes way to execute the query often. **What do you dislike about PostgreSQL?** The table result set displays only for certain number of rows as it has some limitations.We need to export data everytime to view larger set of results. **What problems is PostgreSQL solving and how is that benefiting you?** Helps in analysing the data ,getting clarity on schema details on each and every column of the table. Also the table schema can be obtained easily by using simple queries.It benefits in another way like data manipulation and data storages. ### 29. Free and open-source RDBMS with extensibility and SQL compliance **Rating:** 4.5/5.0 stars **Reviewed by:** Nagesh C. | Software Engineering Lead, Small-Business (50 or fewer emp.) **Reviewed Date:** September 12, 2023 **What do you like best about PostgreSQL?** PostgreSQL comes with all the existing features of an RDBMS as well as additional extensibility of replicating programming data types likes Arrays, Enumerated & Binary Data etc. **What do you dislike about PostgreSQL?** Postgres is not owned by any organization. So, it has had trouble getting its name out there despite being fully featured and comparable to other DBMS systems. **What problems is PostgreSQL solving and how is that benefiting you?** I can map most of my Java programming objects directly to Postgres without worrying about DB to App mapping. It also provides me with all old-scholl SQL capabilities like different joins, data relication, sharding, security etc. ### 30. Best Cloud DB. **Rating:** 5.0/5.0 stars **Reviewed by:** Piyush G. | Programmer Analyst, Enterprise (> 1000 emp.) **Reviewed Date:** July 28, 2023 **What do you like best about PostgreSQL?** The best part about PostgreSQL is it is very easy to use in comparison with other SQL Databases.I use Aurora PostgreSQL which is cloud DB provided by AWS. It is very much powerful and the query response time is blazingly fast. Like it can fetch millions of records in seconds only. As a backend nodejs developers I heavily use it by integrating it with the pg node module or dependency. It very easy to setup as it provides pool and client connection object to be attached. **What do you dislike about PostgreSQL?** It can be a little complicated for someone who is new to SQL Database or for begginers because of it's deep learning Curve. But there are so many resources and it's official documentation that helps a lot to start. **What problems is PostgreSQL solving and how is that benefiting you?** I use Aurora PostgreSQL which is cloud DB provided by AWS. It is very much powerful and the query response time is blazingly fast. Like it can fetch millions of records in seconds only. As a backend nodejs developers I heavily use it by integrating it with the pg node module or dependency. It very easy to setup as it provides pool and client connection object to be attached. As we are developing a enterprise application and the data is huge so it's the ideal choice because it very secure,reliable and it can be scaled up at any time. It's top notched DB Management System ### 31. Postgres user friendly RDBMS **Rating:** 4.5/5.0 stars **Reviewed by:** Dhanush R. | Customer Success Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** September 06, 2023 **What do you like best about PostgreSQL?** Postgres is opensource, it supprts scalability, role based access to it also one of the major factor, where people like using it.Even for secure access it provides SSL authentication. **What do you dislike about PostgreSQL?** It's bit hard to setup, no user friendly GUI tools like, SQL developer for oracle. I see there is some GUI tool called PgAdmin which I use, which is not that of user friendly like other RDBMS DB's **What problems is PostgreSQL solving and how is that benefiting you?** Data Storage : It's robust DB to store and retrive data. Data Integrity From basic to complex problem PostgresSQL is solving like data management to scalability ### 32. Review on Postgres **Rating:** 5.0/5.0 stars **Reviewed by:** Shivam M. | Product Evangelist, Mid-Market (51-1000 emp.) **Reviewed Date:** October 31, 2023 **What do you like best about PostgreSQL?** Postgrest provied very easy to use interface which is very easy to implement as well because of which users preffer to use it frequently and it has n numbers of features which makes it easy to integrate with multiple sowtwares and it has good customer support as well which increase its creadiblity in market. **What do you dislike about PostgreSQL?** Postgres is bit slow than MySql and if we delete any records from table then it is not auto vaccume and reindex because of which table size and database size is not reduced which reduces its performace some times. **What problems is PostgreSQL solving and how is that benefiting you?** I am using it to store my application data. ### 33. Powerful, reliable, stable **Rating:** 5.0/5.0 stars **Reviewed by:** Sarah Conway S. | Software Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** June 11, 2023 **What do you like best about PostgreSQL?** It's a database that has over 35 years of development. Consistent and stable, reliable yet powerful, it's able to scale and adapt to changing infrastructure as well as be deployed on your choice of platform (any cloud provider, on premise, hybrid or multi cloud). It works great on distributed microservices or as a vertically scaled single instance. **What do you dislike about PostgreSQL?** The documentation is very dense and it's not very accessible for beginners who don't have a background in code. More online resources and QuickStarts could be provided to help onboard new developers. **What problems is PostgreSQL solving and how is that benefiting you?** Postgres helps solve business cases where both RDBMS or NoSQL database types are needed. It can deal with a wide variety of data types including specialized data, like graph or spatial. ### 34. It's a vast database management system. **Rating:** 4.5/5.0 stars **Reviewed by:** Vishal S. | L1 Database Developer , Mid-Market (51-1000 emp.) **Reviewed Date:** December 26, 2023 **What do you like best about PostgreSQL?** It's very easy to use as compared to other tools in the market and it contains very well prepared documentation on its site. **What do you dislike about PostgreSQL?** One thing I dislike about it is it's not easy to use in the starting of usage for a new user. **What problems is PostgreSQL solving and how is that benefiting you?** Our database is running on postgresql engine and we use it through RDS in AWS. ### 35. I am using Azure Flex Postgre Paas for all of production systems **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Food Production | Enterprise (> 1000 emp.) **Reviewed Date:** November 12, 2023 **What do you like best about PostgreSQL?** Its a DB with so many features and cost effective.I have migrated from Oracle to Postgre DB and it helps organisation to save 50% of the original cost **What do you dislike about PostgreSQL?** Neecd to imporve support, specially for the PAAS version in Azure **What problems is PostgreSQL solving and how is that benefiting you?** It is helped to reduce the cost by 50% and feature wise no negative by comparing to Oracle which i used previously. Can administrate DB easily and still no performence issues faced even during the Full ETL times ### 36. PostgreSQL is known for its reliability and stability. **Rating:** 5.0/5.0 stars **Reviewed by:** Rohit K. | Project Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** June 15, 2023 **What do you like best about PostgreSQL?** Robust and Stable: PostgreSQL is known for its reliability and stability. It has a proven track record of handling large and complex databases with high transaction volumes. Advanced Features: PostgreSQL offers a wide range of advanced features, including support for complex queries, advanced indexing techniques, full-text search, geospatial data processing, and more. It provides powerful tools for developers to work with and manipulate data efficiently. Scalability: PostgreSQL is designed to scale effectively as your database needs grow. It can handle large datasets and high concurrent connections without sacrificing performance. Open Source: PostgreSQL is an open-source database system, which means it is freely available and can be customized to suit specific requirements. It has a vibrant community of developers who contribute to its ongoing development and provide support. Extensibility: PostgreSQL supports the creation of custom extensions, allowing developers to add new functionality and extend the capabilities of the database. This flexibility enables users to adapt the system to their specific needs. **What do you dislike about PostgreSQL?** Complexity: PostgreSQL can be more complex to set up and configure compared to some other database systems. It requires a certain level of expertise to optimize and tune the database for optimal performance. Learning Curve: While PostgreSQL offers a comprehensive set of features, it also has a steep learning curve. Developers and administrators need to invest time and effort in understanding the system and mastering its capabilities. Limited GUI Tools: Compared to some commercial database systems, PostgreSQL has fewer graphical user interface (GUI) tools available. This can make certain tasks, such as database administration and management, more challenging for users who prefer a visual interface. Memory Consumption: PostgreSQL can consume significant amounts of memory, especially when dealing with large datasets or complex queries. This can be a concern for systems with limited resources or when running multiple instances on a single machine. Replication and High Availability: Although PostgreSQL provides various replication mechanisms, setting up and managing high availability configurations can be more involved and complex compared to some other databases. **What problems is PostgreSQL solving and how is that benefiting you?** PostgreSQL solves several problems and offers numerous benefits to its users. Here are some of the key problems PostgreSQL addresses and how they can benefit you: Data Integrity: PostgreSQL provides robust mechanisms to ensure data integrity, including support for ACID (Atomicity, Consistency, Isolation, Durability) properties. This means that your data is protected from inconsistencies or corruption, ensuring reliable and accurate information storage. Reliability and Stability: PostgreSQL is known for its reliability and stability. It has a proven track record of handling large and complex databases with high transaction volumes. By using PostgreSQL, you can have confidence in the integrity and availability of your data, minimizing the risk of system failures or data loss. Advanced Features and Functionality: PostgreSQL offers a wide range of advanced features and functionality that can benefit developers and database administrators. These include support for complex queries, advanced indexing techniques, full-text search, geospatial data processing, and more. By leveraging these capabilities, you can efficiently manipulate and analyze your data, gaining valuable insights and optimizing performance. Scalability: As your database needs grow, PostgreSQL provides scalability options to accommodate increasing data volumes and user concurrency. It can handle large datasets and high transaction rates, ensuring that your application or system can scale seamlessly without sacrificing performance. Flexibility and Extensibility: PostgreSQL is highly flexible and extensible, allowing you to adapt the database to your specific requirements. It supports the creation of custom extensions, enabling you to add new functionality or modify existing features. This flexibility empowers you to tailor the database system to your unique use cases and business needs. Open Source Community: PostgreSQL is an open-source database system with a vibrant and active community. This community contributes to ongoing development, provides support, and shares valuable knowledge and resources. By being part of this community, you can benefit from the collective expertise and contributions of a wide range of users and developers. Overall, PostgreSQL addresses common database challenges such as data integrity, reliability, scalability, and flexibility. By leveraging its features and capabilities, you can build robust and efficient applications, manage data effectively, and make informed decisions based on reliable and accurate information. ### 37. manage high volume of data and support RDBMS **Rating:** 4.0/5.0 stars **Reviewed by:** Manthan V. | SDE-2 Frontend Developer , Mid-Market (51-1000 emp.) **Reviewed Date:** June 09, 2023 **What do you like best about PostgreSQL?** => SQL database => Open-source database it means we can do customization and get community support => Easy to manage large volumes of data => Allow creating custom data types, operators, events and function => Large community so you can solve you problem fast => Provide jsonb data type for store json data **What do you dislike about PostgreSQL?** => database is based on project and requirement so if your project is small then I suggest use MongoDB => Need the training to understand database functionality => Need more storage and computing power to execute query **What problems is PostgreSQL solving and how is that benefiting you?** => Allow writing complex queries so we can get more meaningful full data in a single query instead of executing multiple queries => Multiple users can access the DB in the same time without any issue so its not block users => Create custom type, event, functional, and operator it means base on requirements we can create and reuse instead of writing custom logic ### 38. Genuine thought **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** January 18, 2024 **What do you like best about PostgreSQL?** easy to use we can use it in our production environment, it provide very good features so that we can optimized our query and also data retrieval become easy also in PostgreSQL querys are easy to write, we frequently use it in our projects. **What do you dislike about PostgreSQL?** what i don't like is, it is not distributed database, and some features are not supported **What problems is PostgreSQL solving and how is that benefiting you?** They make some features simple, so that now we can easily write our complex query ### 39. Great database **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Small-Business (50 or fewer emp.) **Reviewed Date:** February 01, 2024 **What do you like best about PostgreSQL?** Is the best database to store the geom polygons **What do you dislike about PostgreSQL?** The sintaxes from some functions are not easy to understand **What problems is PostgreSQL solving and how is that benefiting you?** There is no issues ### 40. Postgres: Flexible SQL/NOSQL Database **Rating:** 4.5/5.0 stars **Reviewed by:** Ayush G. | Small-Business (50 or fewer emp.) **Reviewed Date:** July 05, 2023 **What do you like best about PostgreSQL?** -It has the ability to store NOSQL data as well such as JSON -Well suited when data is transactional as well as informative -Free to use -Postgres's ORM is available For almost all major programming language -Installation is very straightforward -Easy to maintain compared to other SQL databases **What do you dislike about PostgreSQL?** -Not as fast as MySQL -Without ORM, Query writing can be tedious and slow -As it supports JSON schema as well it can be difficult to manage at scale -Horizontal scaling can be trickier to achieve **What problems is PostgreSQL solving and how is that benefiting you?** It works best when dealing with mixed types of data such as transactions, spatial, and geo-location as it can also store data in document format, unlike any other SQL database. Also its well suited if you're planning on vertical scaling of the database. ### 41. Best open source relational database for geo location and data migration **Rating:** 3.5/5.0 stars **Reviewed by:** Ankit A. | Senior Technical Consultant Database, Enterprise (> 1000 emp.) **Reviewed Date:** February 10, 2023 **What do you like best about PostgreSQL?** What I like most about PostgreSQL is its open source. Being an open-source relational database, it also provides value to the customer and their users in terms of fast and internal precalculated libraries and functions that help developers and users retrieve data fastly without any hurdle. Postgresql is also helping us with fast query execution and efficient use of memory. **What do you dislike about PostgreSQL?** Being an open-source relational database, the area of improvement is its inability to handle large-volume database application support. Another thing is its limited community or ecosystem compared to premium databases like oracle and SQL servers. The query execution explanation plan is also not good in PostgreSQL. Postgresql does not have any run-time debugger, so some time to hard to find the error's root cause. **What problems is PostgreSQL solving and how is that benefiting you?** Postgresql provides a relational database system that is helping startups and developers to learn databases and adopt new technologies that can't pay licensing fees. It helped me to generate a geo-tagging platform that required a fast and accurate lat-long calculation that couldn't be completed without the PostgreSQL / PostGIS. Postgresql helped me to learn how we could integrate json with RDBMS. ### 42. Data Mangement system **Rating:** 5.0/5.0 stars **Reviewed by:** Kartik B. | Software Trainee, Mid-Market (51-1000 emp.) **Reviewed Date:** September 10, 2023 **What do you like best about PostgreSQL?** I have used this software for Blog Platform Management. It was very helpful & easy to manage data. It provide easier & userfriendly queries to all users. **What do you dislike about PostgreSQL?** Integrating with framework it is very time consuming. **What problems is PostgreSQL solving and how is that benefiting you?** It manages data for user and provide direct access to data present in Database. ### 43. Postgres - Open source RDBMS solution **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Computer Software | Enterprise (> 1000 emp.) **Reviewed Date:** August 28, 2023 **What do you like best about PostgreSQL?** The PostgreSQL relational database is a open source database system - which is free to use, easily configurable and carry overs all the basic SQL principles and Syntax. **What do you dislike about PostgreSQL?** There is a downside of the PostgreSQL that it is not able to handle multiple idle connections, it loses the ability for new connections to reconnect. If that can be fixed, it's awesome. **What problems is PostgreSQL solving and how is that benefiting you?** It enables organizations and users to create, manipulate and configure a relational database into a business use case. It is free to use, and the saves licensing costs while providing reliability. ### 44. Best open source database to achieve high performance and scalability. **Rating:** 4.5/5.0 stars **Reviewed by:** Mohit S. | Mid-Market (51-1000 emp.) **Reviewed Date:** September 01, 2023 **What do you like best about PostgreSQL?** It is a open source application and allows to scale whenever needed. It is very fast and secure to manipulate data. Database creation, updation is very easy in PostgreSQL. **What do you dislike about PostgreSQL?** Learning PostgreSQL is challenging in beginning because it is complex and documentation is not that much easy to understand. The documentation should have examples for reference. **What problems is PostgreSQL solving and how is that benefiting you?** I have huge real time data to manipulate. When I used other framework the performance of data transfer was low. With the help of PostgreSQL I achieved data manipulation faster. ### 45. Excellent RDBMS for production systems with minimal cost. **Rating:** 5.0/5.0 stars **Reviewed by:** Jasmeet K. | Data Scientist, Mid-Market (51-1000 emp.) **Reviewed Date:** April 20, 2023 **What do you like best about PostgreSQL?** I have used Postgres SQL extensively for the past few years and it is few of cost effective scalable RDBMS that runs very smooth with web applications specially with Django backend. This RDBMS can be tuned for performance quickly and offers amazing support for custom functions. This RDBMS can be scaled quickly and is available in cloud services like Amazon RDS which can make this database manageable. The error messages in the RDBMS is very clearly laid out and I just love the way it provides flexibility of using custom SQL workbenches. **What do you dislike about PostgreSQL?** I have loved my experience with Postgres SQL and the user community for this RDBMS is amazing. I have faced issues in reading documentation for Postgres but online community has always helped in getting my issues resolved. **What problems is PostgreSQL solving and how is that benefiting you?** PostgresSQL has been a goto database management system in our projects because of its flexiblity and seamless integration with Django. I have been using PostgresSQL extensively for data storage and analysis. This RDBMS is really cost effective and we use it in Amazon RDS for production instance. ### 46. Great database system to use for beginners. **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** January 01, 2024 **What do you like best about PostgreSQL?** Very reliable tool to use and easy to understand plus its consistent and also adapts to changing infrastructure in the market. **What do you dislike about PostgreSQL?** The documentation is very dense which is nit easy to understand by beginners. **What problems is PostgreSQL solving and how is that benefiting you?** It helped to solve the business queries and business cases and it can also deal with a wide range of data types including specialised ones. ### 47. Enterprise Open Source Relational Database Management System **Rating:** 5.0/5.0 stars **Reviewed by:** Kwabena A. B. | IT Professional, Mid-Market (51-1000 emp.) **Reviewed Date:** May 11, 2023 **What do you like best about PostgreSQL?** PostgresSQL shines as an enterprise RDBMS. It has all the enterprise features of a modern database management system, yet it is free and open source. It can handle a data intensive system very well. **What do you dislike about PostgreSQL?** It is really difficult to talk about any dislike about PostgreSQL, however it has a bit of a learning curve. Also, installation and configuration on a linux platform is a bit complicated. **What problems is PostgreSQL solving and how is that benefiting you?** PostgreSQL is serving as a backend database for our laboratory information management system. We have also deployed it as a database for our institutional repository system. ### 48. Feature-rich, and performant database system that suits a wide range of applications **Rating:** 5.0/5.0 stars **Reviewed by:** Ramiro L. | Small-Business (50 or fewer emp.) **Reviewed Date:** May 25, 2023 **What do you like best about PostgreSQL?** -Scalability and Performance: PostgreSQL can handle high-volume workloads and scale to large datasets. -Cross-Platform Compatibility: PostgreSQL runs on multiple platforms, including Linux, macOS, and Windows. **What do you dislike about PostgreSQL?** -Configuration and Performance Tuning: Optimizing performance in PostgreSQL can be challenging, particularly for complex workloads and large datasets. -Upgrade Process: Upgrading PostgreSQL to newer versions may require careful planning and testing, as it involves migrating data and ensuring compatibility with existing applications and extensions. **What problems is PostgreSQL solving and how is that benefiting you?** PostgreSQL solves several problems in the realm of data management: -Data Integrity and ACID Compliance: PostgreSQL implements ACID (Atomicity, Consistency, Isolation, Durability) properties, ensuring data integrity and reliability. -Data Integration and Interoperability: PostgreSQL supports integration with other systems and tools. -Scalability and Performance: PostgreSQL offers scalability and handles high-volume workloads effectively. ### 49. One of the best and free DBMS in the market! **Rating:** 5.0/5.0 stars **Reviewed by:** Akash N. | Enterprise (> 1000 emp.) **Reviewed Date:** June 07, 2023 **What do you like best about PostgreSQL?** Postgresql is a platform that shares unlimited sources accessible to every user. Its user-friendly features make it easy for beginners to understand its functionalities. Whether maintaining or exploring new databases or setting up your database from scratch, Postgresql is one of the best tool user can rely upon! **What do you dislike about PostgreSQL?** While merging or blending data from different sources a few times, PostgreSQL lags or fails the first time, which can be a con for the platform, other than all other features work smoothly! **What problems is PostgreSQL solving and how is that benefiting you?** Users can maintain their databases, make changes, store them, and use them for analyzing trends or research. And with its ease-of-use features, it is one of the best platforms for DBMS. ### 50. 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. ## 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=2§ion=pricing&secure%5Bexpires_at%5D=2026-06-25+18%3A03%3A11+-0500&secure%5Bsession_id%5D=7a47aa6c-f2b3-411b-a8de-a2447b4cf1ba&secure%5Btoken%5D=506659ef7aa0f811a867bc09247f90f05b85b6e6a27331e12c9a8afa1fd58a89&format=llm_user) ## PostgreSQL Integrations - [Amazon Redshift](https://www.g2.com/products/amazon-redshift/reviews) - [Angular](https://www.g2.com/products/angular-dev-angular/reviews) - [Apache Superset](https://www.g2.com/products/apache-superset/reviews) - [Apache Tomcat](https://www.g2.com/products/apache-tomcat/reviews) - [Azure Database for PostgreSQL](https://www.g2.com/products/azure-database-for-postgresql/reviews) - [cPanel](https://www.g2.com/products/cpanel/reviews) - [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) - [PostgreSQL](https://www.g2.com/products/postgresql/reviews) - [PostgreSQL on Amazon Linux 2](https://www.g2.com/products/postgresql-on-amazon-linux-2/reviews) - [PostgreSQL With Redhat 8](https://www.g2.com/products/postgresql-with-redhat-8/reviews) - [Prisma](https://www.g2.com/products/prisma-prisma/reviews) - [Python](https://www.g2.com/products/python/reviews) - [QGIS](https://www.g2.com/products/qgis/reviews) - [React Native](https://www.g2.com/products/react-native/reviews) - [Redis Software](https://www.g2.com/products/redis-software/reviews) - [Ruby on Rails](https://www.g2.com/products/ruby-on-rails/reviews) - [Tableau](https://www.g2.com/products/tableau/reviews) - [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 (929 reviews)