--- 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. Relational database manager system, is object oriented. **Rating:** 4.5/5.0 stars **Reviewed by:** Yoceliz A. | Analista de datos en T-Systems Iberia, Enterprise (> 1000 emp.) **Reviewed Date:** July 02, 2019 **What do you like best about PostgreSQL?** is a database manager that offers us more than creating database is oriented to objects, that is, all the elements of our database will be able to be treated as objects, something similar to a programming language. in the same way it can be said that it is multisystem, therefore PostgreSQL can be installed in Microsoft Windows, GNU / Linux, MacOS, BSD and many other operating systems. PostgreSQL is scalable and can handle huge databases, of more than 100 Terabytes and it works under a free license, we can use it for any purpose without any problem. **What do you dislike about PostgreSQL?** PostgreSQL is slower when it comes to insertions and updates, similarly the response it offers when the databases are small may seem a little deficient, compared with MySQL consumes more resources, also some commands and syntax are not intuitive. **Recommendations to others considering PostgreSQL:** PostgreSQL is a free software object-oriented relational database server, published under the BSD license. My recommendation is very simple because this or its function as I said before is related to creating databases that have rows and that this function is to save data this is very important is any field because if you have a wide information that to keep this what it does is to facilitate us the work for that it is good for each programmer to know and to use different database manager so that he knows which one he likes the most **What problems is PostgreSQL solving and how is that benefiting you?** ProgrestSQL is a language of database administration, highlighting its parts, tables, fields that are an excellent support language for queries with various elements collected at the web level serves for management and total reliability to make business inventories. Programs have been created facilitating the use of ProgrestSQL, SQL and Oracle to the most inexperienced but with an efficiency of 100% ### 2. Best opensource database **Rating:** 3.5/5.0 stars **Reviewed by:** Vasu G. | R&D Engineer, Information Technology and Services, Enterprise (> 1000 emp.) **Reviewed Date:** August 19, 2019 **What do you like best about PostgreSQL?** PostgreSQL supports json data and transaction control that helps in development of modern complex web apps. Also, pgadmin built in support for dump backup is an important feature for critical applications. PgAdmin is good tool for managing and viewing database data along with support for complex SQL queries. **What do you dislike about PostgreSQL?** The PostgreSQL has some rigid migration rules while updating the database that can cause data loss **What problems is PostgreSQL solving and how is that benefiting you?** PostgreSQL has provided a reliable database for django web application with regular automated data backup and required scalability for growing users of the application ### 3. postgres database engine **Rating:** 4.5/5.0 stars **Reviewed by:** Gustavo Héctor C. | postgres database engine, Mid-Market (51-1000 emp.) **Reviewed Date:** June 27, 2019 **What do you like best about PostgreSQL?** for me the best of PostgresSQL and what I like most is that it is multiplatform, this helps me a lot with the work that I have to use both free software and Windows in some cases as applications with postgres use. and since it is multiplatform I can install it in one environment and the other without problem and without saying that it is free and it is one of the best database engines today. **What do you dislike about PostgreSQL?** What I like about PostgreSQL is that when I use it for small applications the queries are a bit slow compared to MySql, so I use simple applications with PhpMyAdmin and the more robust ones with postgresql, because in this sense it is better. **Recommendations to others considering PostgreSQL:** My opinion is that they keep working the way they are doing and keep it free and free for medium and low volume applications and if they can improve the support and integrate it into the application it would be very good for us end users although Postgres has a very active community with forums and debates on how to use it and this makes it have good support and support in the present and future **What problems is PostgreSQL solving and how is that benefiting you?** Well the biggest benefit I've seen is the opposite to what I do not like postgres is that with large and robust applications that require a good search engine and greater responsiveness and with Postgresql I have been able to solve these difficulties without cost applications with large consumption of resources in transactions in queries with statements and stored procedures to the database, and with the issue of security is also a very big benefit with postgresql ### 4. Easy to use & Reliable Database **Rating:** 4.5/5.0 stars **Reviewed by:** Toghrul A. | Product & Service Operations Unit Head, Mid-Market (51-1000 emp.) **Reviewed Date:** December 31, 2019 **What do you like best about PostgreSQL?** PostgreSQL is the best free database. Everyone can install it & use for it free. It has many functionalities which you need **What do you dislike about PostgreSQL?** Many open source applications are not support PostgreSQL. It is a main disadvantage **What problems is PostgreSQL solving and how is that benefiting you?** For application like as microservices, PostgreSQL is the best for my opinion. I use this database if application can be stand alone app ### 5. Database to sort out your daily development work **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Enterprise (> 1000 emp.) **Reviewed Date:** November 17, 2019 **What do you like best about PostgreSQL?** Helps us to manage our database needs while working on chatbots or other applications. The PGadmin console is really helpful as it provides a graphical interface to access or modify your db data. **What do you dislike about PostgreSQL?** At times it won't start. You'll have to try twice or thrice to make it start. Also sometimes it might not allow to change values in a table from the PGadmin console. **What problems is PostgreSQL solving and how is that benefiting you?** Data storage, tables and relations required for our applications. Data storage for out APIs ### 6. PostgreSQL database server **Rating:** 4.0/5.0 stars **Reviewed by:** HECTOR FRANCO G. | desarrollador de software en butterflies design web, Small-Business (50 or fewer emp.) **Reviewed Date:** June 16, 2019 **What do you like best about PostgreSQL?** One of the main reasons why I use PostgreSQL is that it is developed under open source (Open Source), besides that if we require a database to work on our project, the most common is that we ask ourselves which database to use provide performance, security and in turn we can use it both in the office and outside it, and one of the most common cases is that we do not all have the same operating system. It also has a management facility PgAdmin is the main base administrator Postgres data is very simple to use, this tool practically does everything with a few simple clicks, being optimal for people who do not have much experience, either because they are starting in the world of databases or because they simply need a database for your project. **What do you dislike about PostgreSQL?** PostgreSQL It is relatively slow there are things like these that I also dislike in insertions and updates in small databases, also PostgreSQL is designed for high volume environments. This makes the response speed seem slow compared to small databases. **Recommendations to others considering PostgreSQL:** As we can see when using PostgreSQL we obtain security, reliability, stability and the opportunity to improve and provide functional developments to make an even more optimal database manager. These simple reasons are more than enough to place Postgres among the main options to take into account when working with databases. **What problems is PostgreSQL solving and how is that benefiting you?** Higher performance. Greater speed both when connecting to the server and serving selects and others. Better administration utilities (backup, error recovery, etc). Even if it hangs up, it does not usually lose information or corrupt the data. Better integration with PHP. There are no limits on the size of the records. Better access control, in the sense of which users have access to which tables and with which permissions. MySQL behaves better than Postgres when modifying or adding fields to a "hot" table. ### 7. PostgreSQL relational database management system **Rating:** 4.0/5.0 stars **Reviewed by:** stephanie c. | Administrador de redes en butterflies design web, Small-Business (50 or fewer emp.) **Reviewed Date:** June 13, 2019 **What do you like best about PostgreSQL?** PostgreSQL is undoubtedly one of the most well-known and used database servers. OPEN SOURCE One of the main reasons for using PostgreSQL is that it is developed under open source (Open Source), we can find it available on its official website and download it without any cost. also has a MULTIPLATAFORMA If we require a database to work on our project, the most common is that we ask what database to use that gives us performance, security and in turn we can use it both in the office and outside of it, and one of the Most common cases is that we do not all have the same operating system. And here is another reason to use PostgreSQL: we will not have to worry about this detail anymore, because it is available in virtually all versions of Unix operating systems and also for Windows, giving us the opportunity to have it installed locally, make a remote connection to through your PgAdmin administrator or also from the application you are developing. **What do you dislike about PostgreSQL?** This compared to MySQL is slower in insertions and updates, since it has intersection headers that do not have MySQL. Online support: There are official forums, but there is no mandatory help. It consumes more resources than MySQL. The sintaxtis of some of its commands or statements is not intuitive at all. These are some of the annoying things about PostgreSQL. **Recommendations to others considering PostgreSQL:** that this is a database server that by all the features already presented is good to use it for all the benefits that it has when creating a database **What problems is PostgreSQL solving and how is that benefiting you?** is a free relational object database server, since it includes features of object orientation, such as inheritance, data types, functions, restrictions, triggers, rules and transactional integrity, released under the BSD license. Like many others open source projects, the development of PostgreSQL is not managed by a single company but rather is run by a community of developers and commercial organizations. ### 8. Highly recommend - easy to use and does connect to so many applications **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Automotive | Mid-Market (51-1000 emp.) **Reviewed Date:** November 21, 2019 **What do you like best about PostgreSQL?** Easy of use - tons of community guidelines and stack overflow users have solved most of the problems **What do you dislike about PostgreSQL?** We went for the paid version but is pricey but thats just one part - the postgres DB actually wants you to learn their own syntax which takes time of you are new **Recommendations to others considering PostgreSQL:** Highly recommend but you need to learn the language **What problems is PostgreSQL solving and how is that benefiting you?** We replaced it from IBM db2 and it seems like It connects with many applications easily. We are using it to integrate with in house python applications and works perfect. However we haven’t actually signed off with this application officially but it is under due consideration ### 9. Create your secure and robust database **Rating:** 4.0/5.0 stars **Reviewed by:** Lopata C. | Project Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** June 07, 2019 **What do you like best about PostgreSQL?** is a computer tool that you can obtain free downloading from your website, easy to install both in private operating systems and open source and this allows you to create a database with different parameters and tables that will make your database fast and secure too has the advantage of working with different types of files for the storage of information so that when consulting tables is faster has an option called triggers that allows to automate statements in the database to perform execute command so automatic. **What do you dislike about PostgreSQL?** It is usually difficult to install linux operating system since it must be installed manually using the command console and indicate in which sites the installer file is located, it also tends to be flawed when it has multiple databases or when a database It is very small since it is indicated and developed for a large data base. **Recommendations to others considering PostgreSQL:** is a very useful tool and its advantage is that totally free that will work to manage database of great information for systems in both web development environment and desktop environment as they are developed in java is light when installing and you do not need more resources for its execution, however, the system usually becomes a bit heavy depending on the number of information it manages and the way in which it is managed correctly. **What problems is PostgreSQL solving and how is that benefiting you?** I worked to use this database with the system and extensive information that our client needs and are developed in turn is implemented and integrated with several tools for developing programs such as netbeans and eclipse. ### 10. manage your database securely **Rating:** 4.5/5.0 stars **Reviewed by:** David C J. | Computer Engineering, Small-Business (50 or fewer emp.) **Reviewed Date:** June 05, 2019 **What do you like best about PostgreSQL?** It is a super fast tool and the best of all for free to manage database of large volume or size; it is compactible for both windows and other operating systems. Its configuration is easy and its functionality is surprising since it allows you to manage a database of data that contains multiple tables in a fast and secure way to access the information asks you to log in and has an endless file format to save the information. **What do you dislike about PostgreSQL?** in database that are not large, or it is usually slow search or may even fail, you need some plugins or components to integrate with other software which makes it a bit difficult to configure. **Recommendations to others considering PostgreSQL:** I recommend this database administrator for its quick way of installation and configuration in turn for the way to administer the tables and database because it allows to interlace tables and have a better response quickly and without any error. It works both for proprietary operating systems or open source, and you do not need to have a large computer to use this tool because it does not consume much requirements. **What problems is PostgreSQL solving and how is that benefiting you?** We have served to make and safeguard our information in a safe manner and with multiple forms of protection. This tool also allows us to encrypt our information in case any person wishes to access it, it can not be achieved. its installation is totally free and compactible for java and php application development. ### 11. Fast and Underrated, great database **Rating:** 4.5/5.0 stars **Reviewed by:** Nigel H. | Technical Architect/Manager, Small-Business (50 or fewer emp.) **Reviewed Date:** August 16, 2019 **What do you like best about PostgreSQL?** It does stored procedures, indexes, benchmarks are excellent, its FREE. Does multiple languages in Unicode, stores objects. **What do you dislike about PostgreSQL?** The only free tool is pgadmin and its good but you have to pay to get a good database admin tool. **Recommendations to others considering PostgreSQL:** Its fast and very well done. We have 1500 clients with thousands of patients and it works fine. **What problems is PostgreSQL solving and how is that benefiting you?** sometimes you have to write a query in a special way so that Postgresql is efficient at processing the sql correctly. ### 12. Database manager very powerful and the best thing is that it is free! **Rating:** 3.0/5.0 stars **Reviewed by:** Michell R. | Gerente de Proyectos, Small-Business (50 or fewer emp.) **Reviewed Date:** August 03, 2018 **What do you like best about PostgreSQL?** This management system offers performance characteristics that have evolved over time. Also its use and constant review of the developer community have made it one of the most stable systems in terms of open source refers to. The graphical environment offered by Pgadmin allows an intuitive and easy to manage administration. If you have used other database administration systems, the adaptation to Postgre SQL will be very fast and little traumatic. The SQL statement editor is very practical, which allows to perform the operations most commonly used in any database. Finally, the backups and recovery of databases are carried out quickly and in a few steps. The reliability of this function is very high. Particularly, during the time I have been using this manager I have not presented any type of error or catastrophic loss **What do you dislike about PostgreSQL?** The main hosting providers do not support database of this management system. The big corporations still have resistance for the use of this manager. The support is provided by the developer community, which produces long periods of time to resolve. It does not have an error identification and traceability mechanism. **Recommendations to others considering PostgreSQL:** Free technologies are not necessarily unstable. If you require a database management system with good security features, information integrity for a medium volume of transactions, try PostgreSQL **What problems is PostgreSQL solving and how is that benefiting you?** In countries where the use of free technologies is encouraged, great benefits can be obtained because there are no additional payments for user licenses and the client owns the generated code, which allows its administration and modification without inconvenience. ### 13. PosgreSQL **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Small-Business (50 or fewer emp.) **Reviewed Date:** October 22, 2019 **What do you like best about PostgreSQL?** Licensing model is very flexible. Database can be embedded as part of an application or installed separately. **What do you dislike about PostgreSQL?** GUI UI isn't the best. PGAdmin is a local application that is installed as a web based application. It can be flakey to get running. **Recommendations to others considering PostgreSQL:** Understand use of database to allow power to assist your implementation **What problems is PostgreSQL solving and how is that benefiting you?** Storage of both discrete and nondiscrete data in a single database. The flexibility allows for implementation of many use cases including dynamic types. ### 14. PostgreSQL: a great choice for open source Relational DBMS **Rating:** 4.5/5.0 stars **Reviewed by:** Román Josué d. | Data Scientist, Small-Business (50 or fewer emp.) **Reviewed Date:** May 18, 2019 **What do you like best about PostgreSQL?** PostgreSQL is one of the best options to work with relational databases. Having worked a lot with databases and having the experience to work with PostgreSQL made me realize how this is one of the most solid options for working on this area. It's the best open source for SQL and possibly the best among all, either open source or no. PostgreSQL provides you with high performance and solid robustness. It's easy to import, export, and deploy databases. **What do you dislike about PostgreSQL?** The PGAdmin could be improved. While it's a functional inteface, it could be improved and made faster and easier to use. **What problems is PostgreSQL solving and how is that benefiting you?** PostgreSQL not only improves your experience with working on SQL, but boost your database development and management. ### 15. PostgreSQL **Rating:** 4.5/5.0 stars **Reviewed by:** Mayra B. | Developer, Enterprise (> 1000 emp.) **Reviewed Date:** October 15, 2019 **What do you like best about PostgreSQL?** It is totally free, it is open source, it integrates with many database managers, it has many functionalities, inheritance of tables, several views, transactional integrity **What do you dislike about PostgreSQL?** rigorous security and authentication mechanisms must be applied to avoid any vulnerability in the system **Recommendations to others considering PostgreSQL:** Take courses, read, there is a lot of information on the web very useful, to be good professionals and in the case of companies have highly trained staff **What problems is PostgreSQL solving and how is that benefiting you?** Database management, integration with information systems, handling high transaction volumes ### 16. PostgresSQL is the most effective **Rating:** 4.5/5.0 stars **Reviewed by:** Abdul Basit Z. | Geographic Information System Officer, Information Technology and Services, Small-Business (50 or fewer emp.) **Reviewed Date:** August 15, 2019 **What do you like best about PostgreSQL?** PostgreSQL is fast and available with very small latencies on most clouds. I believe it's a SQL taste, particularly compatible with my coding style and a straightforward natural query interface. It operates robustly and can be easily distributed without crashing. **What do you dislike about PostgreSQL?** Postgres is perfect to say it has no flaws and we can't ask for Oracle's scope or features because, as a consequence, this instrument is safe. However, for example, the other tools aren't the only ones I saw and don't like. **What problems is PostgreSQL solving and how is that benefiting you?** From our experience, we had to question the introduction of several tables and use one of the Database Supervisor's characteristics to present important company information. ### 17. Review for PostgreSQL **Rating:** 4.5/5.0 stars **Reviewed by:** Sejal W. | Software Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** June 08, 2019 **What do you like best about PostgreSQL?** PostgreSQL is one of the best choice when it comes to managing relational databases and it is available to use for free! It provides an ease of use to its users. It allows developers the freedom of using many languages eg. Python for scripting. It works well with large amount of data too. **What do you dislike about PostgreSQL?** Processing big data is need of the day and very much required in all businesses. Even though postgreSQL can support large databases, It is not suitable for big data due to large computation time. **Recommendations to others considering PostgreSQL:** A very useful application to manage databases. Available for free along with good support. **What problems is PostgreSQL solving and how is that benefiting you?** I use postgreSQL to manage out employee and project databases. Its ease of use the fact that it is available for free make it possible for us to use it for small scale businesses and needs. ### 18. review about PostgreSQL **Rating:** 5.0/5.0 stars **Reviewed by:** eleomar d. | Reviews sobre sistema operativo windows 7, Small-Business (50 or fewer emp.) **Reviewed Date:** May 03, 2019 **What do you like best about PostgreSQL?** I like the way it manages the database and connectivity, and the version is free and unlimited. It is stable and reliable, very secure. Very secure when it comes to storing information and it is stable on different operating systems. **What do you dislike about PostgreSQL?** it does not have online or phone support but rather a forum where your questions will be answered. It tends to be slow in insertion and updating in low-volume databases; it is oriented towards databases with large storage capacity. **Recommendations to others considering PostgreSQL:** It is a good tool for managing large-scale databases as it fails with databases with little information, but I recommend it because I use it for my information system and I maintain good control over them. It is a complete database manager with multiple tools that will be useful when configuring, creating, and registering different types of data. At the same time, it has multiple security and encryption services that demonstrate to the user that their information is safe and reliable. Effective for databases that handle large volumes of information. **What problems is PostgreSQL solving and how is that benefiting you?** connect some operating systems with a single secure, reliable, and free database manager store information securely and quickly; previously there was a lot of data loss because the old database managers failed or had data loss ### 19. PostgreSQL is great for database management! **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Entertainment | Small-Business (50 or fewer emp.) **Reviewed Date:** April 16, 2019 **What do you like best about PostgreSQL?** PostgreSQL allows us to easily run queries and cross-reference information from various tables of data we have stored. As a subscription-based service with millions of user emails and information, this is extremely important. **What do you dislike about PostgreSQL?** While simple for someone who knows SQL there is a learning curve. It would be amazing if PostgreSQL allowed for easy implementation of a UI that was friendly to those who are not familiar with the coding behind queries to run searches in order to pull information from various sources. **What problems is PostgreSQL solving and how is that benefiting you?** We are able to search our information for potential abuse by users, as well as find accounts that may have been impacted by a bug in our system and mass resolve issues. More recently as we migrated billing systems some accounts had fallen through the cracks and were not billed in a few months. We were able to use PostgreSQL to write a query in order to find those accounts and bill them going forward. ### 20. Backbone of our stack **Rating:** 5.0/5.0 stars **Reviewed by:** Matthew D. | CTO, Mid-Market (51-1000 emp.) **Reviewed Date:** April 17, 2019 **What do you like best about PostgreSQL?** Postgres is an incredibly stable database workhorse. It handles production traffic with ease, and its default settings are generally very stable and scalable. It links easily to all sorts of ETL tools and supports all major ORM libraries. **What do you dislike about PostgreSQL?** Well, just like any SQL database, by default it's not vertically scalable. So once you can't upgrade your database server hardware further, you sort of hit a cap, until you put in sharding logic. **Recommendations to others considering PostgreSQL:** Realize that, if you're going to use this for production, you need DB experts on your team, even if you're getting postgres from AWS or from Heroku **What problems is PostgreSQL solving and how is that benefiting you?** Running our business and powering our website ### 21. Database as you know it **Rating:** 3.5/5.0 stars **Reviewed by:** Ahmadou N. | Soccer Referee, Enterprise (> 1000 emp.) **Reviewed Date:** April 02, 2019 **What do you like best about PostgreSQL?** I pretty much enjoy the elastic factor in its design and implementation. Offers a huge deal with data storage and security. As compared to MySQL and other database systems, PostGresSQL stands out as the go-to database when it comes to data redundancy and better maintenance. The pricing is not bad either and cloud solutions providers offer great supports. I should know, I use them whenever I need. **What do you dislike about PostgreSQL?** The setup is not that easy mostly on the Linux environment. The user has to have a better knowledge about the installation and usage before engaging on this database choice but it is worthy to spend time and energy learning. **Recommendations to others considering PostgreSQL:** If you are looking for a database that offer more tools as compared to the general SQL you are used to, try PostGresSQL, I guarantee you will never look back **What problems is PostgreSQL solving and how is that benefiting you?** Data storage and maintenance. It is the database of choice when it comes to cloud storage and I use it mostly from Heroku and Amazon ASW platforms ### 22. An Open source database for small to large scale organizations for free **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Education Management | Enterprise (> 1000 emp.) **Reviewed Date:** March 29, 2019 **What do you like best about PostgreSQL?** The PostgreSQL server has the advantage of having the security features of a paid service database, and the features of an open source database such as contact support, strong customer base which makes the service unique. **What do you dislike about PostgreSQL?** There are few technical glitches while trying to login using PostgreSQL server, because of this issue I had to uninstall the application multiple times to login into the server. It also has a problem regarding the duplication and restoring the database. **Recommendations to others considering PostgreSQL:** This PostgreSQL server is advantageous for performing the data analysis directly from the database, this product has a good security feature with a very inexpensive price for the customers. This is what makes the PostgreSQL server advantageous. **What problems is PostgreSQL solving and how is that benefiting you?** I have used the PostgreSQL server to store the data required for performing the data analysis. The advantage of using SQL server is I can automate the data wrangling and ingestion process by connecting through the application programming interface using python for PostgreSQL (psycopg2) package. ### 23. Postgres is probably the best relational DBMS in the node community **Rating:** 5.0/5.0 stars **Reviewed by:** Edward W. | Database Administrator, Small-Business (50 or fewer emp.) **Reviewed Date:** September 06, 2019 **What do you like best about PostgreSQL?** Postgres is very stable. Borrows some features from both relational database systems and NoSQL databases giving it very complex and powerful hybrid features. **What do you dislike about PostgreSQL?** Although postgres has been growing recently, it is not easy to find a professional who is well trained in postgres compared to other more popular DBMS like MySQL, Microsoft SQL and Oracle **What problems is PostgreSQL solving and how is that benefiting you?** Postgres has table inheritance, a feature that in not implemented by other relational DBMS ### 24. A good open source database **Rating:** 4.0/5.0 stars **Reviewed by:** Divyansh G. | Software Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** June 17, 2019 **What do you like best about PostgreSQL?** The simple GUI, combined with the CLI commands - makes this database very easy to use. Additionally, the fact that it is open-source and powerful makes it a go-to database for everyone. **What do you dislike about PostgreSQL?** No dislikes as of now. PostgreSQL being such a good open-source database, one would have to nit-pick really hard to find out something. **What problems is PostgreSQL solving and how is that benefiting you?** Accessing the database while it is being hosted in a server from different machines. ### 25. Easy database to setup and configure **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** September 04, 2019 **What do you like best about PostgreSQL?** Good open source database that implements the SQL standard. Very easy to administer, and standard SQL works well with it. **What do you dislike about PostgreSQL?** Their internal database commands in psql are a little confusing at times. Commands like \d \d+ etc. QL **What problems is PostgreSQL solving and how is that benefiting you?** Using it as our database for all SQL work, and very easy to get set up and use. The open source version has a lot of flexibility. ### 26. Best choice between compatitors. **Rating:** 5.0/5.0 stars **Reviewed by:** Yuriy P. | Senior Software Engineer (Blockchains Infrastructure) @ Fireblocks , Small-Business (50 or fewer emp.) **Reviewed Date:** October 26, 2019 **What do you like best about PostgreSQL?** Open source. Huge plug-ins offerings. Great documentation. **What do you dislike about PostgreSQL?** Less known than MySql for example. Less used by enterprise companies, No official support representative for solving problems. **Recommendations to others considering PostgreSQL:** Good choice for relational DB, with transactions. **What problems is PostgreSQL solving and how is that benefiting you?** Storing relational data, transactive operations. Complex queries. ### 27. PostgreSQL great scalable database **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.) **Reviewed Date:** October 27, 2019 **What do you like best about PostgreSQL?** I like the ease of use, scalibility and usability. **What do you dislike about PostgreSQL?** I dislike like of overview of data. You need to install additional tools for it. **Recommendations to others considering PostgreSQL:** Great for scalable startups. **What problems is PostgreSQL solving and how is that benefiting you?** We resolve problem of scalling database from startup to enterprise. ### 28. Fast query **Rating:** 5.0/5.0 stars **Reviewed by:** Ranjan A. | Backend Developer, Public Safety, Small-Business (50 or fewer emp.) **Reviewed Date:** November 06, 2019 **What do you like best about PostgreSQL?** geo query, the way we can query on geo coordinates **What do you dislike about PostgreSQL?** query json, Since it is a rdbms, the concept of JSON query is bad **Recommendations to others considering PostgreSQL:** easy to use **What problems is PostgreSQL solving and how is that benefiting you?** geo coordinates ### 29. classic relational database **Rating:** 5.0/5.0 stars **Reviewed by:** minh p. | Graduate Assistant, Research, Mid-Market (51-1000 emp.) **Reviewed Date:** April 02, 2019 **What do you like best about PostgreSQL?** PostgreSQL has been developed for a long time, so it probably has the most functionality in the database market. It is open-source, so its development will keep growing rapidly. It is free. It solves all of the problems that a relational database would solve, just like MySQL or Microsoft SQL Server, but is cost-effective and has similar performance. **What do you dislike about PostgreSQL?** The graphical tooling isn't as good as some of the tools provided by Microsoft or Oracle. Can be hard to figure out problems unless you know SQL very well. PostgreSQL does not allow to execute batch of statements. **Recommendations to others considering PostgreSQL:** If you are looking for a free relational database, PostgreSQL is the way to go. **What problems is PostgreSQL solving and how is that benefiting you?** I use it for transportation data collection. It performance is very impressive, but it was a bit difficult to get used to at first. ### 30. Postgres is the best open source relational database **Rating:** 3.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** August 30, 2019 **What do you like best about PostgreSQL?** The features which i like the most are : User-defined types , table inheritance ,sophisticated locking mechanism and many more. Fetching data and modifying it is very easy with postgres. Best part is the high speed. **What do you dislike about PostgreSQL?** Does not support the entire ANSI SQL 92' standard, much less the ANSI SQL 99' standard. **Recommendations to others considering PostgreSQL:** Postgres is really fast , secure and supports many procedural languages. It is very reliable . Try to use it. **What problems is PostgreSQL solving and how is that benefiting you?** We are using postgres as the data base for our accounting software- Giddh. Storing data , quering and modifying is very easy.It has legendary stability and reliability. ### 31. User Friendly and Fast **Rating:** 5.0/5.0 stars **Reviewed by:** Rishabh K. | Technical Lead, Enterprise (> 1000 emp.) **Reviewed Date:** February 28, 2019 **What do you like best about PostgreSQL?** Free database manager, with only download and install you can have the world of databases in full, with the best options of any proprietary driver, it is easy to install especially in free operating systems, it is ideal for database relational data, in terms of support, the best ally is the community of people who help others through forums, it is compatible with several graphic tools if they do not like to use the console, configuring a cluster is super simple and on the Internet the information works wonderfully with large databases. **What do you dislike about PostgreSQL?** If you use postgres by console and not with any graphical tool such as pgadmin or dbeaver you must have intermediate knowledge, you may notice some slowness in massive insertions but this is related to the good design of the database **Recommendations to others considering PostgreSQL:** The administration of a postgres cluster is great, we can synchronize a slave and a master and it works perfectly the synchronization and replication **What problems is PostgreSQL solving and how is that benefiting you?** I work daily in the management of postgres databases, used the console for backup and restore issues since they are much faster ### 32. "Amazing Database Manager" **Rating:** 5.0/5.0 stars **Reviewed by:** Joy P. | Project Manager, Mid-Market (51-1000 emp.) **Reviewed Date:** February 26, 2019 **What do you like best about PostgreSQL?** Database with brilliant highlights to store information, incorporation with numerous applications created in various dialects ​​of application advancement, similarity with Windows working frameworks, Linux, and so on. Simplicity of reconciliation with ETL arrangements, to store information stockrooms to communicate with business insight programming, permits replication of information with streamig replication, the accessibility of operational progression through the usage of pgpool, doubles to perform reinforcement and recuperation forms , execution of WAL, plausibility of executing auto vacuum to keep the objects of the database clean, variant updates of the postgresql SMBD, are simple and applications are not influenced. **What do you dislike about PostgreSQL?** PostgreSQL question sentence structure for some mind boggling inquiries like array,string capacities and case administrator are isn't anything but difficult to compose . Establishment and setup of PostgreSQL isn't as simple as MySQL. Documentation isn't in the same class as MySQL and it is bit more diligently to google query items. **Recommendations to others considering PostgreSQL:** PostgreSQL offers a strong database stage on which to fabricate applications for associations not willing to pay huge yearly upkeep charges. It scales well from little single use applications to vast bunched undertaking wide frameworks. The open source permit gives you a chance to introduce the same number of examples as you requirement for nothing. The open source, norms consistent database permits you complete adaptability in structuring the database and any applications it supports. PostGIS and pgRouting are database augmentations that add enormously to the abilities of the item and are center to our GIS foundation. Documentation for the item is best in class and the client network is amazing. In the event that you so wish, bolster contracts are accessible from various providers in the UK and universally. PostgreSQL is additionally accessible from many cloud administration providers and keeps running on all major working frameworks **What problems is PostgreSQL solving and how is that benefiting you?** The business issue that I am explaining with PostgreSQL was to inquiry information for further handling. I was dealing with producing keen reports with information from an Alfresco Architecture whose information dwelled in a PostgreSQL database. The advantages I watched were, it was allowed to utilize and the questions worked splendidly. The database is turning into the single wellspring of truth for every spatial datum in the association. The adaptability offered by the database has improved the proficiency of various distinctive information creation and upkeep work processes and thus we have developed the quantity of clients from 10 to 75. ### 33. ITS FREE **Rating:** 4.5/5.0 stars **Reviewed by:** Aby J. | Technical Lead, Mid-Market (51-1000 emp.) **Reviewed Date:** April 03, 2019 **What do you like best about PostgreSQL?** 1. Free code database manager, which is not used for licensing. 2. Easy to install and configure in any operating system. 3. Ideal for relational databases. 4. It has a large community in which you can share doubts. 5. It is stable and reliable, scalable and secure with the correct user management. 6. Can work with small and large databases. 7. Handles the SQL language. **What do you dislike about PostgreSQL?** For some, not having support online or with an official help center can be a big disadvantage **What problems is PostgreSQL solving and how is that benefiting you?** We have a DMS product where we are using PostgreSQL as DB ### 34. The best database on the market is open source **Rating:** 5.0/5.0 stars **Reviewed by:** Gabriel B. | Head of Engineering, Small-Business (50 or fewer emp.) **Reviewed Date:** September 26, 2019 **What do you like best about PostgreSQL?** PostgreSQL offering is way above the one of competitors like Oracle, MySQL or Microsoft's SQL Server **What do you dislike about PostgreSQL?** Major version upgrade process requires downtime. Most other databases avoid this painful process. **What problems is PostgreSQL solving and how is that benefiting you?** Being able to generate fast and powerful reporting aggregating gigabytes of data. ### 35. Great open source database **Rating:** 4.5/5.0 stars **Reviewed by:** Matthew W. | Software Developer, Mid-Market (51-1000 emp.) **Reviewed Date:** March 26, 2019 **What do you like best about PostgreSQL?** Open source, lots of data types (like arrays and queryable JSON), lots of support in the community like Docker Hub, lots of examples online to reference, many managed services available form various cloud providers. **What do you dislike about PostgreSQL?** Bad free tooling - pgAdmin4 is very awkward and slow to use. **Recommendations to others considering PostgreSQL:** Great choice as long as you don't rely too much on GUI tools to work with the database for creating tables, etc. Most administrative tasks are best performed via queries. **What problems is PostgreSQL solving and how is that benefiting you?** Using it to store relational data for various microservices. It is our goto SQL database technology because it is open source and has the features we need. Bonus is that because we use Google Cloud, we can take advantage of their Cloud SQL managed service which has a PostgreSQL version. This reduces our operations costs. ### 36. OLAP Database Management System **Rating:** 4.0/5.0 stars **Reviewed by:** Momataj B. | Data Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** March 07, 2019 **What do you like best about PostgreSQL?** Open-source relational database management system and easier to handle and simple database architecture compare to other database base engine. It also supports NoSQL features. It's also easier to implement clustering and replication of the database, and migration to the cloud. **What do you dislike about PostgreSQL?** Table Indexing, A found it bit complicated compared to Oracle and MS SQL **Recommendations to others considering PostgreSQL:** Yes, Mostly when people ask me the cheapest database system for small enterprises **What problems is PostgreSQL solving and how is that benefiting you?** Database management system for Online Analytical Processing. Variety of features for storing data such as JSON, NOSQL, ARRAY etc, and easy to integrate with other systems using JDBC, connection, a faster-database engine for querying bigger tables ### 37. Good for the price, if you know what I mean **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Electrical/Electronic Manufacturing | Mid-Market (51-1000 emp.) **Reviewed Date:** April 25, 2019 **What do you like best about PostgreSQL?** It's easy to use, it solves the issue and lets you do most of your work. My favorite is definitely the foreign data wrapers, which provides a standardized way to access and manipulate data stored externally to the Postgres server you’re connecting to. **What do you dislike about PostgreSQL?** A few of my complains: I dont like that it doesn't let you edit queries when you try to edit a quick select that the tool auto generated. The MONEY type is horrible. Run away. Use NUMERIC. To write procedural code you need a DO LANGUAGE plpgsql $$ BEGIN ...code here ... END; $$; block. You can't write it inline like you can PL/SQL or T-SQL. (On the other hand, it helps reduce the amount of DBMS-specific SQL extensions and procedural code sneaking into the application's queries). Don't use more than 1000-ish columns. There's a hard limit somewhere around 1400, depending on data type, but usually lower.You cannot remove typenames from an enum data type. Though you can add new ones. **Recommendations to others considering PostgreSQL:** It's a good starter to advanced tool to use. I highly recommend it if you are a little lost of dont know where to start. You can basically do everything you aim for without getting into very specific types and functions. Give it a try, you can run it locally for free and decide for yourself. **What problems is PostgreSQL solving and how is that benefiting you?** Management of big sql databases, with lots of data stored, partitioned tables, triggers and Hash, GIN and BRIN Indexes. In particular this last indexes with allow us to boost our performance for several important queries. ### 38. Rock Solid stability **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Higher Education | Enterprise (> 1000 emp.) **Reviewed Date:** February 02, 2019 **What do you like best about PostgreSQL?** PostgresSQL is one of the most stable and functionally rich open source RDBMS. It performs really well while implementing complex queries. It is also convenient to shift your database architecture into PostgresSQL. Because of its ubiquity, you can find solutions to any issue you might face on the online community. , PostgreSQL is offering an amazing amount of functionality for any database, let alone an open-source project. And in almost every case, the current functionality is just the first part of a long-term roadmap that the developers will continue to follow. **What do you dislike about PostgreSQL?** PostgreSQL's functionality in areas like Partitioning or query parallelization has been fairly weak. Also it's syntax is a wee bit different than most of the other SQL vendor languages but it's not significantly different. **What problems is PostgreSQL solving and how is that benefiting you?** The business problem that I am solving with PostgreSQL was to query data for further processing. I was working on generating intelligent reports with data from an Alfresco Architecture whose data resided in a PostgreSQL database. The benefits I observed were, it was free to use and the queries functioned perfectly. ### 39. No SQL DB **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Enterprise (> 1000 emp.) **Reviewed Date:** May 01, 2019 **What do you like best about PostgreSQL?** It is an open source tool. The best thing about PostgreSQL is that it's a really good tool for complex data-models. It's a one stop solution for almost all sort of data problems. **What do you dislike about PostgreSQL?** Installation and configuring it is a little challenging. It's Usability and learning curve is pretty high. psql command line will seem foreign compared to other sql queries and it needs a cheat sheet to learn and memorize the commands. **Recommendations to others considering PostgreSQL:** It has a high learning curve but, since it's open source, therefore, it has a huge online community to support. Once you acclimatize with the command line for Postgres, you can solve any large data problems easily. **What problems is PostgreSQL solving and how is that benefiting you?** It solves all sort of data problems, data storage, data extraction, manipulation, etc. It has really good functions for data storage and manipulation. It is best when used against complex data models. ### 40. Powerful, Flexible, Database **Rating:** 5.0/5.0 stars **Reviewed by:** Carson W. | CTO, Small-Business (50 or fewer emp.) **Reviewed Date:** February 01, 2019 **What do you like best about PostgreSQL?** I have used this database for a number of years now and have to say it gives one the most bang for one's buck. It is extremely powerful, and flexible with the addons provided, hstore, jsonb, ltree etc. its by default powerful, so if you're looking for a simple database this is not for you. This database is still fairly easy to use, but it leaves out a lot of things that are default to mysql (mariadb) **What do you dislike about PostgreSQL?** I wish that the ltree implementation supported dashes so full uuids could be used. Otherwise there isn't really that much to complain about, better support for built in under the hood horizontal sharding would be nice but that would be hugely complicated and probably wouldn't work. **Recommendations to others considering PostgreSQL:** Give it a chance, the cost of learning is worth the power it affords. **What problems is PostgreSQL solving and how is that benefiting you?** Our data storage for our whole app is in postgres. ### 41. Fast growing RDBMS **Rating:** 3.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Enterprise (> 1000 emp.) **Reviewed Date:** September 28, 2019 **What do you like best about PostgreSQL?** Its an open source database, flexibility to tweak code to suit your needs, active developer community, stability and internal design. JSON support. Available modified versions like TimeScaleDB which scales really good. **What do you dislike about PostgreSQL?** No native support of multi-master. Have to rely on commercial vendors. Bugs in logical decoding which restricts reliable integration with kafka. **Recommendations to others considering PostgreSQL:** Growing RDBMS with enthusiastic community of developers behind **What problems is PostgreSQL solving and how is that benefiting you?** Data storage for web applications. ### 42. Massively parallel processing data warehouse **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Internet | Mid-Market (51-1000 emp.) **Reviewed Date:** June 22, 2019 **What do you like best about PostgreSQL?** We use Postgresql for our data warehouse and we love the software because of its capability to handle complicated SQL queries for financial analysis and other workflows. **What do you dislike about PostgreSQL?** I dislike that Postgresql has many types of databases and you have to choose the proper one to get the correct degree of efficiency. **What problems is PostgreSQL solving and how is that benefiting you?** The problems I'm solving with Postgres Is the need to run analytic SQL queries in a scalable and efficient manner for our analytic capabilities. ### 43. MULTI SPECIALITY DATABASE WITH ZERO COST **Rating:** 4.0/5.0 stars **Reviewed by:** SUBHA P. | Technical Lead, Enterprise (> 1000 emp.) **Reviewed Date:** March 27, 2019 **What do you like best about PostgreSQL?** Open source ,highly secure, good concurrency control. Designed with minimal configuration files as PostgreSQL.conf and pg_hba.conf yet powerful Has very good inbuilt replication and minimum data loss Can have contrib modules as extensions PostGIS is an excellent one for GIS systems Multiple high effective availability solutions for PostgreSQL(REPMGR,PATRONI etc) &Load balancers(pgpool,pgbouncer) are available Very simple GUI tool for developers.pgAdmin good bench marking tool pgbench **What do you dislike about PostgreSQL?** Lack of support on the new versions Could have given better performance in windows environment **What problems is PostgreSQL solving and how is that benefiting you?** OLTP applications have been smooth and quick response of queries PostGIS is so amazing along with pointcloud and other good features making it no 1 for GIS systems Greenplum built on Postgres 8 serves wonderfully OLAP and large datasets ### 44. 3 years of PostgreSQL **Rating:** 4.5/5.0 stars **Reviewed by:** Vijay B. | Business Analyst, Enterprise (> 1000 emp.) **Reviewed Date:** September 03, 2019 **What do you like best about PostgreSQL?** postgreSQl supports ACID nd transaction, it has divert indexing technique and flexible full text search. **What do you dislike about PostgreSQL?** None as of now **Recommendations to others considering PostgreSQL:** Start using it **What problems is PostgreSQL solving and how is that benefiting you?** It allows you to add custom functions developed using different programming languageslike C/C++, Java, and etc ### 45. Free code database manager **Rating:** 5.0/5.0 stars **Reviewed by:** Nairoby D. | Administrador de Bases de Datos (DBA). Consultor TI, Enterprise (> 1000 emp.) **Reviewed Date:** October 31, 2018 **What do you like best about PostgreSQL?** Free database manager, with only download and install you can have the world of databases in full, with the best options of any proprietary driver, it is easy to install especially in free operating systems, it is ideal for database relational data, in terms of support, the best ally is the community of people who help others through forums, it is compatible with several graphic tools if they do not like to use the console, configuring a cluster is super simple and on the Internet the information works wonderfully with large databases. **What do you dislike about PostgreSQL?** If you use postgres by console and not with any graphical tool such as pgadmin or dbeaver you must have intermediate knowledge, you may notice some slowness in massive insertions but this is related to the good design of the database **Recommendations to others considering PostgreSQL:** The administration of a postgres cluster is great, we can synchronize a slave and a master and it works perfectly the synchronization and replication **What problems is PostgreSQL solving and how is that benefiting you?** I work daily in the management of postgres databases, used the console for backup and restore issues since they are much faster ### 46. Postgres is fine **Rating:** 3.0/5.0 stars **Reviewed by:** daniel l. | Python Dev, Small-Business (50 or fewer emp.) **Reviewed Date:** June 06, 2019 **What do you like best about PostgreSQL?** The built in full text search functionality. **What do you dislike about PostgreSQL?** The Admin UI, it is difficult to learn, and hard to do simple things like look at a table in the DB **What problems is PostgreSQL solving and how is that benefiting you?** Using it as a database to store information for the company web app ### 47. Flexible and fastest Data base for higher scale projects **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** January 14, 2019 **What do you like best about PostgreSQL?** Postgres data base is light weighted and flexible data base.Recently we have migrated to Postgres and its really easy to develop and maintain.Since it is open source we got advantage to spend money on cloud services to maintain independently.This data base has lot features and we can use for large scale applications. **What do you dislike about PostgreSQL?** Some of the common SQL language syntax can be maintained without customizations.Some time we feel difficulty to find syntax in online.Otherwise, this DB is better than other open source DB tools.Some times we found some bugs which is related to tags and queries, especially libraries can be improved and documentation can be provided in detail level. **Recommendations to others considering PostgreSQL:** Strongly recommended DB for any open source ideas. **What problems is PostgreSQL solving and how is that benefiting you?** We are able to reduce cost by migrating to open source Db. We are able to separate all functions and views without any extra efforts while migrating. These DB helped us to reduce overall cost in Cloud as well, on top of all advantages, query language is very simple. ### 48. Great Database System **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in E-Learning | Mid-Market (51-1000 emp.) **Reviewed Date:** January 08, 2019 **What do you like best about PostgreSQL?** Well, over time MySQL and PostgreSQL have grown closer and closer together, but for the longest time I've enjoyed using postgres over other free open source RDMBS because it had more analytical functions. Postgres has been supporting tricky things like window functions which was always super useful for tricky aggregations for reports. However, what I like best about postgres is probably the actual documentation that is easily available that includes tons of explanations and examples. This means I can quickly make changes and figure out how to make my application needs work just by myself, even if I've never had to use Postgres or another RDMBS to do that task before. **What do you dislike about PostgreSQL?** I can't say I dislike anything about postgres. The things that are 'bad' about postgres are what you get for having a relational database that uses hard disk as storage. But those are normal things that honestly don't usually slow you down or hurt your application. Sometimes I'll use redis for a fast, non-relational in-memory database, but otherwise I always use postgres since it's free, documented well, and a great tool. **Recommendations to others considering PostgreSQL:** These days you can drop in replace for MySQL pretty much, but I prefer postgres for the great documentation. **What problems is PostgreSQL solving and how is that benefiting you?** Well, I simply use postgres to save data in one place like any database. Postgres is a great open source relational database system so it helps keep your data in one place and normalized. I will often setup mini web apps for my company's other teams to quickly pull/aggregate data and reports, and postgres is great for that. ### 49. #1 db server for web-app performance **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** October 22, 2019 **What do you like best about PostgreSQL?** Well documented installation procedures for most common Linux OS, query language and security rules **What do you dislike about PostgreSQL?** Absence of GUI editor and absense of compatibility with old version of phpmyadmin **Recommendations to others considering PostgreSQL:** Use pgAdmin as an alternative of phpmyadmin **What problems is PostgreSQL solving and how is that benefiting you?** Get improved performance from a web-app that was previously using mysql server ### 50. A powerful open source software **Rating:** 4.5/5.0 stars **Reviewed by:** Samarth J. | Samarth Jain, Small-Business (50 or fewer emp.) **Reviewed Date:** February 03, 2019 **What do you like best about PostgreSQL?** 1. Postgres is open source and free to use. 2. Postgres is Acid compliant and thus no data is lost. 3. Since PostgreSQL supports JSON field which was not supported by Mysql which we were using before, it has become very easy for us to work with JSON data sets. We can easily query JSON fields using Postgres query language. 4. Postgres also has a very strong community, thus it is very easy for new developers to adapt as they can easily find support online **What do you dislike about PostgreSQL?** I couldn't find anything to dislike in PostgreSQL till now as it gives me all the features that were required in our web application. **Recommendations to others considering PostgreSQL:** A very powerful Rdbms **What problems is PostgreSQL solving and how is that benefiting you?** 1. Postgres has helped us to store and query JSON fields which was the biggest problem that we were facing with mysql. ## 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=6&qs=pros-and-cons§ion=pricing&secure%5Bexpires_at%5D=2026-08-06+14%3A56%3A36+-0500&secure%5Bsession_id%5D=b94798ee-ce75-43aa-9460-337ea1ba3a59&secure%5Btoken%5D=a8aaf24630eefa3a4c42858f9d0b3ae8d78e380b7e3d47e75bb3cdd6e578443d&format=llm_user) ## PostgreSQL Integrations - [Amazon Redshift](https://www.g2.com/products/amazon-redshift/reviews) - [Angular](https://www.g2.com/products/angular-dev-angular/reviews) - [Apache Superset](https://www.g2.com/products/apache-superset/reviews) - [Apache Tomcat](https://www.g2.com/products/apache-tomcat/reviews) - [cPanel](https://www.g2.com/products/cpanel/reviews) - [Databricks](https://www.g2.com/products/databricks/reviews) - [Docker](https://www.g2.com/products/docker-inc-docker/reviews) - [Entity Framework Core](https://www.g2.com/products/entity-framework-core/reviews) - [F5 NGINX](https://www.g2.com/products/f5-nginx/reviews) - [InMotion Hosting](https://www.g2.com/products/inmotion-hosting/reviews) - [Jenkins](https://www.g2.com/products/jenkins/reviews) - [Laravel](https://www.g2.com/products/laravel/reviews) - [Microsoft Power BI](https://www.g2.com/products/microsoft-microsoft-power-bi/reviews) - [n8n](https://www.g2.com/products/n8n/reviews) - [Next.js](https://www.g2.com/products/next-js/reviews) - [Node.js](https://www.g2.com/products/node-js/reviews) - [Omnis Studio](https://www.g2.com/products/omnis-studio/reviews) - [pandas python](https://www.g2.com/products/pandas-python/reviews) - [Pentaho Data Integration](https://www.g2.com/products/pentaho-data-integration/reviews) - [Prisma](https://www.g2.com/products/prisma-prisma/reviews) - [Python](https://www.g2.com/products/python/reviews) - [QGIS](https://www.g2.com/products/qgis/reviews) - [React Native](https://www.g2.com/products/react-native/reviews) - [Redis Software](https://www.g2.com/products/redis-software/reviews) - [Ruby on Rails](https://www.g2.com/products/ruby-on-rails/reviews) - [Tableau](https://www.g2.com/products/tableau/reviews) - [Visual Studio Code](https://www.g2.com/products/visual-studio-code/reviews) ## PostgreSQL Features **Management ** - Data Schema - Query Language - ACID - Complaint - Data Replication **Support ** - Text Search - Data Types - Languages - Operating Systems **Security** - Database Locking - Access Control - Encryption - Authentication **Performance ** - Disaster Recovery - Data Concurrency - Workload Management - Advanced Indexing - Query Optimizer **Database Features** - Storage - Availability - Stability - Scalability - Security - Data Manipulation - Query Language ## Top PostgreSQL Alternatives - [Microsoft SQL Server](https://www.g2.com/products/microsoft-sql-server/reviews) - 4.4/5.0 (2,128 reviews) - [MySQL](https://www.g2.com/products/mysql/reviews) - 4.4/5.0 (1,583 reviews) - [Oracle Database](https://www.g2.com/products/oracle-database/reviews) - 4.3/5.0 (935 reviews)