--- title: "PostgreSQL Reviews 2026. Verified Reviews, Pros & Cons | Capterra" description: "Is PostgreSQL the right Database solution for you? Explore 412 verified user reviews from people in industries like yours to make a confident choice." source_url: "https://www.capterra.com/p/48791/PostgreSQL/reviews/" page_type: "reviews" language: "en" --- PostgreSQL 4.6 (412) [View alternatives](https://www.capterra.com/p/48791/PostgreSQL/alternatives/) Provider data verified by our Software Research team, and reviews moderated by our Reviews Verification team. [Learn more](https://www.capterra.com/our-story/) * * * Last updated July 21st, 2026 # Reviews of PostgreSQL Ease of use 4.3 Customer Service 4.1 ## Pros and Cons in Reviews Samuel Isaí R Full stack developerComputer Software, 2 - 10 employeesUsed the software for: More than 2 years. “I have used postgresql to create difficult subqueries, the implementation is easy and scalability is a game changer.“ December 23, 2024 HM Hussein M Software Engineer Retail, 201 - 500 employeesUsed the software for: 1-2 years. “Lack of built-in sharding,n PostgreSQL does not have built-in sharding capabilities, which may make it more challenging to scale out horizontally across multiple servers.“ May 5, 2023 SP Sudhakar P Sr Software EnggFinancial Services, 1,001 - 5,000 employeesUsed the software for: Less than 6 months. “It is nice experience to access PostgresSQL using cloud sql however accssing Bigquery from postgres is not possible“ April 5, 2025 maneesha d Information System Administrator Financial Services, 1,001 - 5,000 employeesUsed the software for: 6-12 months. “when we considering large DBs like data warehouse large number of data reading needed but this is having low reading speed by comparing other rdms applications“ August 14, 2022 Shaunak P Senior Data EngineerInformation Technology and Services, 1,001 - 5,000 employeesUsed the software for: 1-2 years. “It is capable to efficiently store big volume of data.“ March 9, 2025 Limuel M Senior Data AnalystMarketing and Advertising, 501 - 1,000 employeesUsed the software for: 6-12 months. “There are way too many reserved keywords. Because of reserved keyword restrictions, we are unable to choose meaningful column names with this many keywords.“ February 17, 2023 SU Solomon U Web DeveloperComputer Software, Self-employedUsed the software for: Less than 6 months. “It offers advanced data management and security features, such as table partitioning, data encryption, and role-based access control.“ January 18, 2023 PG Parul G Data Engineering ExpertPharmaceuticals, 10,001+ employeesUsed the software for: More than 2 years. “The DB performance , lack of in depth documentation and lack of dedicated customer support to get quick help on critical production loads.“ January 13, 2023 ## Showing most helpful reviews Showing 1-25 of 412 Reviews Sort by: Most Helpful Rating Company Size Reviewer's Role Length of Use Frequency of Use Samuel Isaí R. Full stack developer Computer Software Used the software for: 2+ years ### "Sql managment for everyone" December 23, 2024 5.0 I have used postgresql to create difficult subqueries, the implementation is easy and scalability is a game changer. Pros subqueries and json native compatibility is a game changer Cons It uses more resources than other Sql Managers and it´s difficult to undertant the unique features when I started using it. Switched from [MySQL](https://www.capterra.com/p/11482/MySQL/) I was looking for a faster database managment system and free Review Source Arjun K. Founder Computer Software Used the software for: 2+ years ### "The Reliable Workhorse with Infinite Flexibility" May 26, 2023 5.0 Nothing short of exceptional. It covers all the bases with its reliability and performance, and its flexibility is unmatched. I've found it difficult to recommend any other database unless you have specific requirements, such as a document store or a graph database. Postgres fills in all the gaps and has become my go-to choice for any project that requires a rock-solid, flexible relational database. Pros does the basics like a pro while offering infinite flexibility. From JSON columns to full-text search, there's a plugin for every need. Plus, it plays nicely with every ORM known to man. Postgres has mastered the art of doing the basics exceptionally well. It's reliable, performant, and stands strong as a relational database. But what sets it apart is the remarkable flexibility it offers. Need to store and query JSON data? No problem. Looking for full-text search capabilities? Postgres has your back with plugins that can handle it all. This database truly adapts to your evolving needs, making it a versatile choice for any project. Cons No Issues at All, Just Vendor Restrictions. Now, I have to dig deep to find something negative about Postgres. The truth is, I haven't encountered any issues with Postgres itself. Its robustness and stability have been flawless in my experience. If I had to point a finger, it would be at the vendors (like Heroku) who occasionally restrict certain plugins. But hey, that's not Postgres's fault—it's still a champ in its own right. Alternatives considered [MongoDB](https://www.capterra.com/p/127374/MongoDB/) Reason for choosing PostgreSQL ostgres won me over for two primary reasons. First, the development experience with Postgres is a breeze. Its mature ecosystem, excellent documentation, and widespread community support make it easy to get up and running quickly.Secondly, working with relational data in Postgres is a joy. The structured nature of relational databases makes reasoning about data relationships and performing complex queries straightforward. While MongoDB has its merits for specific use cases, the simplicity and ease of working with relational data in Postgres were the deciding factors for me. Review Source SP Sudhakar P. Sr Software Engg Financial Services Used the software for: Less than 6 months ### "PostgresSQL in Cloud SQL" April 5, 2025 3.0 It is nice experience to access PostgresSQL using cloud sql however accssing Bigquery from postgres is not possible Pros It can store real time trnscational data Cons can access the data from GCP bigquery cloud database using cloud SQL federated query Review Source Jorge M. Software Engineer Computer Software Used the software for: 2+ years ### "PostgreSQL - A World Class DBMS that you can have for free" March 11, 2021 5.0 I have used PostgreSQL for Windows since 2008 and it has been a pleasure. Some DBs have tables with more than 1 million records and performance seems not to be affected. Pros It is free although there are some paid options that include support and special configurations. It is very stable, I have not had any critical situations like data loss. As a ASP.NET developer, it integrates easy using ADO.NET Data Providers for which there are many choices. Concurrency control is included which is very useful for data integrity. Versions for Linux, Mac, Solaris and BSD are available which increases the integration power. A huge number of third party add-ons (paid and free) can be found. PostgreSQL is being continuously improving, there is a well defined plan of maintenance and new versions are coming out regularly. Cons I have not found anything against this DMBS product. I have accomplished all of my goals successfully. Alternatives considered [Microsoft SQL Server](https://www.capterra.com/p/1417/SQL-Server/)[MySQL](https://www.capterra.com/p/11482/MySQL/)[Firebird](https://www.capterra.com/p/71249/Firebird/) Reason for choosing PostgreSQL A professional friend of mine recommended it. Additionally and after doing some research, I found PostgreSQL origins date back to 1970´s as a successor of Ingres developed at University of California Berkley. This definitely called my attention and I decided to try as a first option. I felt in love with PostgreSQL. Review Source Janne M. Technical Product Manager Telecommunications Used the software for: 2+ years ### "One of the best overall databases in the market" June 29, 2021 5.0 For overall backend database purposes I would currently not choose anything other than PostgreSQL. Widely known, easy to hire talent for, secure and reliable. Pros PostgreSQL is well supported by backend frameworks like Django. Getting into the command line of PostgreSQL database isn't necessary that often, but when a must, it works very robustly. Cons Not suitable for some data types as well as some of the competition, like time series data, that is becoming more and more important via IoT use cases. Alternatives considered [MySQL](https://www.capterra.com/p/11482/MySQL/)[MariaDB](https://www.capterra.com/p/132005/MariaDB/) Reason for choosing PostgreSQL Best direct support from backend frameworks such as Django. Switched from [MySQL](https://www.capterra.com/p/11482/MySQL/) Generational leap in web development, a new product was launched. Review Source Javier S. Desarrollador de software Information Technology and Services Used the software for: 2+ years ### "One of the BEST Open Source Relational Data Base System" November 19, 2021 5.0 In general, my experience with Postgre has been very pleasant. The systems that I have developed using this software as a data manager have been stable. When I have had technical problems it has been possible for me to find the solutions within its great community Pros its compatibility with previous versions makes development very friendly. It is also Open source and free, which allows saving costs in the development of systems. there is a lot of documentation online to find solutions to problems In addition to having a large community Cons It's official handler is not friendly. Installation for begginners is not easy. configure advanced functions such as replication It is complicated Alternatives considered [Microsoft SQL Server](https://www.capterra.com/p/1417/SQL-Server/)[MySQL](https://www.capterra.com/p/11482/MySQL/) Reason for choosing PostgreSQL Due to what is a software with great performance even though it is free Review Source Juan Manuel C. Web Developer Consumer Services Used the software for: 2+ years ### "The Ultimate Database Engine" December 20, 2021 5.0 In general, my experience with postgress is more than satisfactory, it is an engine that works very well, it is stable, it allows me to handle large databases with tables of more than a million data without any problem. It has some syntax different from common sql, but they give great functionality (like data parsing) Pros Excellent database manager, it has its own program (phAdmin) that gives you a very friendly graphical interface to carry out all kinds of tasks. Postgress is highly scalable and stable, which is why I prefer it over other options Cons As against, when the database that is handled is relatively small, when comparing response speeds with other engines, it has a small disadvantage, but its great advantage is noted by having a large database. Switched from [MySQL](https://www.capterra.com/p/11482/MySQL/) Migrate for greater product stability and scalability Review Source Tigran H. Developer Information Technology and Services Used the software for: 2+ years ### "PSQL databse." March 8, 2020 5.0 Overall this is good software to use when you in a large applications. Pros This is one of the best database software I’ve used. It has a lot of features/functions that are usable for Big projects. One of them I've use is the PSQL vector search that is not widely used but very important feature that built in PSQL, beside that it has a tons of usable functions to do operations inside database and then get the result for example timezone adjusting, manipulation with data, string function and etc. Cons Trully telling there should be few cons in this software. I've used this for over 4 years sometimes find to difficult to configure it it linux environments compared with mysql. Alternatives considered [Microsoft SQL Server](https://www.capterra.com/p/1417/SQL-Server/)[MySQL](https://www.capterra.com/p/11482/MySQL/)[SQLite](https://www.capterra.com/p/158187/SQLite/) Switched from [MySQL](https://www.capterra.com/p/11482/MySQL/) It has a lot of features/functionalities I've mentioned above that Mysql does not have. Review Source Diego C. Technical Director Market Research Used the software for: 2+ years ### "The database everyone should be using" September 21, 2019 5.0 PostgreSQL is an incredibly powerful piece of software that should be the RDBMS in every software project instead of less powerful but more famous alternatives. Personally it will be my choice for every future project. Pros PostgreSQL is so powerful, complete and stable. This should come with no surprise given the long history behind it. At the same time it's incredibly modern and supports new paradigms (like NoSQL, JSON data types) and it's also very simple to familiarize with. Cons It's unbelievable how PostgreSQL is not as well-known as one of his competitors (MySQL) notwithstanding the fact that is so much more powerful. Switched from [MySQL](https://www.capterra.com/p/11482/MySQL/) PostgreSQL hasn't got many of the limitations and quirkiness of MySQL, is much more complete and powerful and comes at the same price (zero) being open source. Also MySQL now is the hands of Oracle which is well known for his practices that sometimes look creepy (see Java for instance). Review Source Shaunak P. Senior Data Engineer Information Technology and Services Used the software for: 1-2 years ### "Best edge DB for big data delivery setup" March 9, 2025 5.0 I have used Postgres in multiple projects where data is being consumed to reflect on frontend systems (websites), backed by transformations done on Databricks. Azure managed flexible Postgres instance performance is also very good. Pros PostgresSQL is very famous among the data engineering fraternity due to its high resilience and throughput. It is capable to efficiently store big volume of data. Being open-source, it has a very good community support. Postgres implements catalog internally, so it stores differently from other RDBMS(s). PgAdmin is best tool to manage the DB with intuitive UI. Cons The only problem I faced with Postgres SQL was that API people need column comments, and for a table with huge number of columns like 250-300 fields, it is very hard to update column via SQL query. And there is no provision in Postgres to tag comment to a column with DDL statement. This is one con that I faced. Review Source Joseph M. Senior Engineer Civil Engineering Used the software for: 2+ years ### "Agrxis Review on PostgreSQL" May 19, 2023 5.0 I can state with confidence that PostgreSQL has exceeded my expectations as a database management system based on my whole experience with it. I strongly rely on PostgreSQL as a data-driven professional to store, retrieve, and analyze massive volumes of data. PostgreSQL's adaptability and scalability have been crucial in meeting our expanding data demands. The knowledge that our important information is safe thanks to the secure data storage capabilities gives us piece of mind. Additionally, we have avoided possible data loss situations thanks to the backup and recovery tools. One of PostgreSQL's unique advantages is its support for several programming languages, which has enabled us to collaborate easily with other development frameworks. The query performance was identified and optimized with the use of the performance analysis tools, resulting in effective data retrieval. The ability to import and export data has also made it simple to move data between platforms. Overall, PostgreSQL has exceeded my expectations, and I heartily endorse it to anybody looking for a solid and dependable database management system. Pros In my experience with PostgreSQL, its adaptability and dependability as a database management system were its strongest points. I like PostgreSQL's broad range of features and capabilities as a data specialist. In order to satisfy the various data requirements of our firm, it has been essential to be able to manage enormous datasets, conduct sophisticated queries, and support advanced data types. The versatility it offers with its support for several programming languages, which enables us to smoothly incorporate PostgreSQL into our current tech stack, is something I personally enjoy. The performance analysis tools have been crucial in improving query execution and system performance as a whole. Cons My least favorite aspect about PostgreSQL was the steep learning curve and complexity involved in setting it up and configuring it. I haven't used database management systems for very long, so navigating PostgreSQL's installation and configuration options proved to be a challenge. I had to spend more time and effort learning the many PostgreSQL-specific concepts and settings. Review Source Brunei A. Développeur Full Stack Computer Software Used the software for: 2+ years ### "PostgresSQL Review" March 6, 2023 5.0 Pros PostgreSQL is highly regarded for its robustness, scalability, and reliability, making it the perfect choice for businesses looking for a dependable and secure database. It has a wide array of features such as advanced indexing, support for stored procedures and triggers, as well as a wide array of data types, making it ideal for creating complex applications. It also supports an extensive range of languages and tools, making it easy to use for developers and administrators. Additionally, PostgreSQL has high availability and fault tolerance, making it suitable for mission-critical environments. Furthermore, PostgreSQL can be used in the cloud, making it an ideal solution for businesses looking for a reliable and secure database solution. Cons PostgreSQL can be a challenging platform to learn, especially for beginners. Its steep learning curve, complex structure, and lack of user-friendly documentation make it difficult to get started. Furthermore, troubleshooting and debugging can be difficult, causing even more frustration for those just starting out. Alternatives considered [MariaDB](https://www.capterra.com/p/132005/MariaDB/) Review Source Maryury P. DBA Especialista I Banking Used the software for: 2+ years ### "Database Manager PostgreSQL" September 13, 2018 4.0 In my experience using the software I really liked that it allows adding custom functions developed using different programming languages. The integrity of the data and the referential integrity of the foreign key are maintained. It has allowed me, in an easy and secure way, the asynchronous replication of the databases for an alternative center in case of disasters. I did not like it is that when I have any doubt about an error presented in the system where the database is working, I can not clarify it because there is no specific place to which, because and com solve the error. Pros PostgreSQL allows to control high concurrency, offering security by domain definitions, who can access the database server, the backup copies of the database can be made completely or only a table, according to the request, restorations and tasks maintenance, in addition to replicate in case of disasters. It also allows to activate triggers to execute in tables or views in special cases or eventualities. It has a friendly graphical interface for the administrator, through which they can be done from the creation of the database, to execute query querys and updates of the data, if necessary, you can have details with the status tool of the server referring to the queries that are executed in the DB (if there are locks, duration, etc.). It allows the development of robust and efficient Databases Cons There is no online or telephone support. Only official forums are available where users expose their doubts that other users of the community respond to, ademas it consumes many resources Review Source SU Solomon U. Web Developer Computer Software Used the software for: Less than 6 months ### "PostgreSQL is lighter than Mysql, but it can be a little difficult to set up." January 18, 2023 4.0 PostgreSQL is a powerful and reliable relational database management system, however, its setup and configuration can be complex, and it may not perform optimally in certain high-speed or large-scale data processing scenarios. Despite this, it offers advanced data management and security features, and it supports data replication and backup/recovery Pros PostgreSQL is a powerful and reliable open-source relational database management system. It offers advanced data management and security features, such as table partitioning, data encryption, and role-based access control. Additionally, it has powerful SQL query language that enables complex and efficient data retrieval, and it supports data transformation through the use of SQL functions and stored procedures. It also supports data replication and backup/recovery. Overall, I highly recommend PostgreSQL for anyone in need of a robust and secure relational database management system Cons PostgreSQL can be a bit complex to set up and configure, especially when compared to other databases. Additionally, it may not be the best option for certain high-speed or large-scale data processing scenarios. Its performance can also be affected by poor query design and a lack of proper indexing. Review Source Serhat C. Senior Software Developer Banking Used the software for: 2+ years ### "High Performance" June 10, 2023 5.0 Pros One of my favorite features is that PostgreSQL can be learned quickly and easily because there are many resources, it has high performance, it can easily handle very large data operations and high instantaneous transaction loads. Cons There is no feature that I do not like. I've done everything I want so far. I am satisfied. Review Source VR Verified Reviewer Founder Marketing and Advertising Used the software for: 2+ years ### "Solid database, but not user (or even admin) friendly" September 25, 2021 5.0 Pros It's a solid database tested over the years by half of the world. Whatever features you need it has it. Cons You'll often need to Google for the exact command you need to run, the docs are very dry and the syntax is unconventional. You'll suffer greatly trying to write code to access the database. If you want to upgrade, scale, or do anything significant with a large production database you're probably best off hiring a specialized consultant - it's risky and not easy. Alternatives considered [MySQL](https://www.capterra.com/p/11482/MySQL/) Review Source VR Verified Reviewer Software Engineer Computer Software Used the software for: 1-2 years ### "Great, yet not perfect Rdbms" February 26, 2023 4.0 I will use it as long it is the best in the marke Pros It supports a wide range of data types, which makes it a great candidate. Cons complex to set up and configure, especially for those new to RDBMS Alternatives considered [Microsoft SQL Server](https://www.capterra.com/p/1417/SQL-Server/) Reason for choosing PostgreSQL better performance Switched from [MySQL](https://www.capterra.com/p/11482/MySQL/) Performance issues Review Source Dikshyaraj B. Infosystem Engineer Retail Used the software for: 1-2 years ### "The best RDBMS of 21st century" May 31, 2022 5.0 postgresql is something i use 80% of the day. The features i have used on same are helped me a lot in terms to develop existing db activities. The parallel query execution and operations facility is the best thing i love in postgre. Pros The functionality and availability of postgresql db can be highly appreciated. The parallel schema instaces allows user to run paralled different operations on same dbs. The file/data type supported are almost all types. The ability to join more tables than any other rdbms is something postgresql stands out in market. Cons I did nt find any cons in postgre as compared to other rdbms,i find it the best in market. If i need to tell a con then i want it to become as fast as SAP-HANA-DB. Review Source Rafał M. Owner Management Consulting Used the software for: 2+ years ### "Postgresql (psql) is a great way to start with "serious" RDBMS" May 17, 2022 5.0 Postrgresql was a DB engine for our retail stores cashier system. TCO was 20% compared to Oracle (including hardware and support). Fast, flexible and with great support of programming languages, with API compatibility helped us to run a full scale retail chain (16 offline stores) with real time stock management in our online store. Pros \+ scalability + SQL compilant + security + open source (free but not without costs) + offers more field types than mysql + API compatibility + low TCO - cheaper than Oracle (but with similar performance) + great programming language support (Python, PHP, C++ etc) Cons \- free (open source) does not mean witout costs. Sometimes it is very hard to find a specialist that can properly handle PG issues - not present at most of hosting services (but you can always run a virtual machine on AWS EC2) - less tools for data manipulation/analysis compared to MySQL Alternatives considered [Oracle E-Business Suite](https://www.capterra.com/p/214932/Oracle-E-Business-Suite/) Reason for choosing PostgreSQL Low TCO, almost the same performance. Review Source TW Thushan W. Software Engineer Computer Software Used the software for: 2+ years ### "Postgress as a relational DBMS." May 26, 2023 4.0 Pros I have used this several times while I was studying and in my company also. t supports ACID properties and it can handle high traffic. I can use database indexing, different data types. functions, aggregates and complex queries. There's a huge community support and I asked for assistance twice from them. Cons I doubt the performance of this when I handle complex queries. Review Source Sanskriti G. Senior Software Engineer Information Technology and Services Used the software for: 1-2 years ### "Managing DB with PostgreSQL works fine." September 29, 2020 5.0 PostgreSQL can process complex queries in relatively less time, and data can be accessed seemingly faster with non-key attributes. Since we deployed PostgreSQL at work we are delighted to see its flexibility and the better performance for our most common use cases. Pros Implementing the database in PostgreSQL is quick and efficient. PostgreSQL is much quicker with use-cases. Setting prototypes for development is relatively easier with PostgreSQL. It is a simply a relational database, and stores the data in tables, and supports complex transactions. Accessing data and attribute is faster in PostgreSQL especially when searching for an attribute that is not indexed. So it is great for sorting data in a relatively short period of time. Cons PostgreSQL is not flexible to JSON objects, even the nested documents or arrays are not handled with Postgres. It is slow when it comes to processing queries that use nested references, so we had to deal with more complexities at work. Review Source Sayam J. Software Architect Information Technology and Services Used the software for: 1-2 years ### "PostgreSQL- Powerful RDBMS" November 18, 2022 5.0 PostgreSQL helped and provided a lot of features and functionalities of RDBMS which helped our product a lot on its performance and commercial part. Pros PostgreSQL provides many features in its free version which are provided by the RDBMS in their enterprise version like partitioning. Cons Almost everything is ease to use in the PostgreSQL but if there can be ease of installation and the custom configuration it will help a lot. Review Source VR Verified Reviewer product management Computer Software Used the software for: Less than 6 months ### "My choice for IoT" April 2, 2023 5.0 PostgreSQL is a powerful database that can handle complex IoT applications. Additionally, the security features of PostgreSQL make it an attractive option for companies dealing with sensitive data. Pros Security is very important in IoT. PostgreSQL offers robust security features such as SSL encryption and row-level access controls, ensuring that data is kept safe and secure. PostgreSQL is highly scalable and can handle large volumes of data, making it ideal for IoT applications that generate huge amounts of data. Cons PostgreSQL has a steep learning curve compared to other databases. Its advanced features and complex commands can be overwhelming for new users. While there is a large community of PostgreSQL users, finding professional support can be challenging, especially for companies with specific needs. Review Source Trey C. Software Developer Program Development Used the software for: 2+ years ### "Best RDBMS" December 6, 2018 5.0 PostgreSQL is my favorite database management system by a long shot. I've professionally used MySQL, Maria DB, MS SQL Server, SQLite, MS Access, and several NoSQL options and Postgres is the best by far. It has a great community around a great product. The official docs are very approachable and I learn new things every time I use it. They built a strong core around consistency and reliability and ever since 9.0 they've made the system really really fast. I can't recommend this software enough! Pros Very strong consistency and reliability Feature set is growing rapidly Very fast and efficient Very developer friendly Very extensible Cons There are lots and lots of configuration options and the defaults aren't right for modern hardware Review Source Wechuli P. Software Engineer Computer Software Used the software for: 2+ years ### "Best Database System Ever !" August 27, 2019 5.0 Postgres provides everything I need in a Relational Database System, I have been using it for a while and I swear by it. Pros \- Completely and absolutely free - Open-source, so you can look at the code - Every feature you might want in a database is there - Convenient PostgreSQL admin for the management of DB servers Cons \- Making replication across several distributed regions can be quite challenging if you haven't done it before. Review Source Similar Products Featured ## Send me user reviews about this product ### Fill out the form and we'll send a list of the top-rated software based on real user reviews directly to your inbox.