# Page 2 | PostgreSQL Reviews 2026. Verified Reviews, Pros & Cons | Capterra > Page 2 - 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: https://www.capterra.com/p/48791/PostgreSQL/reviews --- 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 March 25th, 2026 # Page 2 - Reviews of PostgreSQL ## Showing most helpful reviews Showing 26-50 of 412 Reviews Sort by: Most Helpful Rating Company Size Reviewer's Role Length of Use Frequency of Use LH Leslie H. Student Information Technology and Services Used the software for: 1-2 years ### "Reliable and Helpful" November 11, 2024 5.0 Really helpful, easy to jump into and start practicing with. Pros Multiple different ways to view and find data. Cons The diagram feature isn't as customizable as I would prefer. Alternatives considered [MySQL](https://www.capterra.com/p/11482/MySQL/) Reason for choosing PostgreSQL Features were more inline with the product that was being developed. Review Source Aníbal M. Programador Used the software for: 2+ years ### "PostgreSQL is powerful and robust, it fits perfectly in large projects" July 7, 2018 5.0 With PostgreSQL I have been able to perform my work satisfactorily on multiple occasions, my bosses and I are happy with the results we have obtained, saving hardware investment costs because we have focused on the database, I hope to have future benefits to the use it in projects for own clients. Pros I really like PostgreSQL I have used it several times for large projects in my previous works and in the current one it is used as a database for the web page of the institution, the power of PL / pgSQL is excellent, it allows me to program commercial layers in the database without any problem this improves the response times of the final applications and allows investments in hardware in the database servers instead of in the application, the management of schemes is perfect. It is important to mention that it is free software that implies having a large database without licensing costs. A feature of PostgreSQL is the multiversion concurrency control that allows transactions consistent with time, which provides great performance advantages. PgAdmin is a graphical tool with which I can manage different databases easily and intuitively, execute SQL statements, as well as create backup copies or perform maintenance tasks. Another thing that I like about PostgreSQL is that it is available for many platforms, it is possible to install it from the repositories of the Linux version that I use. It should be noted that the PostgreSQL user community is one of the most active in the market Cons There are some things that I do not like about PostgreSQL, permissions allowance per user can be annoying, I have had to work many times on this and it is difficult, it is also relatively slow when I insert and update small databases. The official support does not have telephone or online support, although there are official forums available where users can express their doubts to which other users of the community respond. The syntax of some of your commands or statements may not be intuitive if you do not have a medium level of knowledge in the SQL language. I have had problems migrating from a PostgreSQL version to a higher one. Compatibility is sometimes relative. 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 VR Verified Reviewer Senior Software Engineer Computer Software Used the software for: 2+ years ### "The right database for 95% of use cases" May 1, 2020 5.0 Postgres is there for you whenever you need to store and retrieve simple tabular data. Whether that's your app user's name, email, and settings, or the projects and project content that they've created. As long as you're not dealing with over 10k transactions per second, it's cheap to use and extremely easy to set up. Oh, and it's also not great but just okay for advanced searching such as full-text search. Pros \- Postgres is just soooo reliable, it's hard to corrupt or lose data unless you go in and manually edit or delete the data. - Battle-tested ACID transactions to make sure you only update the data when it makes sense to have saved me so much time. - The SQL interface is easy to use once you've mastered SQL (which it isn't; it's the simplest of all the languages I've learned). - Newer versions even has support for advanced use cases such as arrays and JSON objects. - The best thing is that 90% of the backend software developers know Postgres (or MySQL which is pretty dang similar) so help is never too far away! Cons The only real reason to not use Postgres is that it is pretty hard to scale. If your software requires over 10k transactions per second, you're gonna have to put in some serious work make Postgres scale. This is where Postgres becomes a pain to optimize. Postgres provides poor support for identifying the queries that are running really slowly. e.g. you have to install a buggy plugin and then query a funky poorly documented table. Trying to do master-slave replication is also quite difficult as you often run into consistency issues and will have to modify app logic. In these cases, it's better to go with NoSQL obviously. Alternatives considered [MongoDB](https://www.capterra.com/p/127374/MongoDB/)[MySQL](https://www.capterra.com/p/11482/MySQL/) Reason for choosing PostgreSQL I picked Postgres over MySQL is not as battle tested and was behind Postgres in terms of JSON object support. I picked Postgres over MongoDB because it's easier to set up, didn't have anyone else on the team that knew how to use it (whereas all 5 of my teammates have Postgres experience), and because Postgres can handle our traffic currently. Review Source Nairoby D. Consultor Used the software for: 2+ years ### "It's free!" July 31, 2018 5.0 In my very particular opinion I feel comfortable working with Postgres for more than 10 years, it is reliable and safe, the best thing is that it is free, which allows you to save on licenses, it is ideal for any type of development. I totally recommend it Pros \- Free code database manager, which is not used for licensing. - Easy to install and configure in any operating system. - Ideal for relational databases. - It has a large community in which you can share doubts. - It is stable and reliable, scalable and secure with the correct user management. - Can work with small and large databases. - Handles the SQL language. - Being free software, it is compatible with several graphic tools that help administration and database design. I particularly recommend working with PgAdmin in its latest version for postgres 9.6.6 onwards. - Easily works as a cluster, can be configured as active-passive or active-active which improves performance - It allows to perform maintenance, recovery of databases. - I have tested the installation and use in Windows 7 operating system and Debian version 6 to 8 and works without problems. - Likewise I have worked in postgres since its version 8.1 to 9.6.6 and a positive change has been noticed and performance improvements, but I insist on the point at which the databases should be fine designed. Cons \- Many people declare it as slow in insertions and updates compared to others Managers, however, that will depend on how well designed the database is. - For some, not having support online or with an official help center can be a big disadvantage. - It is advisable to have command knowledge to work on consoles and terminals to perform a good configuration 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 CHMC Carlos Hugo Martin C. Consultor Information Technology and Services Used the software for: 2+ years ### "Experience with PostgreSQL" December 25, 2021 5.0 We have used the database for the implementation of reporters in most cases, seeking to remove the load from the main database. Pros It allows me to implement a robust database in a very short time, using a structure very similar to Oracle, in addition to having many tools that allow us to manage the data in the best way. Cons There are functionalities that with third-party products can obtain better results. Alternatives considered [MySQL](https://www.capterra.com/p/11482/MySQL/)[MariaDB](https://www.capterra.com/p/132005/MariaDB/) Reason for choosing PostgreSQL Data recovery was more performant for us. 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 Paolo C. Product Manager IT Information Technology and Services Used the software for: 2+ years ### "Ottimo ma preferisco altro" July 7, 2023 5.0 Ottima ma c'è altro. Pros Per un programmatore esperto oppure per chi ha necessità specifiche ok,ma per altre necessità consiglierei altro Cons Non è alla portata di tutti. Sicuramente non è intuitivo. Alternatives considered [MongoDB](https://www.capterra.com/p/127374/MongoDB/)[MySQL](https://www.capterra.com/p/11482/MySQL/) Review Source Mark M. Vice President of Information Technology Market Research Used the software for: 2+ years ### "Solid database that won't break the bank and won't let you down" October 15, 2020 5.0 We have never lost data, never paid too much and never looked back. PostgreSQL is at the hear of our organization and our trust has paid off in the long run. Running it on top of a managed stack such as AWS RDS is they way to go as this is the hardest part of using PostgreSQL and you don't want to waste time re-learning what has already been learned. It's worth the cost to use these services in the long run. Rapid prototyping can be done locally and is free so your price to start is always zero! Pros PostgreSQL is and always has been one of the most feature rich and solid databases available. Its price / performance / feature set is simply unmatched in the industry today. Cons There is a lot of old information on the internet that is no longer relevant to current versions and you must sift through this in some cases to find the modern and elegant solutions. It was touted as "slow" compared to MySQL in the early 2000's and much of that information is wrong due to lack of user experience with the product or no longer the case today. 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 Stability and price Review Source VR Verified Reviewer Data Analytics Manager Logistics and Supply Chain Used the software for: 2+ years ### "Best open-source RDBMS out there" June 6, 2022 5.0 Overall, we have a very productive experience with PostgreSQL. Whenever we need a backend database for any of the apps we deploy, we use PostgreSQL. It never fails us. Pros I like how easy it is to set up and deploy a PostgreSQL database. It has a rich ecosystem of tools and a great open-source community behind it. Cons I don't have anything I dislike about PostgreSQL. Alternatives considered [MySQL](https://www.capterra.com/p/11482/MySQL/)[MariaDB](https://www.capterra.com/p/132005/MariaDB/) Reason for choosing PostgreSQL Out of many open-source tools we deploy, PostgreSQL is the most widely supported DB backend among others. So we decided to use PostgreSQL whenever applicable. Switched from [SQLite](https://www.capterra.com/p/158187/SQLite/) For some tools we deployed, we naturally needed to scale up and handle more complex workloads. So we changed our backend database. 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 VR Verified Reviewer Senior Software Engineer Computer Software Used the software for: 2+ years ### "Java developer on PostgreSQL. A look back after several years." July 16, 2022 5.0 I have been using PostgreSQL for 6 years in most of the applications I write. It is my default choice for a relational database. Pros PostgreSQL is a database that every programmer is familiar with. I value its versatility and universality. It's easy to implement it production-wise with not much scale. Cons Great for simple applications, when it comes to scaling/replication problems begin. Alternatives considered [MongoDB](https://www.capterra.com/p/127374/MongoDB/) Reason for choosing PostgreSQL PostgreSQL was easier to learn for most team members. Switched from [MySQL](https://www.capterra.com/p/11482/MySQL/) I changed jobs and the new job used PostgreSQL. Review Source Ana A. Security Architecture Discipline leader Banking Used the software for: 6-12 months ### "Relational database with less capability" July 18, 2022 3.0 It is used when a commercial partner vendor introduces a commercial system and creates a small-scale system. If you connect multiple units, it is easy to use with a response that can support the operation without installing a dedicated server machine. When using packaged software in a large-scale system, there may be restrictions on the number of data elements and the number of servers connected, but we were able to reduce installation and operation costs. I was able to keep the cost of the database low and spend money on packaged software options. Pros Since it was developed to comply with SQL standards, there are no problems migrating from other RDBMS. I think the popularity of MySQL as an RDBMS is split in two, but PostgreSQL does not have the following MySQL keylogging problem, so it can be said that it is an RDBMS with little custom. We recommend PostgreSQL as the first choice for RDBMS unless otherwise specified because it works stably and can support real operations. When a small business is a customer's system project, the RDBMS license fee is often too high to pay. In such cases, customers will be happy to propose PostgreSQL, which is stable, reliable, and free to use. Unless it is a situation that requires a paid database, I think PostgreSQL is sufficient. It is not inferior to the function. Cons When you are looking for something you want to look up in a manual, it is often difficult to find it and, in the end, you often consult blog articles written by experts instead of the manual. I want the structure of the manual to be easy to understand. Review Source VR Verified Reviewer Software developer Information Technology and Services Used the software for: 2+ years ### "Powerful database" October 18, 2020 5.0 Excellent database engine with a lof of features and great overall performance. It has a very huge community so you could get help very easily. I'd recommend to use it. Pros Highly recommended. It's the most powerful database engine I ever worked with. It has a lot of features that I used and worked very well: postgis for spatial searches, full-text search, partitions, etc. Cons At some point, we start having problems with very slow queries, and after some debugging we discover postgres decided to use the wrong index to perform the query plan. Probably because of bad stats but from time to time the problem happens again. Switched from [MySQL](https://www.capterra.com/p/11482/MySQL/) We used to work with PHP and mysql, so when starting developing in ruby on rails, we prefered to use postgres because we considered it powerful than mysql. Review Source Khelvyn C. Consultor de operaciones de tecnología de la información Telecommunications Used the software for: 1-2 years ### "One of the best database managers for the world." November 14, 2018 5.0 From my point of view postgreSQL I consider it one of the most powerful database managers, since I use it daily, from my role as a database administrator, as well as a web developer, since it allows to manage environments put into production easily, with an acceptable and intuitive configuration. Pros 1164/5000 -Easy installation and configuration in other environments. - Pgadmin management interface of the databases, very intuitive and complete with the necessary to a few clicks, I recommend keeping the graphical tool for the stability it offers. -It has a connection balancer, known as pgpool that allows to manage the cluster structure well. -Principles of replication between active-active or active-passive servers Variety of console-level command options for restore or backup tasks and maintenance tasks -principal manager for developers for the scalability and stability it offers. -Management of free access, which allows the use of it without any problem, without any cost -Ideal manager for the management of relational databases -Allows the management of different versions on the same server with multiple database intentions with different listening ports. Cons \- Poor documentation - Functional technicians commonly report a slowness at the BD level, but that depends on how the DB is structured and especially if good database practices are applied Review Source Simone P. Analista IT Information Technology and Services Used the software for: 2+ years ### "Utilizzo quotidiano in ambito professionale ingegneristico IT" July 3, 2023 4.0 Pros Uso quotidiano di PostgresSQL in ambito professionale ingegneristico.Ottima la parte di user experience, strumento molto potente in grado di operare a 360° nel mondo DB e DBMS.Gestione dei dati, storage, controllo degli accessi, log, criptazione ai massimi livelli Cons al momento nulla di importante. migliorerei un pò l'help desk. Review Source SR Stefano R. Designer Computer Software Used the software for: 1-2 years ### "Robusto, economico e professionale" November 12, 2023 5.0 Pros Permette tutte le funzionalità di un dbrms avanzato (archiviazione dati relazionali in formato tabellare, politica di accessi basata su ruoli e utenti, programmazione tramite linguaggio smil pl/sql denominato pl/pgSQL). E' solido tanto quanto prodotti a pagamenti più costosi. Cons Non è facilissimo da installare e configurare Switched from [MySQL](https://www.capterra.com/p/11482/MySQL/) PostgreSQL è più solido e permette una gestione delle tabelle più granulare Review Source Moris M. Colaborador Técnico Government Administration Used the software for: 2+ years ### "PostgreSQL - Robustes y Seguridad en Bases de Datos" April 24, 2020 5.0 La fasilidad de hacer BKs configurar Jobs, analizar querys y definir data tables, triggres, referencias, entre otros hace del uso y experiencia de utilizar y administrar PostgreSQL muy satisfactoria. Pros PostgreSQL ofrece un potente motor de bases de datos que brinda una robustes para la administración de BD ademas de una devirsificación de herramientas para trabajar con los Data Tables, triggers, punteros, etc, el análisis de querys permite al administrador porder determinar los aspectos donde deben mejorarse los querys. Cons Las opciones de configuración y personalización que nos ofrece PostgreSQL si bien son muchas, hay algunas de mayor importancia y hay que configurarlas o setearlas hasta finalizado el proceso de instalación, siendo que podria incluirse en este proceso para que no se invierta tiempo en hacer estas personalizaciones o configuraciones minimas. Alternatives considered [Oracle Database](https://www.capterra.com/p/5938/Oracle-Database/)[MySQL](https://www.capterra.com/p/11482/MySQL/) Reason for choosing PostgreSQL Mayor relación Calidad - Precio, soporte por la comunidad internacional, robustes y seguridad Review Source Adolfo M. System Administrator Government Administration Used the software for: 2+ years ### "Very complete and stable database" June 19, 2020 4.0 I have very good experience installing and configuring databases with PostgreSQL. Once installed and configured it is very stable, almost without errors and one can rest assured that the data is fine Pros It is very complete for any type of project or application. It is stable, easy to use and can handle a lot of structured data. It is free software and is very well documented It is very popular and has a very varied community around the project Cons Its installation and configuration can be a bit complex at first. Being free they are not obliged to provide support Requires specific tuning for each possible scenario Alternatives considered [Microsoft SQL Server](https://www.capterra.com/p/1417/SQL-Server/)[Oracle Database](https://www.capterra.com/p/5938/Oracle-Database/)[MySQL](https://www.capterra.com/p/11482/MySQL/) Reason for choosing PostgreSQL For its flexibility for all types of projects, its price, and its stability. Switched from [MySQL](https://www.capterra.com/p/11482/MySQL/) To handle more data and guarantee its integrity. Review Source Abdelhakim Z. PhD Researcher Education Management Used the software for: 2+ years ### "The best user tailored db experience." April 22, 2020 5.0 I use PostgreSQL with almost every endeavor nowadays. Both at work and with personal projects, it is very robust when used in my research field which is optimization and operations research, but also flexible enough to help me quickly deploy web apps. Pros PostgreSQL is by far the most user friendly and most advanced database system out of the top 5 popular choices. It's inherently relational making it easily compatible with ORMs, has many smaller quirks like jsonb storage, the WITH keyword, and a vast amount of data types. It's also one of the most dynamic DBMS as it releases major changes more than once a year, with an ecosystem that consistently adapts to these versions. Cons Extensions in pgsql could use a bit of streamlining (extensions like pg\_cron or similar), which was a bit complicated to do in with CI. Another concern would be some stability issues with the latest pgAdmin database interface, but in all fairness that isn't directly an issue with pgsql. Switched from [MySQL](https://www.capterra.com/p/11482/MySQL/) Like I mentioned earlier, a few gotchas with MySQL like lacking the date data type with respective timezones, the WITH keyword that is used for subqueries, but ultimately it was because Postgres has the PostGIS extension which we needed at the time for geographical mapping. 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 Fernando R. COO Computer Software Used the software for: 2+ years ### "Powerful database" April 18, 2022 5.0 We use PostgreSQL as database tool for all our healthcare software products Pros PostgreSQL is eaiser to maintenance and to install than other RDBMS like ORACLE. PostgreSQL is open source so is cheaper than other RDBMS. It takes less learrning time than other RDBMS Cons We do not have any cons about PostgreSQL Switched from [Oracle Database](https://www.capterra.com/p/5938/Oracle-Database/) PostgreSQL is more simple and cheaper than ORACLE Review Source VR Verified Reviewer Software Developer Computer Software Used the software for: 2+ years ### "PostgreSQL Review" September 25, 2022 5.0 I have used Postgres in many projects, it is generally preferred that it is open source. It is also very successful in data consistency. Since it is compatible with many programming languages, it is easier to integrate with another tool or to use when you switch to a different language compared to other RDBMS. Pros Being open source is a huge plus. It is quite reliable in terms of data consistency. Cons Memory usage is bad compared to other RDBMS. 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 Similar Products Featured