--- 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-17' 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 **AI Enabled:** This product embeds AI to enhance or extend its core functionality. ## 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 Pros and Cons are compiled from review feedback and grouped into themes to provide an easy-to-understand summary of user reviews. **What users like:** - Users highlight the **reliability and extensive feature set** of PostgreSQL, appreciating its robust data integrity and ease of use. (16 reviews) - Users find PostgreSQL to be **easy to use** , with straightforward setup and excellent integration across platforms. (13 reviews) - Users value PostgreSQL for its **open-source flexibility** and reliability, making it an ideal choice for diverse projects. (10 reviews) - Users highlight the **reliability and data integrity** of PostgreSQL, consistently trusting it for their production environments. (10 reviews) - Users value the **scalability** of PostgreSQL, finding it easy to adapt from small applications to large systems. (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** challenging, facing a steep learning curve and complex configurations. (7 reviews) - Users find the **complexity** of PostgreSQL's SQL syntax and management tasks to be challenging compared to simpler databases. (6 reviews) - Users find the **learning curve steep** , with complexities in configuration and concepts challenging newcomers to PostgreSQL. (5 reviews) - Users face **slow performance** with large databases and complex queries, requiring careful indexing for better efficiency. (5 reviews) - Users find the **complex configuration** of PostgreSQL challenging, particularly for performance tuning and replication management. (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. Easily scalable database solution **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) This reviewer's identity has been verified by our review moderation team. They have asked not to show their name, job title, or picture. **Validated Reviewer:** Validated through LinkedIn **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **Reviewed Date:** November 08, 2021 **What do you like best about PostgreSQL?** The best thing is its is open source, it supports the B+ tree, GIN (Generalized Inverted Index) and GiST (Generalized Search Tree).The project is supported by a number of corporations and people. **What do you dislike about PostgreSQL?** Changes for performance enhancement need more work than in MySQL since PostgreSQL primarily has software compatibility goals. Many open source applications support MySQL, but not PostgreSQL. **What problems is PostgreSQL solving and how is that benefiting you?** I'm using PostgresSQL for a heavy read/write application and a big data analytics project. In addition, I am working on projects for small-size projects and general management initiatives for which I use PostgreSQL too ### 2. PostgreSQL - Advanced open source database **Rating:** 3.5/5.0 stars **Reviewed by:** Animesh K. | Technical Test Lead (ABC Financials), Enterprise (> 1000 emp.) **Validated Reviewer:** Validated through LinkedIn **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **Reviewed Date:** April 20, 2021 **What do you like best about PostgreSQL?** Easy Installation and Configuration, supports multi-platforms like Windows, macOS, Linux, use existing applications. Highly reliable open source RDBMS. Lots of features compared to its competitors. **What do you dislike about PostgreSQL?** Lacks schema versioning, Parallel data query, Feels lacking in performance compared to competitors especially in writing to the database. Postgre upgrade from 9 to 10 was not that great, there was a lot of downtime. Lacks in-memory modes. Less documentation which may be impediment to new users. **Recommendations to others considering PostgreSQL:** PostgreSQL is best suited for small and medium development projects. While there is a bit of a learning curve compared to MySQL and SQL server, which may be an issue for the beginner but if you are an experienced software developer or database admin, it is almost perfect for you. It provides broad feature sets, which are handy for incremental development. The best part is it's free, so it is a cheap and almost equal alternative to SQL Server since you need to pay a lot for licensing costs of SQL Server for businesses and enterprises. **What problems is PostgreSQL solving and how is that benefiting you?** I work as a consultant and we work on providing technical solution to our clients. We suggested PostgreSQL to one small company we were working with. I believe PostgreSQL is best suited for smaller and medium sized development project. Since this is open source, it has all the features which are needed for smaller and medium development project. This is also easy to administrate. Postgres has an incredibly flexible and simple-to-use user/role management system. Postgres usage is increasing in the industry and I believe its market share has increaed to 6% lately. It is really easy to integrate PostgreSQL into our stack. Because of high adoption rate, hiring a developer to implement or service Postgres is easy. Most of the major database libraries of common web frameworks are out there like Rails - ActiveRecord, Spring-Hibernate, Play Scala-Slick. These libraries have out of the box Postgres support, thus no extra configuration is needed for our web applications to read or write to PostgresSQL. ### 3. Good Database to integrate with Go **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.) This reviewer's identity has been verified by our review moderation team. They have asked not to show their name, job title, or picture. **Validated Reviewer:** Validated through LinkedIn **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **Reviewed Date:** February 04, 2022 At G2, we prefer fresh reviews and we like to follow up with reviewers. They may not have updated their review text, but have updated their review. **What do you like best about PostgreSQL?** - Querying time is considerably faster - Free and open-source database - Easy to install and configure **What do you dislike about PostgreSQL?** - Consumes somewhat higher CPU usage so that efficiency is a bit low **What problems is PostgreSQL solving and how is that benefiting you?** - Using the database with a Go API - Database used for Enterprise application ### 4. How postgreSQL helps me in my daily work **Rating:** 4.5/5.0 stars **Reviewed by:** Dinesh P. | SDE, Small-Business (50 or fewer emp.) **Validated Reviewer:** Validated through LinkedIn **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **Reviewed Date:** October 04, 2021 **What do you like best about PostgreSQL?** only postgresql provides enterprise-class performance and functions among current open source dbms with no end of development possibilities. also, postgresql users can directly participate in the community and post and share inconveniences and bugs. **What do you dislike about PostgreSQL?** The UI is not that user friendly. I could improve much better way. **What problems is PostgreSQL solving and how is that benefiting you?** only postgresql provides enterprise-class performance and functions among current open source dbms with no end of development possibilities ### 5. Excellent for complex data queries **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Computer & Network Security | Small-Business (50 or fewer emp.) This reviewer's identity has been verified by our review moderation team. They have asked not to show their name, job title, or picture. **Current User:** The reviewer uploaded a screenshot or submitted the review in-app verifying them as current user. **Validated Reviewer:** Validated through a business email account **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **Reviewed Date:** November 01, 2021 **What do you like best about PostgreSQL?** Highly compliant with SQL standards, able to handle large complex queries. Supported by the majority of platforms such as Amazon Redshift and DynamoDB. Great for application data processing. **What do you dislike about PostgreSQL?** Slow process speed, not a good fit for real-time data processing **What problems is PostgreSQL solving and how is that benefiting you?** Largely complex data queries, ROR used PostgreSQL as a backend database. ### 6. A friendly Database **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Insurance | Enterprise (> 1000 emp.) This reviewer's identity has been verified by our review moderation team. They have asked not to show their name, job title, or picture. **Validated Reviewer:** Validated through LinkedIn **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **Reviewed Date:** January 04, 2022 **What do you like best about PostgreSQL?** Is a good database for non-critical applications that required less level of effort for administration and support. **What do you dislike about PostgreSQL?** At the moment i do not find any dislike whatsoever **What problems is PostgreSQL solving and how is that benefiting you?** Some applications were using SQL Express and with his limitation, on some occasions the application start crashing because the database was full, performance issues, etc. ### 7. PostgreSQL Review **Rating:** 4.0/5.0 stars **Reviewed by:** Elizabeth J. | Software Developer, Information Technology and Services, Mid-Market (51-1000 emp.) **Validated Reviewer:** Validated through LinkedIn **Source: Organic:** Organic review. This review was written entirely without invitation or incentive from G2, a seller, or an affiliate. **Reviewed Date:** December 29, 2020 ### 8. One of finest modern days database **Rating:** 4.5/5.0 stars **Reviewed by:** Devansh A. | Associate - Projects , Enterprise (> 1000 emp.) **Validated Reviewer:** Validated through LinkedIn **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **Reviewed Date:** October 19, 2021 **What do you like best about PostgreSQL?** - Can use alongside timescale as a Timescale DB - Easy to understand and work on - With PGAdmin you can easily and smoothly manage your database **What do you dislike about PostgreSQL?** - Complexity of terms quite different from the other databases **What problems is PostgreSQL solving and how is that benefiting you?** - Managing Database - High Availability with Patroni ETCD ### 9. Data base **Rating:** 4.5/5.0 stars **Reviewed by:** Himanshu A. | Software Development Engineer in Test, Small-Business (50 or fewer emp.) **Validated Reviewer:** Validated through LinkedIn **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **Reviewed Date:** June 19, 2021 **What do you like best about PostgreSQL?** Postgre SQL is easy to use. If you know the SQL it's super easy to learn the Postgre SQL. It's also a fast way to store the data and fetching from the database. we can use the Postgre SQL in any project./ It's very popular so if you learn it, it's will definitely benefit your professional life. **What do you dislike about PostgreSQL?** There is nothing to dislike for postpre Sql just if required some time to learn it. **What problems is PostgreSQL solving and how is that benefiting you?** you can use it in any of your projects for storing, fetching data from the database. It gives you easy access to data. I myself use this in many of the projects. ### 10. Quality open source DB **Rating:** 4.5/5.0 stars **Reviewed by:** Aniruddha B. | Module Lead, Mid-Market (51-1000 emp.) **Validated Reviewer:** Validated through LinkedIn **Source: Organic:** Organic review. This review was written entirely without invitation or incentive from G2, a seller, or an affiliate. **Reviewed Date:** September 30, 2021 **What do you like best about PostgreSQL?** * Easy to read the documentation * Major support for all languages * Partitioning functionality **What do you dislike about PostgreSQL?** * Configuration is a bit overwhelming and needs reading of documentation to get things right. **What problems is PostgreSQL solving and how is that benefiting you?** * Using it with REST API and microservice architecture solutions which are not too read heavy ### 11. Best object relational Database **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Small-Business (50 or fewer emp.) This reviewer's identity has been verified by our review moderation team. They have asked not to show their name, job title, or picture. **Current User:** The reviewer uploaded a screenshot or submitted the review in-app verifying them as current user. **Validated Reviewer:** Validated through LinkedIn **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **Reviewed Date:** August 21, 2021 **What do you like best about PostgreSQL?** As PostgreSQL is an object-relational database, it provides features like overloading and inheritance, which can be very useful for developing some applications. **What do you dislike about PostgreSQL?** The downside of PostgreSQL is that not every open source app support postgresql. **What problems is PostgreSQL solving and how is that benefiting you?** I am developing an application using RESTful APIs and that requires Firebase Authentication and the database PostgreSQL. Its highly concurrent and ACID properties are the benefits. ### 12. World Class and Free DBMS Engine **Rating:** 5.0/5.0 stars **Reviewed by:** Jorge M. | Co-Founder and Software Architect, Small-Business (50 or fewer emp.) **Validated Reviewer:** Validated through LinkedIn **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **Reviewed Date:** March 25, 2021 **What do you like best about PostgreSQL?** It is a World Class database management system that you can get for free. Besides, it is possible to get paid versions that include support. **What do you dislike about PostgreSQL?** Until now, I have not found anything that I dislike from this DBMS. **Recommendations to others considering PostgreSQL:** Anyone interested in a DBMS should consider trying PostgreSQL. It is world-class and free. I ask for support using email list subscription and the community response is great and timely. You can optionally find paid options that include special support and configurations with partners like enterprisedb.com. Until now, the free choice has been more than enough for me. **What problems is PostgreSQL solving and how is that benefiting you?** I build information systems for the WWW and I use a relational DB concept to store data. Among the types of systems I have developed are: News, Inventory, Documents Digitalization (like invoices and other). ### 13. A wonderful database to work in. **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) This reviewer's identity has been verified by our review moderation team. They have asked not to show their name, job title, or picture. **Validated Reviewer:** Validated through a business email account **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **Reviewed Date:** October 05, 2021 **What do you like best about PostgreSQL?** Postgres has excellent set a features that are unique to it. It is fast and functional and makes writing queries easy. **What do you dislike about PostgreSQL?** Some of the Postgres specific syntax can be hard to grasp at first. It is very different from MySQL. **What problems is PostgreSQL solving and how is that benefiting you?** We use it in many different areas of our organization and personally on freelance projects. It is just fast and helps me get work done. ### 14. Pretty awesome and well covered in terms of daily challenges **Rating:** 4.5/5.0 stars **Reviewed by:** Swagato M. | SDE III, Enterprise (> 1000 emp.) **Validated Reviewer:** Validated through LinkedIn **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **Reviewed Date:** May 06, 2021 **What do you like best about PostgreSQL?** The best feature I see is storing (also searching, etc.) data as advanced DS(s) such as JSON, Lists, etc. **What do you dislike about PostgreSQL?** I didn't have any such challenge exclusively for PostgreSQL. Hence the challenges (if any) would be similar to the regular SQL DB(s). **Recommendations to others considering PostgreSQL:** In case you're searching for a DB with advanced use-cases, PostgreSQL has it covered mostly. **What problems is PostgreSQL solving and how is that benefiting you?** We use PostgreSQL to store the user data in multiple forms (JSON, Lists, etc.). Benefits: The ability to store the information received from request directly in the same form instead of extra processing like other DB(s) is the best advantage. ### 15. Quite easy to use and user friendly **Rating:** 4.5/5.0 stars **Reviewed by:** Vishal A. | Head of Operations, Small-Business (50 or fewer emp.) **Validated Reviewer:** Validated through LinkedIn **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **Reviewed Date:** May 30, 2021 **What do you like best about PostgreSQL?** easy and smooth workflow, handy and amateur level tool **What do you dislike about PostgreSQL?** certain restrictions towards handling of data **Recommendations to others considering PostgreSQL:** Instead of other complex query language platforms like Microsoft SQL Server or BigQuery, I would recommend PostgreSQL more. **What problems is PostgreSQL solving and how is that benefiting you?** I usually use it for data analytics projects which is why valuable to retrieve, update and analyze data, and problems may vary according to the client requirement. However, the best benefit to use PostgreSQL is that you could use easy layman words as crucial commands which are easy to remember. ### 16. Best Database System **Rating:** 5.0/5.0 stars **Reviewed by:** Archit P. | Senior Product Analyst, Small-Business (50 or fewer emp.) **Validated Reviewer:** Validated through LinkedIn **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **Reviewed Date:** August 19, 2021 **What do you like best about PostgreSQL?** It allows me to store large data in a sophisticated manner. **What do you dislike about PostgreSQL?** The installation can be homogenous across the operating system **What problems is PostgreSQL solving and how is that benefiting you?** I has helped me maintain data extraction scripts which has reduced manual data extraction time by 30% ### 17. Easy to use - Nice and provided feeling of organization **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Airlines/Aviation | Enterprise (> 1000 emp.) This reviewer's identity has been verified by our review moderation team. They have asked not to show their name, job title, or picture. **Validated Reviewer:** Validated through a business email account **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **Reviewed Date:** October 11, 2021 **What do you like best about PostgreSQL?** Felt organized, easy to understand and to use. Could keep several databases within eyes reach **What do you dislike about PostgreSQL?** Occasional technical glitches, brief learning curve before becoming fluent with their system **What problems is PostgreSQL solving and how is that benefiting you?** Being able to use SQL to find business solutions and automatically store useful data in a database ### 18. One of the evergreen databases **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Enterprise (> 1000 emp.) This reviewer's identity has been verified by our review moderation team. They have asked not to show their name, job title, or picture. **Validated Reviewer:** Validated through LinkedIn **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **Reviewed Date:** November 18, 2021 **What do you like best about PostgreSQL?** Posgress is very light and flexible compared to mysql **What do you dislike about PostgreSQL?** Do not have much documentation to start with **What problems is PostgreSQL solving and how is that benefiting you?** Started to integrate our backend system with postgres ### 19. PostgreSQL Review **Rating:** 3.5/5.0 stars **Reviewed by:** Atul F. | sql, Enterprise (> 1000 emp.) **Validated Reviewer:** Validated through a business email account **Source: Organic:** Organic review. This review was written entirely without invitation or incentive from G2, a seller, or an affiliate. **Reviewed Date:** December 28, 2020 ### 20. Great for Multithreaded applications **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Retail | Enterprise (> 1000 emp.) This reviewer's identity has been verified by our review moderation team. They have asked not to show their name, job title, or picture. **Validated Reviewer:** Validated through LinkedIn **Source: Organic:** Organic review. This review was written entirely without invitation or incentive from G2, a seller, or an affiliate. **Reviewed Date:** June 20, 2021 **What do you like best about PostgreSQL?** The great performance on top of the traditional DB ability to have a json data type really helps keep within the realm of SQL while creating a solid backend for microservices. **What do you dislike about PostgreSQL?** It has a little bit of learning curve but not necessarily anything bad I would say about postgresql **Recommendations to others considering PostgreSQL:** If you are not ready to go towards nosql but want the flexibility of it while maintaining traditional SQL, then postgresql is the way to go! **What problems is PostgreSQL solving and how is that benefiting you?** Using as backend for application specific data, with a lot of the data being stored as json in order to interact with apis ### 21. Powerfull DB **Rating:** 4.5/5.0 stars **Reviewed by:** Alexandr V. | A, Enterprise (> 1000 emp.) **Validated Reviewer:** Validated through a business email account **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **Reviewed Date:** August 19, 2021 **What do you like best about PostgreSQL?** A lot of features, smart backup, PG cluster ability, production ready DB **What do you dislike about PostgreSQL?** Troubleshooting something hard to do, poor out of the box documentation **What problems is PostgreSQL solving and how is that benefiting you?** SQL database help to org data ### 22. Best Open Source Relational Database **Rating:** 4.5/5.0 stars **Reviewed by:** Ajay S. | Senior Member of Technical Staff, Enterprise (> 1000 emp.) **Validated Reviewer:** Validated through LinkedIn **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **Reviewed Date:** November 07, 2020 **What do you like best about PostgreSQL?** 1) It can handle large amount of data securely without much difficulty. 2) It is secure. 3) It handles complex queries smoothly. 4) Creating and running Stored Procedures are easy and is handled without any issue. 5) Good to store large amount of structured data. 6) Provides some inbuilt data types to make working with data easier. 7) Many cloud platform like aws and azure supports PostgreSql. 8) Open source and free. **What do you dislike about PostgreSQL?** 1) Sometimes while creating connection it takes time. 2) Somewhat slow when you perform large data operations like updating and inserting. 3) Not very easy for beginners. **Recommendations to others considering PostgreSQL:** If you are looking for free relational Database then this is it. Only thing you need to think about is that it is somewhat slower during large data set operation as compared to other database like MySql. **What problems is PostgreSQL solving and how is that benefiting you?** Used it for storing and performing operations on large amount of structured data. As it is open source and free it comes with no cost and perform its job perfectly. Only issue is while performing operation on large set at a time it is somewhat slow. ### 23. Best relational database system choice for new app developers **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Financial Services | Enterprise (> 1000 emp.) This reviewer's identity has been verified by our review moderation team. They have asked not to show their name, job title, or picture. **Validated Reviewer:** Validated through LinkedIn **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **Reviewed Date:** May 04, 2021 **What do you like best about PostgreSQL?** The performance of the database is topnotch relating to transactions, concurrency and schema controls **What do you dislike about PostgreSQL?** It is diffcult to resolve issues/errors as a lot of documentation is not available around this **Recommendations to others considering PostgreSQL:** There are a lot of tools for coverting other SQL scripts to prostgreSQL scripts. So if you are looking to switch it's not that diffcult. Also it will significantly reduce your cost **What problems is PostgreSQL solving and how is that benefiting you?** We tried to find a low cost alternative db system for a client. So we moved from Oracle to prostgreSQL. This brought the cost down substantially ### 24. Open Source Transactional database to manage GB's of Data for Free. **Rating:** 5.0/5.0 stars **Reviewed by:** Syed M. | Associate Consultant - (Data Engineering), Mid-Market (51-1000 emp.) **Current User:** The reviewer uploaded a screenshot or submitted the review in-app verifying them as current user. **Validated Reviewer:** Validated through LinkedIn **Source: Organic:** Organic review. This review was written entirely without invitation or incentive from G2, a seller, or an affiliate. **Reviewed Date:** December 09, 2020 **What do you like best about PostgreSQL?** Free , Easy to connect over network has many features and Functions and Fast compared to MySql , Support from Large Community . Can have number of parallel users . **What do you dislike about PostgreSQL?** We need to have aliases for sub-queries which is an overhead sometimes when migrating from different database . **What problems is PostgreSQL solving and how is that benefiting you?** I am Using it for practice and to store my Personal Projects in postgresql . Also worked with Aurora (postgresql) for some project . ### 25. PostgreSQL **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Education Management | Enterprise (> 1000 emp.) This reviewer's identity has been verified by our review moderation team. They have asked not to show their name, job title, or picture. **Validated Reviewer:** Validated through LinkedIn **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **Reviewed Date:** March 30, 2021 **What do you like best about PostgreSQL?** The cost point on PostgreSQL is significantly better than the big guns like Oracle. **What do you dislike about PostgreSQL?** I don't think this is as redundant a solution or as high capacity as other databases. **What problems is PostgreSQL solving and how is that benefiting you?** I wouldn't say that we're solving problems with it, but it met our need for a database at reduced cost. ### 26. Advance relational database for the low price. **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) This reviewer's identity has been verified by our review moderation team. They have asked not to show their name, job title, or picture. **Current User:** The reviewer uploaded a screenshot or submitted the review in-app verifying them as current user. **Validated Reviewer:** Validated through Google using a business email account **Source: Organic:** Organic review. This review was written entirely without invitation or incentive from G2, a seller, or an affiliate. **Reviewed Date:** November 05, 2020 At G2, we prefer fresh reviews and we like to follow up with reviewers. They may not have updated their review text, but have updated their review. **What do you like best about PostgreSQL?** It's great enterprise sql quality database. Postgres better implements a lot of things in an open source as compared to Oracle. **What do you dislike about PostgreSQL?** Installation is confusing as compared to MySql. Has a lot of prerequisites. **Recommendations to others considering PostgreSQL:** None **What problems is PostgreSQL solving and how is that benefiting you?** I use Postgresql everyday especially for data analysis. It's easily gets compatible with Microsoft Visual Studio. It also three temporary tables to store large queries. You can also temporary tables into locan and global. Postgres saves history of previous queries which is pretty useful. ### 27. Best Open Source RDBMS for Beginners **Rating:** 4.5/5.0 stars **Reviewed by:** Noah S. | Technical Consultant, Enterprise (> 1000 emp.) **Validated Reviewer:** Validated through LinkedIn **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **Reviewed Date:** November 01, 2020 **What do you like best about PostgreSQL?** It's the easiest RDBMS for beginners with relatively simple syntax & very little administration required for basic apps. **What do you dislike about PostgreSQL?** It is slower than MySQL and other non-RDBMS databases. **What problems is PostgreSQL solving and how is that benefiting you?** We use PostgreSQL as our database of choice for prototyping new applications. We also have customers using it on massive scale. We benefit from it's open source code & flexibility to work in almost any situation, large or small. ### 28. Upgrade from MYSql **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) This reviewer's identity has been verified by our review moderation team. They have asked not to show their name, job title, or picture. **Current User:** The reviewer uploaded a screenshot or submitted the review in-app verifying them as current user. **Validated Reviewer:** Validated through a business email account **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **Reviewed Date:** December 25, 2020 **What do you like best about PostgreSQL?** Ease of use and functionality: being able to schedule tasks, create window functions. **What do you dislike about PostgreSQL?** Finding small syntax differences between mysql and postgresql **What problems is PostgreSQL solving and how is that benefiting you?** Being able to create tasks overnight that will send out the required reporting to each appropriate department. ### 29. Good and I want to experience or solve more problem using it. **Rating:** 4.5/5.0 stars **Reviewed by:** Hendy W. | Senior Associate Consultant **Validated Reviewer:** Validated through LinkedIn **Source: Organic:** Organic review. This review was written entirely without invitation or incentive from G2, a seller, or an affiliate. **Reviewed Date:** December 28, 2020 **What do you like best about PostgreSQL?** Simple interface, and easy for beginner (either for student or associate consultant) **What do you dislike about PostgreSQL?** pip install are a lot, and it required one to do more research. **What problems is PostgreSQL solving and how is that benefiting you?** Data assessment by using pandas and numpy ### 30. Best professional open source RDBMS **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Small-Business (50 or fewer emp.) This reviewer's identity has been verified by our review moderation team. They have asked not to show their name, job title, or picture. **Current User:** The reviewer uploaded a screenshot or submitted the review in-app verifying them as current user. **Validated Reviewer:** Validated through a business email account **Source: Organic:** Organic review. This review was written entirely without invitation or incentive from G2, a seller, or an affiliate. **Reviewed Date:** November 02, 2020 **What do you like best about PostgreSQL?** High SQL standard coverage, feature rich and easy to use and deploy. **What do you dislike about PostgreSQL?** If you need a database server, there are no real downsides. Point in time recovery is some work to set up. **What problems is PostgreSQL solving and how is that benefiting you?** Saving large amounts of structured data can make a huge licensing impact on commercial database licenses, which do not accur when using PostgreSQL. ### 31. Best Database to use in production. **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) This reviewer's identity has been verified by our review moderation team. They have asked not to show their name, job title, or picture. **Validated Reviewer:** Validated through a business email account **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **Reviewed Date:** September 03, 2020 **What do you like best about PostgreSQL?** Postgres provide very amazing fields which other SQL database doesn't have like array field and json field to store data, postgres is very easy to integrate and very much easy to use too. **What do you dislike about PostgreSQL?** Postgres installation with linux mint is bit difficult the documentation provided to install doesn't work properly with linux mint. **Recommendations to others considering PostgreSQL:** Highly recommended for every developer to use postgres as their default database not only in production but kn testing and stage also. **What problems is PostgreSQL solving and how is that benefiting you?** We are using postgres in our production it helps to make our database more clean and faster than any other SQL database. ### 32. postgre **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) This reviewer's identity has been verified by our review moderation team. They have asked not to show their name, job title, or picture. **Validated Reviewer:** Validated through LinkedIn **Incentivized:** The reviewer received either a gift card or a donation made to a charity of their choice in exchange for writing this review. **Source: G2 Gives Campaign:** G2 Gives Campaign. The reviewer received either a gift card or a donation made to a charity of their choice in exchange for writing this review. **Reviewed Date:** November 02, 2020 **What do you like best about PostgreSQL?** easy to excecute the scripts,easy to find the database and tables, proper arrangement of views & tables. **What do you dislike about PostgreSQL?** connecting to server , requires additional host names and details **What problems is PostgreSQL solving and how is that benefiting you?** easy to handle , easy to connect in various application using simple dll's , easy to fetch data and also share the data and store in data tables. ### 33. Great To Manage Multiple Databases **Rating:** 4.0/5.0 stars **Reviewed by:** zahit B. | BI & DWH Consultant, Mid-Market (51-1000 emp.) **Current User:** The reviewer uploaded a screenshot or submitted the review in-app verifying them as current user. **Validated Reviewer:** Validated through a business email account **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **Reviewed Date:** November 18, 2019 **What do you like best about PostgreSQL?** I think PostgreSQL is a good Enterprise Class data management. It has good amount of features like integration, migration, flexible deployment options, has good tool kits for management. We've almost about 10+ databases including master and managing them via PostgreSQL is very easy. One good thing with PostgreSQL is that we can have multiple databases in single server and having different configurations for them. Overall we are most satisfied with PostgreSQL and their services. **What do you dislike about PostgreSQL?** Ability to have multiple databases on single server. Having database users which are permission based Integration between multiple databases. **What problems is PostgreSQL solving and how is that benefiting you?** Max connection timeouts are too frequent. Much frequently we do see problems like queries are in waiting status and goes idle after some time. We had to manually kill those transactions.I can't say the technical support team is very good ### 34. Open Source Database Management **Rating:** 4.5/5.0 stars **Reviewed by:** zahit b. | Freelance BI&DWH Consultant, Small-Business (50 or fewer emp.) **Current User:** The reviewer uploaded a screenshot or submitted the review in-app verifying them as current user. **Validated Reviewer:** Validated through LinkedIn **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **Reviewed Date:** November 12, 2019 At G2, we prefer fresh reviews and we like to follow up with reviewers. They may not have updated their review text, but have updated their review. **What do you like best about PostgreSQL?** PostgreSQL is an open-source database. It is an RDBMS. In our Organization, we are using PostgreSQL-9.4 and planning to upgrade it to 9.5 in future. PostgreSQL Database can be used for highly complex applications. It will reject the unauthorized connections to the database. In addition, The management panel for storage management is very useful. **What do you dislike about PostgreSQL?** Configuring the Database in the local machine was a bit difficult. I don't find any good IDE's to work on it. PgAdmin's also there, I couldn't achieve the maximum speed. Because it's a web-based application **What problems is PostgreSQL solving and how is that benefiting you?** I have mostly used postgres for database management tool, In addition, database migration from sybase to postgres and to test it. I think, It's benefits are very obvious and is once of the best DBMS out there. ### 35. Best scalable and stable RDBMS i ever use **Rating:** 4.0/5.0 stars **Reviewed by:** Andy Larry R. | Informaticien études et développement, Small-Business (50 or fewer emp.) **Current User:** The reviewer uploaded a screenshot or submitted the review in-app verifying them as current user. **Validated Reviewer:** Validated through LinkedIn **Source: Organic:** Organic review. This review was written entirely without invitation or incentive from G2, a seller, or an affiliate. **Reviewed Date:** September 27, 2019 **What do you like best about PostgreSQL?** - A very scalable data management system with powerful tools to exploit data - A strong stability when execute complex request (trigger, ) and long term data archive - A great stability for data storage, no data corrupted, no crash, it can store big data - Open source and free, you can deploy PostgreSQL anywhere and anytime with sevral users as you want - Very best support team with community **What do you dislike about PostgreSQL?** - You must regularly execute autovacuum to insure performance - It 'is a little complicated to implement logshipping master/slave clusterization - Not as speed as Mysql for data selection (SELECT) - Detailed documentation only available in English version **What problems is PostgreSQL solving and how is that benefiting you?** - I use PostgreSQL for projects which need a strong stability in data storage like banking transaction management, employee salary management and others, with PostgreSQL, you insure data availability. - I also use PostgreSQL for business intelligence projects because it support complex SQL request mix with triggers and stored procedure which are powerful tools for making strong data analysis. ### 36. Awesome **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Accounting | Small-Business (50 or fewer emp.) This reviewer's identity has been verified by our review moderation team. They have asked not to show their name, job title, or picture. **Validated Reviewer:** Validated through Google using a business email account **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **Reviewed Date:** October 18, 2020 **What do you like best about PostgreSQL?** I've used Postgres for a number of projects and would highly recommend. **What do you dislike about PostgreSQL?** At this time, nothing comes to mind so far **What problems is PostgreSQL solving and how is that benefiting you?** Using it as a database solution to store user data ### 37. Free Database Manager **Rating:** 4.5/5.0 stars **Reviewed by:** tuba t. | Software Developer, Small-Business (50 or fewer emp.) **Current User:** The reviewer uploaded a screenshot or submitted the review in-app verifying them as current user. **Validated Reviewer:** Validated through LinkedIn **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **Reviewed Date:** November 10, 2019 **What do you like best about PostgreSQL?** PostgreSQL is the best option to make developments with high amounts of data management volume and sentences. This is a database that serves applications perfectly, it is easy to use when it is integrated with tools such as EnterpriseDB and the security provided by Postgres is a very strong value. **What do you dislike about PostgreSQL?** If you use postgres by console and not with any graphical tool such as pgadmin or dbeaver you must have intermediate knowledge, you may notice some slowness in massive insertions but this is related to the good design of the database **What problems is PostgreSQL solving and how is that benefiting you?** It is one of the well known database solution for the applications which needed to support cloud. It is capable to process large amount of data parallel efficiently. ### 38. Great Opensource SQL Database, to rival MS SQL and other pay for play options **Rating:** 5.0/5.0 stars **Reviewed by:** Randall M. | Site Reliability Engineer, Enterprise (> 1000 emp.) **Validated Reviewer:** Validated through LinkedIn **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **Reviewed Date:** July 21, 2020 **What do you like best about PostgreSQL?** This database is extremely tunable and runs very well inside of a container **What do you dislike about PostgreSQL?** pg.conf should be driven by a common markdown language **What problems is PostgreSQL solving and how is that benefiting you?** SQL Database, without paying high licensing fees ### 39. Good database system, worth learning and implementation is easy with PostgresSQL **Rating:** 4.0/5.0 stars **Reviewed by:** Javed A. | Head of Technology, Small-Business (50 or fewer emp.) **Current User:** The reviewer uploaded a screenshot or submitted the review in-app verifying them as current user. **Validated Reviewer:** Validated through a business email account **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **Reviewed Date:** September 24, 2019 **What do you like best about PostgreSQL?** Features in Postgres are equivalent to Oracle RDBMS, although some of the features like JSON support were not present till Oracle 11g which is a part of PostgresSQL. Documentation is extensive and easily available. **What do you dislike about PostgreSQL?** PGAdmin can be made more user-friendly like search for specific keyword for existing database objects like table or function name which is not available. **Recommendations to others considering PostgreSQL:** PostgresSQL is a complete database which can be used to build an application for any mid-size organization. Postgres documentation is easily available and one of the best databases I have ever worked. **What problems is PostgreSQL solving and how is that benefiting you?** After working on Oracle for almost a decade, moving to Postgres SQL was very easy and we are using Postgres database within the organisation to develop an application database and interface is built on Microsoft technologies. ### 40. Thoughts on postgres **Rating:** 4.5/5.0 stars **Reviewed by:** Carly A. | Scientific Researcher, Research, Mid-Market (51-1000 emp.) **Validated Reviewer:** Validated through LinkedIn **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **Reviewed Date:** October 21, 2019 **What do you like best about PostgreSQL?** We prefer Postgres over any other database management system because it can be run on any platform and is very easy to program. It follows a good general sql format and has great JSON support. This is something we find very helpful because we needed a borderline NoSql like environment too. It is also open sourced, so it is easily accessible. **What do you dislike about PostgreSQL?** My biggest issue with postgres is that it consumes a ridiculous amount of CPU cycles. If you want to compress data to deal with efficiency and speed, it is not possible. I would still prefer it over a database like sybase, because of its pros, but it is definitely heavy on the memory. **Recommendations to others considering PostgreSQL:** I'd recommend using this easy and flexible database over any of the other paid or open sourced databases because it's just so easy to use and manage. **What problems is PostgreSQL solving and how is that benefiting you?** I have mostly used postgres for database management, and also database migration from sybase to postgres and to test it. It's benefits are very obvious and is once of the best DBMS out there in my opinion. ### 41. Best Database that works platform independently. **Rating:** 5.0/5.0 stars **Reviewed by:** Dustin R. | Enterprise (> 1000 emp.) **Validated Reviewer:** Validated through a business email account **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **Reviewed Date:** December 17, 2019 **What do you like best about PostgreSQL?** Multiple data amounts can be maintained for longer periods making persistence easier as the risk is that the data can be reloaded. **What do you dislike about PostgreSQL?** Degrade quality in contrast to Mysql when using SELECT, a standard car vacuum may be feasible. **Recommendations to others considering PostgreSQL:** Do not advise if performance is important to you. More databases can't be found. **What problems is PostgreSQL solving and how is that benefiting you?** It was very useful to PostgreSQL. Scalability feature makes it secure. It also leads to long-term storage of large amounts of data without the possibility of data becoming compromised. PostgreSQL also facilitates access control, as it allows several active sessions concurrently. It has a wide peer group and many clients because it has good service support. ### 42. Postgresql **Rating:** 4.5/5.0 stars **Reviewed by:** Yeraldin N. | postgresql, Mid-Market (51-1000 emp.) **Current User:** The reviewer uploaded a screenshot or submitted the review in-app verifying them as current user. **Validated Reviewer:** Validated through a business email account **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **Reviewed Date:** June 28, 2019 **What do you like best about PostgreSQL?** What I like most about Postgresql is that I can store and manage a database with large volumes of information, with excellent security and is very robust at the level of data processing. The base language is sql, which is very simple to manipulate and obtain information, and also can be installed both in windows, as in linux, as is my case, and its installation is very simple. Another of the things I like about postgresql is that there is a lot of documentation and tutorials to learn how to use the tool and the updates are periodic since they have the support of postgresql.org, which guarantees the postgresql update. Other aspects that I like about this application is that there is no lease charge since Postgresql is completely free for installation and use **What do you dislike about PostgreSQL?** What I do not like about Postgresql, is that its native interface for managing and manipulating data in tables is very rudimentary and is done through the console environment of the operating system. Therefore, a database client such as Pgadmin must be installed in order to have a pleasant data handling and manipulation environment. Another thing that I do not like about this application is that the process of inserting into small databases is very slow compared to other databases such as MYSQL. This is because Postgresql was designed to handle databases with large volumes of information. **Recommendations to others considering PostgreSQL:** I would recommend it for those companies that handle large volumes of data in databases that seek security and protection of their data. I would also recommend it for those companies that develop software to market it and that should handle large amounts of data. It is also ideal for those companies that seek to reduce the expense of paying the license to use a database administrator, since Postgresql is completely free to download and install it. **What problems is PostgreSQL solving and how is that benefiting you?** The main benefit is that you can manipulate databases, with large volumes of information, with the security and robustness offered by Postgresql, which has been proven for many years. Other problems solved, is that the purchase of the license is removed, to be able to use the application, since Postgresql is free and can connect the number of users you want without any type of administration. In turn, postgresql can be connected to most existing development programs, and in some of them like PHP, it has a set of commands that facilitate the connection with postgresql ### 43. RDBMS For Everyone! **Rating:** 3.5/5.0 stars **Reviewed by:** Alonso C. | Developer, Apparel & Fashion, Enterprise (> 1000 emp.) **Validated Reviewer:** Validated through LinkedIn **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **Reviewed Date:** August 31, 2019 **What do you like best about PostgreSQL?** It's free. Done! The best of something is when you get what you want without paying, this is the case of PostgreSQL. There will be a time when you need to create an application/software, and no matter if it will be used for 5 or 1000 users, different geographic locations, you will get an easy setup, strong documentation and a great community behind PostgreSQL. Finally, it is a multi-platform software, so you can have multiple instances either in linux or windows, it comes down to your personal preference, personally, I always use Debian and I haven't ever had any big issue. **What do you dislike about PostgreSQL?** Replication process. Last time I checked, I had to use Slony or something outside PostgreSQL to accomplish this process. I would like that there would have been a way to do it native n the core of PostgreSQL. Also, the documentation is really strong, you will find it quick and easy and in a really neat way, but I would like that it was more easy to read, maybe it's just me, but I like for example the way ReactJS documentation is made, I believe that it gives you a clear idea without using weird and rare words. **Recommendations to others considering PostgreSQL:** At least try it, you won't regret it. **What problems is PostgreSQL solving and how is that benefiting you?** Basically, not paying and Enterprise expensive license for our company, I work in a small manufacturing company, and the IT department is not the one who gets more money to improve the infrastructure, but having PostgreSQL it gives us more margin to improve in other areas, for example, servers, security, and professional growth through buying courses on line. . ### 44. Object-oriented relational database management **Rating:** 5.0/5.0 stars **Reviewed by:** DAVID G. | Database administrator, Mid-Market (51-1000 emp.) **Validated Reviewer:** Validated through a business email account **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **Reviewed Date:** August 26, 2019 **What do you like best about PostgreSQL?** I use Postgresql as my favorite data handler above MySql, Oracle among others, due to its simple way of use and what I like most is that it is totally cross platform I can install it on Linux and Windows without problems exporting a database and without problems being able to make a retore from any operating system But one of the things that I like the most is that you can have a high concurrence in the access of the users who want to consult information in the database without any waiting or blocking to the other users and the answers of the queries are exact and updated to the latest modifications made to the records in an easy professional manner and with impressive stability **What do you dislike about PostgreSQL?** One of the things I do not like is the migration of versions with respect to databases and more than anything with stored procedures it is simply complicated when there is a new version sometimes it is very difficult to migrate from one version to another and less if the version is higher and I want to migrate a database to a lower version, I really dislike this since I have had to implement backups and create new procedures to raise the back of a database with its functionalities correctly in other versions and despite that there is a lot of documentation on the internet and many Postgres forums do not have an official help obviously for being free code **Recommendations to others considering PostgreSQL:** my recommendation is to use this wonderful database manager is impeccable and its free code gives a guarantee when using this driver until its latest releases I have many years of experience using Postgresql and without a doubt despite being free it is one of the best drivers of databases nowadays that has remained for many years as a reliable reliable tool and a good option to work on medium and long complexity projects in data and security **What problems is PostgreSQL solving and how is that benefiting you?** the benefits are many but especially the cost reduction when using this totally free and easy-to-use database manager with a large data support capability, Postgresql helps me solve the problems of saving a lot of information from secure way through a web application and especially the execution times of its sentences are fast ### 45. PostgreSQL with PgAdmin **Rating:** 4.5/5.0 stars **Reviewed by:** Diana P. | degree in computer science, Mid-Market (51-1000 emp.) **Current User:** The reviewer uploaded a screenshot or submitted the review in-app verifying them as current user. **Validated Reviewer:** Validated through a business email account **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **Reviewed Date:** June 01, 2019 **What do you like best about PostgreSQL?** What I like most about PostgreSQL apart from how reliable and powerful this database manager is, is that it can be managed with other visual programs such as PgAdmin. This makes it possible to manage Posgrest visually, it is more convenient to easily use the SQL statements that through consoles this is what I like most of Postgres **What do you dislike about PostgreSQL?** one of the things that I dislike most of Postgres is that it is very complicated to pass a file in Excel with information to a table in Postgres since with mysqladmin it is much simpler and easier to do this procedure that in my work I have to do frequently this process in postgres in their new versions should make it easier for the user **Recommendations to others considering PostgreSQL:** as a recommendation for this manager of Postgres databases is that for small applications improve the performance of the application so that it is not so slow since Postgres is designed for applications with more complexity than MySQL because of this one thinks to do for a small and easy application work with this database manager and not with Postgres **What problems is PostgreSQL solving and how is that benefiting you?** the most important benefits in the company using this Postgres database manager is the cost reduction with respect to other private managers and also that it is much easier to manage this tool than others such as Oracle, Microsoft sql server. ### 46. PostgreSQL, Database engine **Rating:** 5.0/5.0 stars **Reviewed by:** Zait A. | Ingeniero de desarrollo de software, Mid-Market (51-1000 emp.) **Validated Reviewer:** Validated through a business email account **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **Reviewed Date:** July 25, 2019 **What do you like best about PostgreSQL?** PostgreSQL is one of the most interesting options in open-source relational databases. PostgreSQL brings a lot of flexibility to our projects. For example, it allows us to define custom functions through various languages. Some of them are: PL/pgSQL PL/Tcl PL/Perl PL/Python PL/PHP PL/Ruby PL/Java One advantage of PostgreSQL is that it is available for many platforms and offers source code from the official site. Some of the official builds are: Mac OS X Windows Solaris Red Hat Debian Ubuntu **What do you dislike about PostgreSQL?** Relatively slow on inserts and updates in small databases, PostgreSQL is designed for high-volume environments. This makes the response speed seem slow compared to small databases. The syntax of some of your commands or statements may not be intuitive if you don't have an average level of knowledge of SQL language. **Recommendations to others considering PostgreSQL:** Use, pgAdmin is the official tool to administer our databases in PostgreSQL. It allows us to do SQL searches to develop our entire database in a very easy and intuitive way, directly from the graphical interface. **What problems is PostgreSQL solving and how is that benefiting you?** PostgreSQL is free and open, and today offers a lot of advanced options. In fact, it is considered one of the most advanced database engines today. An interesting feature of PostgreSQL is multi-version concurrency control; or MVCC. This method adds an image of the database status to each transaction. This allows us to make eventually consistent transactions, offering us great performance advantages. In Postgres it is not required to use reading blocks when making a transaction, which gives us greater scalability. PostgreSQL also has Hot-Standby. This allows clients to search (read only) the servers while they are in recovery or standby mode. This way we can do maintenance or recovery tasks without completely blocking the system. Translated with www.DeepL.com/Translator ### 47. Free and Open Source Database PostgreSQL with multi version concurrency control **Rating:** 4.5/5.0 stars **Reviewed by:** Nikhil K. | I am a Sr. Software Engineer, 5 years of experience in development, use "whereby app" formely known as "Appear" very frequently for solving some of the issues by sharing with peers screen online., Small-Business (50 or fewer emp.) **Validated Reviewer:** Validated through a business email account **Source: Organic:** Organic review. This review was written entirely without invitation or incentive from G2, a seller, or an affiliate. **Reviewed Date:** September 17, 2019 **What do you like best about PostgreSQL?** It is a open source, it supports different language within postgres like pgplsql and python and other many more languages it is compatible with.Supports JSON allows linking with other data sources . Supports multi version concurrency. **What do you dislike about PostgreSQL?** It does not have sorting on click of column while resulting a query through PgAdmin interface. Can't switch through different tabs of query tool using (alt+ tab), which result in force user to use mouse for switching. **Recommendations to others considering PostgreSQL:** have multi version concurrency support and its open source. **What problems is PostgreSQL solving and how is that benefiting you?** Analyzing and Keeping organisational data for reporting purpose and find out the analytical trends for the historical data saved in postgreSQL Database and writing logics in the form of functions and triggers for certain events according to the organizational process . ### 48. object-relational database **Rating:** 4.5/5.0 stars **Reviewed by:** Sachin P. | Sachin Patel, Small-Business (50 or fewer emp.) **Validated Reviewer:** Validated through a business email account **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **Reviewed Date:** October 20, 2019 At G2, we prefer fresh reviews and we like to follow up with reviewers. They may not have updated their review text, but have updated their review. **What do you like best about PostgreSQL?** Large volume data securely store using PostgreSQL. In PostgreSQL base language is SQL. SQL is very simple and we can manipulate and generate information. PostgreSQL install in window as well as Linux. I use PostgreSQL in my rails project. Documentation of PostgreSQL easily available on internet so we can easily learn about PostgreSQL. **What do you dislike about PostgreSQL?** I don't find any dislike in PostgreSQL. PostgreSQL is easy to use and query easily understand. **What problems is PostgreSQL solving and how is that benefiting you?** It is open source so we can easily install in our project and use that and security of PostgreSQL is very best. PostgreSQL is used to save and retrieve data for my projects. ### 49. PostgreSQL **Rating:** 5.0/5.0 stars **Reviewed by:** Manuel G. | Engineer, Mid-Market (51-1000 emp.) **Validated Reviewer:** Validated through a business email account **Source: Organic:** Organic review. This review was written entirely without invitation or incentive from G2, a seller, or an affiliate. **Reviewed Date:** July 15, 2019 **What do you like best about PostgreSQL?** Postgres has an excellent community that contributes constantly in this development, postgre is updated constantly. PostgreSQL is an excellent tool to carry out developments and volumes of data. This is a database that serves applications perfectly, behaves very quickly, safely and reliably, has modules for the recovery of information and points of recovery from the disaster, is currently in version 11 **What do you dislike about PostgreSQL?** Postgres is perfect to tell the truth, it has no flaws and we can not demand that it has the scope or functions of Oracle, although it has nothing to envy, postgres without a doubt is the best option **Recommendations to others considering PostgreSQL:** Postgres has an excellent community that contributes constantly in this development, postgre is constantly updated and is in version 11, it is easy to use and with a fairly easy learning curve. I have several years of experience, and I am making the steps to get certified in Postgre **What problems is PostgreSQL solving and how is that benefiting you?** PostgreSQL I am currently setting up a cloud service, which has given me excellent results, it has not even been necessary to perform the intonation of the service, since the version I have installed 9.6.13 works like a charm. ### 50. database manager more updated with open source and characterized by being robust in the market. **Rating:** 4.5/5.0 stars **Reviewed by:** joseangel a. | Ingeniería informática, Enterprise (> 1000 emp.) **Validated Reviewer:** Validated through LinkedIn **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **Reviewed Date:** July 10, 2019 **What do you like best about PostgreSQL?** This database manager called PostgreSQL is the database engine of today. with great features that will allow you to handle large volumes of information, which makes it the most powerful and robust Free Code Database Management System on the market. this manager infinitely type of fields, works with the technology of triggers sentences. allows you to perform backup and restoration of the database by tables or complete. and it is compactible with a variety of operating systems including windows and linux. **What do you dislike about PostgreSQL?** a great disadvantage for us users of this platform is that postgresql is slow when inserting data or updating information in very small databases, since this has been designed with the ability to handle large and inferior volumes is often complex use for small systems. This tool despite being one of the most robust in the market has a deficit in terms of technical support we refer, because at the time of presenting errors this tool we only have support group forums with people who use and have solved said problem. **Recommendations to others considering PostgreSQL:** I recommend the use and installation of this database manager is very safe first to encrypt the information you want in such a way that it is difficult to steal your information. This database manager is integrated to different software developers and programming languages ​​such as java, php, c ++, c, html5 among others. this software is compactible for both windows and linux. **What problems is PostgreSQL solving and how is that benefiting you?** It is a tool that we manage a lot in the company because we have extensive technical support systems where we need to recompile user information and it is consulted quickly and this database has allowed us to improve the quality of the system with its great features. ## 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=5§ion=pricing&secure%5Bexpires_at%5D=2026-08-19+03%3A01%3A41+-0500&secure%5Bsession_id%5D=597dcdde-ec88-4c58-87d1-b4b4b9982547&secure%5Btoken%5D=686b3833c2c2f77cbaafa968fbe5f1189aff2594867f32c37de68bcfedc2e351&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,129 reviews) - [MySQL](https://www.g2.com/products/mysql/reviews) - 4.4/5.0 (1,583 reviews) - [Oracle Database](https://www.g2.com/products/oracle-database/reviews) - 4.3/5.0 (937 reviews)