# PostgreSQL Reviews **Vendor:** PostgreSQL **Category:** [Relational Databases](https://www.g2.com/categories/relational-databases) **Average Rating:** 4.4/5.0 **Total Reviews:** 677 ## About PostgreSQL PostgreSQL is a powerful, open-source object-relational database system renowned for its reliability, extensibility, and adherence to SQL standards. Originating from the POSTGRES project at the University of California at Berkeley in 1986, it has evolved over nearly four decades into a robust platform capable of handling complex data workloads across various operating systems. PostgreSQL's architecture emphasizes data integrity and scalability, making it a preferred choice for developers and organizations worldwide. Key Features and Functionality: - Comprehensive Data Types: Supports a wide range of data types, including primitives (Integer, Numeric, String, Boolean), structured (Date/Time, Array, Range), document (JSON/JSONB, XML), and geometric types. - Advanced Data Integrity: Ensures data accuracy through features like UNIQUE constraints, primary and foreign keys, exclusion constraints, and various locking mechanisms. - High Performance and Concurrency: Utilizes advanced indexing methods (B-tree, GiST, GIN, BRIN), a sophisticated query planner, multi-version concurrency control (MVCC), parallel query execution, and table partitioning to optimize performance. - Reliability and Disaster Recovery: Offers write-ahead logging (WAL), various replication methods (asynchronous, synchronous, logical), point-in-time recovery (PITR), and active standbys to ensure data durability and availability. - Robust Security Measures: Provides multiple authentication methods (GSSAPI, SSPI, LDAP, SCRAM-SHA-256, Certificate, OAuth 2.0), a comprehensive access-control system, and supports multi-factor authentication. - Extensibility: Allows the creation of custom data types, functions, and operators. Supports procedural languages like PL/pgSQL, Perl, Python, and Tcl, with additional languages available through extensions. Primary Value and User Solutions: PostgreSQL addresses the needs of developers and organizations by offering a highly extensible and standards-compliant database system that ensures data integrity, scalability, and robust performance. Its open-source nature allows for continuous innovation and adaptability, enabling users to tailor the database to their specific requirements. Whether managing small applications or large-scale enterprise systems, PostgreSQL provides a reliable foundation for storing and processing data efficiently. ## PostgreSQL Pros & Cons **What users like:** - Users appreciate the **robust reliability and extensive feature set** of PostgreSQL, making it an excellent choice for diverse applications. (16 reviews) - Users find **PostgreSQL easy to use** , offering straightforward setup and seamless integration with various platforms. (13 reviews) - Users value the **open-source nature** of PostgreSQL, enabling cost-effective use with impressive power and flexibility. (10 reviews) - Users commend PostgreSQL for its **unwavering reliability** , ensuring data integrity and performance in production environments. (10 reviews) - Users value PostgreSQL's **scalability** , allowing seamless adjustments from small applications to large enterprise systems effortlessly. (10 reviews) - Users value the **flexibility** of PostgreSQL, appreciating its extensibility and customization options for diverse projects. (8 reviews) - Data Analytics (6 reviews) - Users find **easy integrations** with PostgreSQL, effortlessly implementing it across various systems and programming languages. (6 reviews) - Performance (6 reviews) - Query Speed (5 reviews) **What users dislike:** - Users find PostgreSQL's **beginner unfriendliness** daunting due to its steep learning curve and complex configurations. (7 reviews) - Users find the **complexity of SQL syntax** in PostgreSQL challenging compared to simpler alternatives like MySQL. (6 reviews) - Users find the **learning curve steep** , particularly for beginners struggling with complex configurations and advanced features. (5 reviews) - Users face **slow performance** in PostgreSQL, especially with large databases and complex queries, impacting overall efficiency. (5 reviews) - Users find the **complex configuration** of PostgreSQL challenging, especially 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. 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. ### 2. 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. ### 3. 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. ### 4. 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 ### 5. 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. ### 6. 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. ### 7. 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 ### 8. 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. ### 9. 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. ### 10. 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 ### 11. 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. ### 12. 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. ### 13. 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 ### 14. 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. ### 15. 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. ### 16. 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. ### 17. 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 ### 18. 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. ### 19. 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. ### 20. 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. ### 21. 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 ### 22. 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. ### 23. 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. ### 24. 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. ### 25. 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 ### 26. 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 ### 27. 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. ### 28. 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. ### 29. 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 ### 30. 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. ### 31. 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) ### 32. 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. ### 33. 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 ### 34. 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 ### 35. 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 ### 36. 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. ### 37. 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 ### 38. 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 ### 39. 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 ### 40. 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 ### 41. 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. ### 42. 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. ### 43. 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. ### 44. Great open source database **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** April 22, 2018 **What do you like best about PostgreSQL?** Extremely reliable, allows large amounts of data to be stored and accessed. Also very good documentation, great AWS RDS support. **What do you dislike about PostgreSQL?** Performance management tools are lacking. The database engine is quite opaque when performance issues occur. It is quite hard to diagnose issues like 100% CPU or why some SQL plan is selected rather than some seemingly faster ones. **What problems is PostgreSQL solving and how is that benefiting you?** Relational database storing our company's metadata. ### 45. Robust and Versatile **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Consumer Electronics | Small-Business (50 or fewer emp.) **Reviewed Date:** April 19, 2018 **What do you like best about PostgreSQL?** Very accurate system. It works more than well in most scenarios. **What do you dislike about PostgreSQL?** The installation process is not the most straightforward ever. **What problems is PostgreSQL solving and how is that benefiting you?** Optimization is a great quality of Postgres. ### 46. Good for medium application **Rating:** 2.5/5.0 stars **Reviewed by:** Verified User in Health, Wellness and Fitness | Enterprise (> 1000 emp.) **Reviewed Date:** July 09, 2018 **What do you like best about PostgreSQL?** Open source and free to use is one of the thing **What do you dislike about PostgreSQL?** No good UI and ancillary tools is available in the postgres world **What problems is PostgreSQL solving and how is that benefiting you?** Applications ### 47. Regular SQL with some nifty documentation **Rating:** 4.0/5.0 stars **Reviewed by:** Dustin F. | Analyst, Insurance Analytics - Marketing and Fraud, Information Technology and Services, Enterprise (> 1000 emp.) **Reviewed Date:** January 30, 2018 **What do you like best about PostgreSQL?** Whenever I had any questions, the well organized documentation allowed me to find answers quickly. **What do you dislike about PostgreSQL?** With so many versions of SQL, it is unavoidable to have some syntax differences. Not bab, but always takes some getting used to when switching. **Recommendations to others considering PostgreSQL:** Try it out! It’s easy to get started. **What problems is PostgreSQL solving and how is that benefiting you?** Storing and querying 100M+ row datasets. I work for a national financial company, our datasets are enormous. ### 48. Great opensource relational database **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.) **Reviewed Date:** October 25, 2017 **What do you like best about PostgreSQL?** As of yet, I haven't had any issues with Postgresql. I honestly don't think I've utilized it to its full potential. Some of the features that I've found very helpful are its upsert, or insert on conflict feature as well as the ability to have multiple schemas in order to support a multi tenant data model without having to use multiple databases. It is also quite easy to backup and restore, as well as create followers for high read capacity as well as automatic fallover. Also, we use Ruby on Rails coupled with Heroku for deployment, and Heroku has a great managed PostgreSQL service that makes utilizing all of its features really easy and painless. **What do you dislike about PostgreSQL?** I do wish there was a free tool similar to SQLPro for Postgresql on Mac. There are some paid tools. But I'm fairly cheap. The default management application PGAdmin is very featureful, but the UX isn't amazing, particularly for simple things. **Recommendations to others considering PostgreSQL:** It works really well for us using Ruby on Rails and deploying to Heroku utilized Heroku Postgres. **What problems is PostgreSQL solving and how is that benefiting you?** We use PostgreSQL for almost all our relational database needs, typically for backend data storage for web and mobile applications. It has been fantastic and works great coupled with Ruby on Rails applications. ### 49. An alternative to traditional RDBM **Rating:** 3.0/5.0 stars **Reviewed by:** Juan Carlos G. | Software Engineer, Information Technology and Services, Mid-Market (51-1000 emp.) **Reviewed Date:** December 21, 2017 **What do you like best about PostgreSQL?** It has a great performance, specially to handle big volumes of data. **What do you dislike about PostgreSQL?** Its query language is not the standard SQL, so a learning curve is necessary. Fewer tools that interact with it, and also less documentation is a concern. **Recommendations to others considering PostgreSQL:** Don't be afraid of the learning curve, it's a good first step to later enter the world of NoSQL databases. **What problems is PostgreSQL solving and how is that benefiting you?** It was used as a demonstration of non traditional databases, it handled everything we throw at it. It has better support for json types. ### 50. Great open source DB **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** December 12, 2017 **What do you like best about PostgreSQL?** I like that the DB is free to use and distribute, however there are tons of resources available for the product. **What do you dislike about PostgreSQL?** The only thing i can think of that i currently dislike is running a query on several databases at one time. something that is actually much simpler in SQL server. **Recommendations to others considering PostgreSQL:** The product is great and there are tons of online and consultant groups to assist with setup and implementation. **What problems is PostgreSQL solving and how is that benefiting you?** We are using PostreSQL for our applications and as a database for external data mining and analyzing. ## 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§ion=pricing&secure%5Bexpires_at%5D=2026-05-18+03%3A54%3A57+-0500&secure%5Bsession_id%5D=aa0d6810-6679-48a8-aac1-1d8c65b3610a&secure%5Btoken%5D=a8ae100bb0af4d439f09b87912e577565f3aa059e92271bc3713530a6e023068&format=llm_user) ## PostgreSQL Integrations - [Amazon Redshift](https://www.g2.com/products/amazon-redshift/reviews) - [Angular](https://www.g2.com/products/angular-dev-angular/reviews) - [Apache Superset](https://www.g2.com/products/apache-superset/reviews) - [Apache Tomcat](https://www.g2.com/products/apache-tomcat/reviews) - [Azure Database for PostgreSQL](https://www.g2.com/products/azure-database-for-postgresql/reviews) - [cPanel](https://www.g2.com/products/cpanel/reviews) - [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) - [Laravel](https://www.g2.com/products/laravel/reviews) - [Microsoft Power BI](https://www.g2.com/products/microsoft-microsoft-power-bi/reviews) - [n8n](https://www.g2.com/products/n8n/reviews) - [Next.js](https://www.g2.com/products/next-js/reviews) - [Node.js](https://www.g2.com/products/node-js/reviews) - [Omnis Studio](https://www.g2.com/products/omnis-studio/reviews) - [pandas python](https://www.g2.com/products/pandas-python/reviews) - [Pentaho Data Integration](https://www.g2.com/products/pentaho-data-integration/reviews) - [PostgreSQL](https://www.g2.com/products/postgresql/reviews) - [PostgreSQL on Amazon Linux 2](https://www.g2.com/products/postgresql-on-amazon-linux-2/reviews) - [PostgreSQL With Redhat 8](https://www.g2.com/products/postgresql-with-redhat-8/reviews) - [Prisma](https://www.g2.com/products/prisma-prisma/reviews) - [Python](https://www.g2.com/products/python/reviews) - [QGIS](https://www.g2.com/products/qgis/reviews) - [React Native](https://www.g2.com/products/react-native/reviews) - [Redis Software](https://www.g2.com/products/redis-software/reviews) - [Ruby on Rails](https://www.g2.com/products/ruby-on-rails/reviews) - [Tableau](https://www.g2.com/products/tableau/reviews) ## 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,112 reviews) - [MySQL](https://www.g2.com/products/mysql/reviews) - 4.4/5.0 (1,575 reviews) - [Oracle Database](https://www.g2.com/products/oracle-database/reviews) - 4.3/5.0 (927 reviews)