--- 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. Another open sourse RDBMS **Rating:** 5.0/5.0 stars **Reviewed by:** Amit G. | Senior Oracle DBA, Information Technology and Services, Enterprise (> 1000 emp.) **Reviewed Date:** July 31, 2018 **What do you like best about PostgreSQL?** Good for simple non critical applicatins, does what says on the tin. replciation backup and recovery is fantastic,. **What do you dislike about PostgreSQL?** Documentation and community support should improve, lack of support and help if you are stuck. **Recommendations to others considering PostgreSQL:** Please consider it for your non critical applications **What problems is PostgreSQL solving and how is that benefiting you?** Storange and retrival of data from the database ### 2. PostgreSQL review **Rating:** 5.0/5.0 stars **Reviewed by:** Yaniro B. | Bitcoin Crypto Currency Trader, Small-Business (50 or fewer emp.) **Reviewed Date:** October 20, 2017 **What do you like best about PostgreSQL?** Although the speed of response may seem deficient in small databases, that speed is maintained by increasing the size of the database, which is not the case with other programs, which slow down brutally. Unlimited installation: You can not sue a company for installing it on more computers than the license allows, as there is no cost associated with the software license. This allows for a more profitable business with large scale installations, we should not worry about being audited to see if we comply with the license, and there is flexibility and development without additional licensing costs. Considerable savings in operating costs: PostgreSQL has been designed to have lower maintenance and adjustment than products of commercial suppliers, retaining all the features, stability and performance. Stability and Reliability: No database crashes. Extensible: The source code is available for free, so that whoever needs to extend or customize the program can do so without costs. Multiplatform: Available on almost any Unix, with 34 platforms in the latest stable version, plus a native version of Windows in test state. Designed for high-volume environments: Using a row storage strategy called MVCC, it gets better response in large volumes. In addition, MVCC allows read-only accesses to continue reading consistent data while updating records, allowing hot backups Graphic design and database management tools. It supports the SQL92 / SQL99 standard and standard type data, clauses, functions, and extended commands of PostgreSQL. It can operate on different platforms, including Linux, Windows, Unix, Solaris and MacOS X. Good security system through the management of users, groups of users and passwords. Great storage capacity. Good scalability as it is able to adjust to the number of CPUs and the amount of memory available optimally, supporting a greater number of concurrent requests to the database correctly. **What do you dislike about PostgreSQL?** Compared to MySQL it is slower in insertions and updates because it has intersection headers that does not have MySQL. Online support: There are official forums, but there is no obligatory help. Consume more resources than MySQL. The syntax of some of your commands or statements is not at all intuitive. **Recommendations to others considering PostgreSQL:** YES **What problems is PostgreSQL solving and how is that benefiting you?** Multiversion concurrency control; the MVCC; this method adds an image of the state of the database to each transaction. This allows transactions to be made consistently, offering great performance advantages. For example, it is not necessary to use read locks when performing a transaction, which provides greater scalability. thus solving scalability problems. ### 3. Perfect for large projects **Rating:** 4.0/5.0 stars **Reviewed by:** Christian P. | Web Developer, Computer Software, Small-Business (50 or fewer emp.) **Reviewed Date:** July 22, 2018 **What do you like best about PostgreSQL?** Always number one being Open source. It’s also quite easy to transition from MySQL the learning curve it almost nonexistent. **What do you dislike about PostgreSQL?** The Admin tools aren’t that great. Can be a hassle to install on a windows machine. **What problems is PostgreSQL solving and how is that benefiting you?** We’ve been using python and feel they share some relational compatibility’s. It feels snappy and lightweight. ### 4. One of the best Hybrid database systems available **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.) **Reviewed Date:** July 30, 2018 **What do you like best about PostgreSQL?** PostgreSQL gives you the power of traditional relational DBMS system as well as the Power of json present in NoSql databases. You can Keep your table in flexible form to accommodate any kind of data. **What do you dislike about PostgreSQL?** It is good only for small and medium scale application, When data volumes exceeds few millions it needs a expert engineer to manage it. **What problems is PostgreSQL solving and how is that benefiting you?** We had a requirement of table, in which number is columns was not fixed, so we used JsonB datatype to store such kind of data. ### 5. Flexible and powerful **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.) **Reviewed Date:** July 30, 2018 **What do you like best about PostgreSQL?** It's a full on relational database with good tooling and an extensive community. Even better it's got built in support for json and array types and even has full-text search features. **What do you dislike about PostgreSQL?** It requires some care and feeding, and like all relational databases works best with well-structured data. **What problems is PostgreSQL solving and how is that benefiting you?** Great place to store app and user data. We were able to get up and running quite quickly and since cloud providers have good support for postgres was easy to set up HA and rotating backups ### 6. Excellent OpenSource Database with impressive performance and scaling capabilities **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Financial Services | Small-Business (50 or fewer emp.) **Reviewed Date:** August 03, 2018 **What do you like best about PostgreSQL?** Postgresql is open source, easy to setup, easy to replicate and backup. The "Select Distinct On" function really helps in seeking the right unique data from large data sets. **What do you dislike about PostgreSQL?** I would like to see better documentation about configuration parameters as well as optimization parameters that can be applied to the DB setup. **Recommendations to others considering PostgreSQL:** GUI based tools that help us optimize queries being executed on the DB would be very helpful. **What problems is PostgreSQL solving and how is that benefiting you?** We use Postgresql as our transactional system for our wealth management product. ### 7. Excellent open source object-relational database management system **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.) **Reviewed Date:** December 26, 2017 **What do you like best about PostgreSQL?** Once you've used it for awhile, it's natural. It's easy to see all the data you need, doesn't overcomplicate things either. Wildcard Search queries are simple and I love the number of extensions there are available for developers to take advantage of. I enjoy using the PostgreSQL app on Mac OSX. I always know when I have it running because I can see the icon on the top of my Desktop. **What do you dislike about PostgreSQL?** Installation can be tricky your first time around. I just helped a new developer set it up and it only took a few minutes of looking at the docs to give myself a reminder. The new developer was overwhelmed by the PostgreSQL documentation that he had kinda given up. After that, you'll quickly get the hang of it. PostgreSQL query syntax for more complex queries can be difficult and take a moment to learn but once you've gotten the hang of them, you'll be fine. **Recommendations to others considering PostgreSQL:** Although the documentation is a bit overwhelming at first glance, take some time and read through it. It'll help you in the long run and it's really not the scary. **What problems is PostgreSQL solving and how is that benefiting you?** We use as our main database for 5 different projects. We've never had any issues and we like the flexibility it offers us. ### 8. good pretty and cheap **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Accounting | Mid-Market (51-1000 emp.) **Reviewed Date:** July 31, 2018 **What do you like best about PostgreSQL?** It is easy to use and configure this produc **What do you dislike about PostgreSQL?** the Latino user community is not very big **Recommendations to others considering PostgreSQL:** sometimes it is necessary that a database is not so robust for average businesses **What problems is PostgreSQL solving and how is that benefiting you?** for small and medium projects is the best solution, because it is free. ### 9. A performant open source alternative to Oracle and SQL Server **Rating:** 4.0/5.0 stars **Reviewed by:** Antonio R. | Analista de Gestion TIC, Enterprise (> 1000 emp.) **Reviewed Date:** December 20, 2017 **What do you like best about PostgreSQL?** It is open source, it means we can look at the code and help to improve the product and troubleshoot bugs **What do you dislike about PostgreSQL?** it is very strict on its SQL language, Mysql lets you slack a bit, postgresql does not. **Recommendations to others considering PostgreSQL:** Read a lot about SQL, it uses strict language so you cant get away with things like In MYSQL. I recommend Heidisql to use with Postgresql, it is a great front end. **What problems is PostgreSQL solving and how is that benefiting you?** Data storage, We migrated an entire database from aging Oracle and SQL server to postgresql and we are very happy with it. We currently have many databases with it and we love it. Everything we think of a new product we choose Postgresql without a doubt. ### 10. Easy access to database **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Financial Services | Enterprise (> 1000 emp.) **Reviewed Date:** October 07, 2018 **What do you like best about PostgreSQL?** I like the command line interface and the ease of use of SQL to query the database. **What do you dislike about PostgreSQL?** There really wasn't anything I disliked about PostgreSQL. **What problems is PostgreSQL solving and how is that benefiting you?** PostgreSQL allowed my team to minimize redundancy and provide a greater level of normalization and security to our database. ### 11. easy to use for biz people **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Internet | Enterprise (> 1000 emp.) **Reviewed Date:** November 01, 2018 **What do you like best about PostgreSQL?** easy to use. fun to learn . and it's very powerful **What do you dislike about PostgreSQL?** UX can be improved . but it serves the purpose and better than others. **What problems is PostgreSQL solving and how is that benefiting you?** data analysis, mass manipulate of data ### 12. Great DB! **Rating:** 5.0/5.0 stars **Reviewed by:** Mithul G. | Software Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** August 16, 2018 **What do you like best about PostgreSQL?** Ease of queries and intuitive ways to search. **What do you dislike about PostgreSQL?** Harder to get community support, replication is not that well implemented **What problems is PostgreSQL solving and how is that benefiting you?** Stored high latency data used with Kafka and microservices for production environments. ### 13. Postgres is the most effective Open source Database **Rating:** 5.0/5.0 stars **Reviewed by:** Hari A. | ECM Developer, Information Technology and Services, Small-Business (50 or fewer emp.) **Reviewed Date:** December 26, 2017 **What do you like best about PostgreSQL?** It's open source. So, its great for startup companies. It is fully SQL compliant. The admin tool PGAdmin is powerful. I am impressed with the custom data types supported by Postgres mainly JSONB. **What do you dislike about PostgreSQL?** We faced problem while using custom data types like JSONB. Inserting data to these type of columns via Hibernate is not straightforward. We referred a couple of articles on that to resolve the issue. https://github.com/thjanssen/HibernateJSONBSupport/tree/master/PostgresJSONB **Recommendations to others considering PostgreSQL:** Postgres is the most effective Open source Database **What problems is PostgreSQL solving and how is that benefiting you?** We are using Postgres as a database choice for a custom product development. This database will contain a large amount of data. As an open source, it provides enterprise level RDBMS functionalities. ### 14. postgre sql is an object oriented database **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** November 13, 2018 **What do you like best about PostgreSQL?** that it is object oriented and lets us define user defined datatypes **What do you dislike about PostgreSQL?** that it is more complicated than mysql and nosql **Recommendations to others considering PostgreSQL:** recommended **What problems is PostgreSQL solving and how is that benefiting you?** data encapsulation ### 15. Best in class **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Small-Business (50 or fewer emp.) **Reviewed Date:** April 20, 2018 **What do you like best about PostgreSQL?** Everything about postgres is quite lovely. We use it for our startup and its quite cool. We switched from MySQL to postgres. One thing that I most love in postgres is that it is schema based, which makes it cool for our needs. **What do you dislike about PostgreSQL?** Nothing much I dislike about postgres, Its quite cool. Maybe one thing i would suggest (Not I dislike). Maybe we can have some GUI based tool for querying for non-tech guys to query too. Other than the pgAdmin tool. **Recommendations to others considering PostgreSQL:** If you really want some Database that is less complex and easy to use, then I would suggest to go with Postgres. And the community is also quite growing super fast. **What problems is PostgreSQL solving and how is that benefiting you?** We use it as the primary database for our web-app. ### 16. Excelent and flexible open source SQL database **Rating:** 4.5/5.0 stars **Reviewed by:** Arik B. | CEO & Co-Founder, Computer Software, Small-Business (50 or fewer emp.) **Reviewed Date:** December 13, 2017 **What do you like best about PostgreSQL?** PostgreSQL is a mature database server with large user's community and continue development. Installation is very simple and also integration with multiple development environment is supported we user C++ library, PHP and Java integration **What do you dislike about PostgreSQL?** would like better admin package, managing changes as versions is bit complex **Recommendations to others considering PostgreSQL:** This is an open source SQL database that include many of the much more expensive solutions and it is open source with wide community of contributers **What problems is PostgreSQL solving and how is that benefiting you?** We use PostgreSQL as our system DB and benefit from wide range of features and extensions. We need to access the database from several environment and this is very simple and supported with large number of libraries and connections. ### 17. Essential Tool **Rating:** 4.0/5.0 stars **Reviewed by:** Samuel C. | Originations Specialist, Financial Services, Mid-Market (51-1000 emp.) **Reviewed Date:** July 29, 2018 **What do you like best about PostgreSQL?** Easy to learn; Widely used in our company **What do you dislike about PostgreSQL?** Little keyboard shortcuts available; browser program does not have ability to save macro **Recommendations to others considering PostgreSQL:** Learn how to use their browser program **What problems is PostgreSQL solving and how is that benefiting you?** Locating accounts; Filling in data for report ### 18. Pros and cons of PostgreSQL **Rating:** 2.5/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** July 17, 2018 **What do you like best about PostgreSQL?** The first thing to highlight is that it is open source, therefore it has no licensing costs. It is undoubtedly the best free option. Its GIS extensions are also worth mentioning. **What do you dislike about PostgreSQL?** Its performance handling large volumes leaves much to be desired and the administrative tools are not as powerful as we would like. **Recommendations to others considering PostgreSQL:** Yes, especially in projects with open source technologies. **What problems is PostgreSQL solving and how is that benefiting you?** We have used this database in a cadastral management project where we needed to manage both alphanumeric and graphic information. ### 19. Great **Rating:** 4.0/5.0 stars **Reviewed by:** Eduardo H. | Ingeniero informático, Consumer Goods, Small-Business (50 or fewer emp.) **Reviewed Date:** July 17, 2018 **What do you like best about PostgreSQL?** Excellente software to manage databases. Is oriented to obejects and the best of all is that is free. **What do you dislike about PostgreSQL?** Don't have a official support from the depeloper of the software. **Recommendations to others considering PostgreSQL:** Great free software **What problems is PostgreSQL solving and how is that benefiting you?** Stabily and fidelity of data. ### 20. A very versatile database **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** October 12, 2018 **What do you like best about PostgreSQL?** Has various extensions and a very wide dev base. supports foreign data wrappers. **What do you dislike about PostgreSQL?** Could support more efficient caching and in-memory **What problems is PostgreSQL solving and how is that benefiting you?** free opensource with more resource efficiency ### 21. Use as PostgreSQL not as MySQL; get to know it the philosophy behind it first! **Rating:** 4.5/5.0 stars **Reviewed by:** Ramon B. | Senior Software Engineer, R&D, Broadcast Media, Enterprise (> 1000 emp.) **Reviewed Date:** September 19, 2017 **What do you like best about PostgreSQL?** Awesome built in data types, JSON with indexing to then work with triggers and locks! Best of both NoSQL and SQL. The community is very active, as well as several commercial enterprise offerings. **What do you dislike about PostgreSQL?** I found there to be a steep initial learning curve to be able to build an application effectively to use all the built-in magic if the development team come from using MySQL or MSSQL. Once the brain wraps around some of the over loaded terminology **Recommendations to others considering PostgreSQL:** have your team take the time to read or watch an introduction to postgresql methodology, and well as a comparison against MySQL. The hour/hour and a half of time in the beginning can save hours/days of reworking to use the internal tools to scale properly. **What problems is PostgreSQL solving and how is that benefiting you?** We needed a database or databases that we could effectively have json stored, indexed, but allow for locked tables. ### 22. Object-relational database management system, free and open source **Rating:** 5.0/5.0 stars **Reviewed by:** Thanh P. | Software Engineer, Information Technology and Services, Small-Business (50 or fewer emp.) **Reviewed Date:** November 15, 2017 **What do you like best about PostgreSQL?** A simple database server: store and query data Multiversion concurrency control (MVCC) per "transaction" Support JSON data type from version 9.2 Developer can define their objects, inherit from default system defined. Has full text search and asynchronous notifications **What do you dislike about PostgreSQL?** Performance and slow on older version. Need update at least 9.4 for better performance **Recommendations to others considering PostgreSQL:** PostgreSQL is an object-relational database management system (ORDBMS) with an emphasis on extensibility and standards compliance. Support full text search and regular expression JSON and BJSON data type for flexible data Snapshot a version of database whenever transaction trigger. **What problems is PostgreSQL solving and how is that benefiting you?** Full text search and regular expression JSON and BJSON data type for flexible data Snapshot a version of database whenever transaction trigger. ### 23. One of the best services **Rating:** 5.0/5.0 stars **Reviewed by:** Pablo G. | Mid-Market (51-1000 emp.) **Reviewed Date:** July 31, 2018 **What do you like best about PostgreSQL?** Efficiency, power, easy of use and environment. **What do you dislike about PostgreSQL?** The environment may be a bit powerful and with more functions. **What problems is PostgreSQL solving and how is that benefiting you?** Management of several databases. ### 24. Great DB, lots of community support **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Civil Engineering | Small-Business (50 or fewer emp.) **Reviewed Date:** July 30, 2018 **What do you like best about PostgreSQL?** It's very easy to setup with cloud hosting providers like Heroku and GCP **What do you dislike about PostgreSQL?** command line tools for mac are unintuitive **What problems is PostgreSQL solving and how is that benefiting you?** Scalable database ### 25. Scalable, flexible databases for any use **Rating:** 4.5/5.0 stars **Reviewed by:** Eric M. | Principal Software Engineer, Computer Software, Small-Business (50 or fewer emp.) **Reviewed Date:** October 24, 2017 **What do you like best about PostgreSQL?** Data of almost any format fits well in Postgres. You can use one database instance to house multiple databases, but also host multiple discrete schemas in each database (each with its own set of tables). The scope with which you can shape and manage data structures is remarkable! **What do you dislike about PostgreSQL?** Some key features from other database systems (like UUIDs for identifiers) are not included by default and require installing separate extensions (pgcrypto for UUIDs). Forgetting to install an extension before importing data can lead to data loss and errors all over the place! **Recommendations to others considering PostgreSQL:** Keep your data structures clean and ensure your relations don't blend across schemas too often. While cross-schema queries are possible, building your application to use them will limit you in terms of scalability should you ever wish to spread your database across multiple servers/instances. **What problems is PostgreSQL solving and how is that benefiting you?** We use Postgres to host our primary application database. It's given us massive scalability by allowing us to tie multiple microservices together into one application. ### 26. PostGresql for database **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Food & Beverages | Enterprise (> 1000 emp.) **Reviewed Date:** September 02, 2018 **What do you like best about PostgreSQL?** The abilty to quickly frame the ddl and form the databases and various tables **What do you dislike about PostgreSQL?** There is nothing that I dislike about PostGreSql **What problems is PostgreSQL solving and how is that benefiting you?** All the databases are handled using it. It helps reduce time. ### 27. Performant, reliable and scalable **Rating:** 5.0/5.0 stars **Reviewed by:** Marco P. | Co-founder / CTO, Small-Business (50 or fewer emp.) **Reviewed Date:** December 19, 2017 **What do you like best about PostgreSQL?** We use PostgreSQL in production since 8 years now, in a multi-nodes HA setup based on the built-in streaming replication. PostgreSQL is a great database, offering high performances and allowing to easily scale read-replicas with the built-in streaming replication. **What do you dislike about PostgreSQL?** The major issue with PostgreSQL is the complexity of doing a major version upgrade with nearly zero downtime. Starting from PostgreSQL 10 this issue has been largely reduce thanks to the logical replication. **What problems is PostgreSQL solving and how is that benefiting you?** We use PostgreSQL as main data storage for our online service. ### 28. Great database for cloud software **Rating:** 5.0/5.0 stars **Reviewed by:** Arturo J. | Director de Tecnología, Computer Software, Small-Business (50 or fewer emp.) **Reviewed Date:** July 10, 2018 **What do you like best about PostgreSQL?** PostgreSQL is a great database for cloud development **What do you dislike about PostgreSQL?** Documentation is a nit tricky to understand at first **What problems is PostgreSQL solving and how is that benefiting you?** Cloud database ### 29. PostgreSQL database review **Rating:** 4.0/5.0 stars **Reviewed by:** Manjushri S. | Java Software Developer, Information Technology and Services, Enterprise (> 1000 emp.) **Reviewed Date:** November 29, 2017 **What do you like best about PostgreSQL?** PostgreSQL is an open source database and in that way has a great advantage over other licensed databases like Oracle. Currently, we have been trying to migrate all legacy applications from Oracle to postGRESQL.PostgreSQL database works very well with hibernate JPA and we have been using it extensive along with the Spring framework. **What do you dislike about PostgreSQL?** There is no good client to use the database been using pg admin and I am not really a big fan of the interface provided by pgadmin, we cannot "pin" any query results unlike the SQL developer. **What problems is PostgreSQL solving and how is that benefiting you?** Have been using postgreSQL for couple of applications on the financial domain. Works great with simple applications with relatively less complex database design. Have hosted postGRESQL on AWS and used cross region replication, encryption. ### 30. PostgreSQL usually gets the job done **Rating:** 4.0/5.0 stars **Reviewed by:** Justin H. | Carrier Sales / Switch Technician, Telecommunications, Small-Business (50 or fewer emp.) **Reviewed Date:** March 04, 2018 **What do you like best about PostgreSQL?** Data integrity, wide variety of column types, great documentation **What do you dislike about PostgreSQL?** Data import can be difficult, usually needs a 3rd party tool even with the simplest CSV files. **What problems is PostgreSQL solving and how is that benefiting you?** Powers back end web sites, stores and reports on call detail records, sales leads. ### 31. Best for Any medium scale sized project **Rating:** 5.0/5.0 stars **Reviewed by:** Sorabh S. | Head Of Development, Enterprise (> 1000 emp.) **Reviewed Date:** January 05, 2018 **What do you like best about PostgreSQL?** ANSI Compliant SQL, Verbose logging, Replication ease, Indexing performance **What do you dislike about PostgreSQL?** Nothing as such , would recommend for further projects also. **Recommendations to others considering PostgreSQL:** Give it a try, it wont disappoint you. **What problems is PostgreSQL solving and how is that benefiting you?** Its used for financial Applications for a insurance company. We are creating web and mobile based apps for this company, although previously it was also good with another db product, but with pogres ease of use, and orm compatibility is better. ### 32. Postgres is the best **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.) **Reviewed Date:** August 01, 2018 **What do you like best about PostgreSQL?** Fast secure frequently updated and plenty of drivers available. **What do you dislike about PostgreSQL?** Not as popular as some other solutions so which can make it hard to debug strange errrs **What problems is PostgreSQL solving and how is that benefiting you?** Postgres works great for web applications. Easy to.scale for medium to large scale sites ### 33. Great Versatile DBMS software **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Higher Education | Enterprise (> 1000 emp.) **Reviewed Date:** July 10, 2018 **What do you like best about PostgreSQL?** The ability to create databases without any price requirement and allowing to run SWL commands on those databases dynamically is great **What do you dislike about PostgreSQL?** There is no GUI to check the created databases and their values for a quick glance. **What problems is PostgreSQL solving and how is that benefiting you?** Managing Sales databases and checking relations between different databases to identify new customers ### 34. Great database system **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Higher Education | Enterprise (> 1000 emp.) **Reviewed Date:** July 13, 2018 **What do you like best about PostgreSQL?** I enjoyed the capability to use other programming languages within it to allow for easy data modifications and more. **What do you dislike about PostgreSQL?** The thing that was the hardest to get comfortable with was all the short hand notation. Most are single character, which can get confusing. **What problems is PostgreSQL solving and how is that benefiting you?** Postgre is extremely scalable. ### 35. Fantastic Database for all use cases **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Insurance | Enterprise (> 1000 emp.) **Reviewed Date:** July 30, 2018 **What do you like best about PostgreSQL?** It's free, and I can install it on any of my VMs and make it work for me. **What do you dislike about PostgreSQL?** Nothing in particular. There isn't enough on Stackoverflow for this product as compare to Oracle. **What problems is PostgreSQL solving and how is that benefiting you?** Serve data for applications. ### 36. PostgreSQL, the best fusion between SQL and programming **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Telecommunications | Mid-Market (51-1000 emp.) **Reviewed Date:** July 20, 2018 **What do you like best about PostgreSQL?** The immense possibility of programming allowed by the code, allowing the generation of interfaces from SQL code. **What do you dislike about PostgreSQL?** None, it is a very good alternative to the fusion of any programming language that works with SQL. **What problems is PostgreSQL solving and how is that benefiting you?** Queries and development on databases ### 37. Need to improve perofrmance **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** July 27, 2018 **What do you like best about PostgreSQL?** I like the structure. I like Posgtess but it can be better **What do you dislike about PostgreSQL?** Tools. I do not like the tools that are used to connect to the server **What problems is PostgreSQL solving and how is that benefiting you?** I am creating reports. I user queries to generate reports. ### 38. Heading for Big Data/distributed Cloud OLAP solutions **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** July 30, 2018 **What do you like best about PostgreSQL?** Ease of use, rich feature set for EDW implementations **What do you dislike about PostgreSQL?** Not all features are easy to port over from (SQL, Oracle). Needs heavy backers like Redshift **What problems is PostgreSQL solving and how is that benefiting you?** Net new OLAP system on AWS Redshift (all PG-SQL implemented) ### 39. relational databases **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Enterprise (> 1000 emp.) **Reviewed Date:** July 18, 2018 **What do you like best about PostgreSQL?** What stands out the most, unlike others, is that it has GIS support, which is useful for certain applications. **What do you dislike about PostgreSQL?** In principle, for what I have used it, I have never had problems. **What problems is PostgreSQL solving and how is that benefiting you?** Great GIS support, therefore it allows spatial queries. ### 40. Postgres **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** July 13, 2018 **What do you like best about PostgreSQL?** Postgers is open source, easy to use RDBMS. There are plenty of admin tools available and good documentation. **What do you dislike about PostgreSQL?** There is not much to dislike about it....I use it at work every day. **What problems is PostgreSQL solving and how is that benefiting you?** We use it as a relational database for content management software ### 41. Our doms **Rating:** 5.0/5.0 stars **Reviewed by:** Ivy P. | Escalation Resolution Specialist, Real Estate, Enterprise (> 1000 emp.) **Reviewed Date:** April 27, 2018 **What do you like best about PostgreSQL?** I like that it keeps tracks of our Doms and inventory data. We can always go back where we left off. **What do you dislike about PostgreSQL?** It can be slow at times when the data is alot. **What problems is PostgreSQL solving and how is that benefiting you?** At this time we don't have any problems with this software ### 42. Great gui and ease of use **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.) **Reviewed Date:** June 30, 2018 **What do you like best about PostgreSQL?** Easy to impement to an java application using jdbc. **What do you dislike about PostgreSQL?** Sometimes it freezes and security groups can be difficult if you Connect in different places. **Recommendations to others considering PostgreSQL:** Syntax can be hard if you use gui and then use sql Commands in jdbc **What problems is PostgreSQL solving and how is that benefiting you?** Connecting to a bank application ### 43. Free tool for more advanced SQL users **Rating:** 2.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** July 12, 2018 **What do you like best about PostgreSQL?** It comes with a lot of free features. Good basic product. **What do you dislike about PostgreSQL?** I used it as a learning platform. It was intimidating for a first time user. The download was cumbersome. **What problems is PostgreSQL solving and how is that benefiting you?** Good teaching tool for employees learning SQL. ### 44. Used on almost every project **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Internet | Mid-Market (51-1000 emp.) **Reviewed Date:** July 16, 2018 **What do you like best about PostgreSQL?** It's easy to use and the tools that are available for it, like pgAdmin, are supported on different OS. **What do you dislike about PostgreSQL?** pgAdmin's user interface is not optimal, it can be definitely improved **What problems is PostgreSQL solving and how is that benefiting you?** Fast and reliable storage ### 45. Postgresql **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** July 30, 2018 **What do you like best about PostgreSQL?** Data processing of huge volumes is very fast **What do you dislike about PostgreSQL?** Documentation is not adequate. Very little information available online **What problems is PostgreSQL solving and how is that benefiting you?** Processing of hundreds of millions of rows within seconds ### 46. excellent DB that integrates with the package **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Banking | Mid-Market (51-1000 emp.) **Reviewed Date:** July 16, 2018 **What do you like best about PostgreSQL?** reliability and total compatibility with Oracle DB **What do you dislike about PostgreSQL?** probably the need for additional training **Recommendations to others considering PostgreSQL:** evaluate the sql compatibility well before migration **What problems is PostgreSQL solving and how is that benefiting you?** the company but uses the db for core business applications ### 47. Best DB for Open Relational DB **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** May 01, 2018 **What do you like best about PostgreSQL?** I loved the Common table Extensions (CTE). This is one of the excellent feature you see in PostgreSQL. **What do you dislike about PostgreSQL?** I really don't see anything dislike. Moreover i am loving its features **What problems is PostgreSQL solving and how is that benefiting you?** I would say Database Transaction Protection.... Multiple changes either all take place, or none of them. This is amazing... Data always in a consistent state across the platform In-process changes invisible to outside users Data reliably stored ### 48. Simple to use, Easy SQL management tool. **Rating:** 5.0/5.0 stars **Reviewed by:** Curtis M. | Senior Test Automation Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** October 27, 2017 **What do you like best about PostgreSQL?** Coming from a MySQL background it is very similar and allows me to manage my data in any way I see fit. **What do you dislike about PostgreSQL?** The PostgreSQL management tools out there today aren't the best. It's hard to find a GUI tool that allows me to manage my data simply. **Recommendations to others considering PostgreSQL:** If you are used to MySQL and are unable to use that for your database management needs, PostgreSQL is a great alternative. With all the other tools that are being offered right now, AWS and GAE, this is still light weight and open source. **What problems is PostgreSQL solving and how is that benefiting you?** I have a lot of data that I need to keep historical track of and PostgreSQL keeps that all in one place that allows me to keep track of it. ### 49. We use PostgreSQL for enhancing our functionality pertaining to Data storage as compared to RDBMS. **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Financial Services | Enterprise (> 1000 emp.) **Reviewed Date:** January 22, 2018 **What do you like best about PostgreSQL?** The best feature about PostgreSQL is that it is open source software with easily available user defined types and concurrency control. Also the newly added features of tablespaces in recent versions has made it very much comparable to other popular RDBMS available in the market thus making this a good option for replacing traditional RDBMS at a low cost. **What do you dislike about PostgreSQL?** I dislike the fact that PostgreSQL is not very much user friendly and finding documentation on postgreSQL is bit tedious making it difficult for supporting daily operations of business. **What problems is PostgreSQL solving and how is that benefiting you?** We use postgreSQL for storing data of tables that are historical data and transferring these tables data from online state to offline state. ### 50. Excellent (and FREE!) Enterprise-Level DB. **Rating:** 4.5/5.0 stars **Reviewed by:** Alex S. | Trans. Engineer 2: Survey Party Chief, Government Administration, Small-Business (50 or fewer emp.) **Reviewed Date:** June 01, 2017 **What do you like best about PostgreSQL?** Several items: 1) it's FREE; 2) the ability to program functions and triggers in a variety of languages; 3) it is ACID-compliant which is extremely important to me. **What do you dislike about PostgreSQL?** Although it will run on Windows machines, it does seem (to me) that PostgreSQL is much more at home on a *nix computer. I had some strange access/permissions issues with some Windows directories/files whereas on Linux it was a non-issue. Your mileage may vary. **Recommendations to others considering PostgreSQL:** It is FREE! **What problems is PostgreSQL solving and how is that benefiting you?** The NPO that I am assisting currently uses MS Access and has been doing so since circa 1992, with a very large number of data entry additions which were prone to error. Furthermore, their membership has grown from approximately 300 folks in 1992 to about 4,000 in 2017. This has made their existing setup a nightmare. I volunteered to normalize their data and streamline their data entry procedures with feedback from their current data manager with respect to possible refinements on the data entry forms. Essentially, we are implementing PostgreSQL as a back-end and because of the wide variety of tools available and its versatility, it should provide a large degree of DB future-proofing for the NPO. ## 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=10&qs=pros-and-cons§ion=pricing&secure%5Bexpires_at%5D=2026-08-04+10%3A48%3A44+-0500&secure%5Bsession_id%5D=7f7517e7-5a17-4490-a4f4-cf9af28f1e61&secure%5Btoken%5D=1c5de1d38a117a28fe20e022cbe52568c84bbdcf4f711ab691202278ee9106ef&format=llm_user) ## PostgreSQL Integrations - [Amazon Redshift](https://www.g2.com/products/amazon-redshift/reviews) - [Angular](https://www.g2.com/products/angular-dev-angular/reviews) - [Apache Superset](https://www.g2.com/products/apache-superset/reviews) - [Apache Tomcat](https://www.g2.com/products/apache-tomcat/reviews) - [cPanel](https://www.g2.com/products/cpanel/reviews) - [Databricks](https://www.g2.com/products/databricks/reviews) - [Docker](https://www.g2.com/products/docker-inc-docker/reviews) - [Entity Framework Core](https://www.g2.com/products/entity-framework-core/reviews) - [F5 NGINX](https://www.g2.com/products/f5-nginx/reviews) - [InMotion Hosting](https://www.g2.com/products/inmotion-hosting/reviews) - [Jenkins](https://www.g2.com/products/jenkins/reviews) - [Laravel](https://www.g2.com/products/laravel/reviews) - [Microsoft Power BI](https://www.g2.com/products/microsoft-microsoft-power-bi/reviews) - [n8n](https://www.g2.com/products/n8n/reviews) - [Next.js](https://www.g2.com/products/next-js/reviews) - [Node.js](https://www.g2.com/products/node-js/reviews) - [Omnis Studio](https://www.g2.com/products/omnis-studio/reviews) - [pandas python](https://www.g2.com/products/pandas-python/reviews) - [Pentaho Data Integration](https://www.g2.com/products/pentaho-data-integration/reviews) - [Prisma](https://www.g2.com/products/prisma-prisma/reviews) - [Python](https://www.g2.com/products/python/reviews) - [QGIS](https://www.g2.com/products/qgis/reviews) - [React Native](https://www.g2.com/products/react-native/reviews) - [Redis Software](https://www.g2.com/products/redis-software/reviews) - [Ruby on Rails](https://www.g2.com/products/ruby-on-rails/reviews) - [Tableau](https://www.g2.com/products/tableau/reviews) - [Visual Studio Code](https://www.g2.com/products/visual-studio-code/reviews) ## PostgreSQL Features **Management ** - Data Schema - Query Language - ACID - Complaint - Data Replication **Support ** - Text Search - Data Types - Languages - Operating Systems **Security** - Database Locking - Access Control - Encryption - Authentication **Performance ** - Disaster Recovery - Data Concurrency - Workload Management - Advanced Indexing - Query Optimizer **Database Features** - Storage - Availability - Stability - Scalability - Security - Data Manipulation - Query Language ## Top PostgreSQL Alternatives - [Microsoft SQL Server](https://www.g2.com/products/microsoft-sql-server/reviews) - 4.4/5.0 (2,127 reviews) - [MySQL](https://www.g2.com/products/mysql/reviews) - 4.4/5.0 (1,582 reviews) - [Oracle Database](https://www.g2.com/products/oracle-database/reviews) - 4.3/5.0 (932 reviews)