# Page 6 | PostgreSQL Reviews 2026. Verified Reviews, Pros & Cons | Capterra > Page 6 - 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 6 - Reviews of PostgreSQL ## Showing most helpful reviews Showing 126-150 of 412 Reviews Sort by: Most Helpful Rating Company Size Reviewer's Role Length of Use Frequency of Use VR Verified Reviewer Software Developer Telecommunications Used the software for: 2+ years ### "Best database with GUI" May 24, 2020 5.0 We use PostgreSQL as our day to day database to manage our applications whole data and the same is in use for years. Pros Some additional query features than MySQL, availability of GUI to manage, view, query, etc. database and schemas Cons It's ability to handle large datasets with efficiency, but that's the limitation of relational databases. A little difficult to understand the official documentation. Review Source VR Verified Reviewer Business Intelligence Developer Information Technology and Services Used the software for: 2+ years ### "The best open source database IMO" February 21, 2021 5.0 Awesome experience so far. PostgreSQL supports a lot of features to data analysts. Pros From a user perspective, PostgreSQL provides features for mostly everything you need. It's open source and well documented, with a lot of support from the community. Cons So far, I wasn't able to identify any cons about PostgreSQL. It's my favorite SQL client so far, and I'm advocating for it whenever I can. Review Source Alex Danilo M. Software developer Information Technology and Services Used the software for: 1-2 years ### "Postgre review" August 31, 2019 5.0 creation and use of Stored process, triggers, schemas, roles, and transactions. Pros PostgreSQL is a great and powerful database system, used in the management of object-related databases, bringing great performances on concurrency, transactions, and schema controls. Furthermore, PostgreSQL keeps focussing on the data secure through the different kind of authentications and access control process. Moreover, PostgreSQL is an open-source license, being very convenient for any company, and any professional developments, counting with complete documentation and community support. Cons PostgreSQL has proved to be a great tool, having a great performance on hardy scenarios. However, when is used on a huge amount of object-related requests, the server could show lag issues if the database isn't properly normalized by the developers or database manager or if you have a very low spec server. Review Source Christian K. Programmer Analyst Internet Used the software for: 2+ years ### "Great database" April 17, 2019 5.0 I use PostgreSQL for many of the web applications that I've built and usually have a great experience with it. When I run into issues, a quick web search finds me the answer I need. Pros It's easy to set up and maintain. Has great community support and can be used with a wide variety of frameworks to build amazing applications. Cons The default user credentials aren't always clear when setting up on a local machine. Review Source NP Nuno P. Principal BE Developer Computer Software Used the software for: 2+ years ### "A good DB for any kind of company" August 19, 2023 4.0 Pros It's a very powerful DB for the price, it has all the features and customization that any db admin needs. Cons Without a db admin, the features may be restricted to the basic ones, unless someone researches how to do things Review Source VR Verified Reviewer Information Systems Specialist Furniture Used the software for: 2+ years ### "Not fan of it, not at all" August 13, 2019 2.0 I don’t see any reason to use this instead of MySQL unless it’s a program requisition, which is why we have it. Pros In my PostgreSQL most important part it’s being free. The rest seems a regular DBMS Cons PostgreSQL it’s hard to navigate and configure. Official tool to configure is messy and not very friendly. Performance is nothing special too. Reason for choosing PostgreSQL Application required PostgreSQL as DBMS Review Source Juan Carlos G. Lider de area de desarrollo IA Computer Software Used the software for: 2+ years ### "The open source db for bussines" February 11, 2020 5.0 I implemented a Solution on Infonavit the biggest credit giver on México they needed to save AND process data about their clients so I saved all the data on PostgreSQL everything worked like a charm ok PostgreSQL side Pros Free to use Robust technology Reliable Full compatibility with most integrations of AWS , Azure , Google , IBM Gasto , secure Not so hard learning curve Great community Constant upgrades Cons It feels a little bit overwhelming at the beginning Sometimes can be difficult to enable ok servers for the PDO driver Reason for choosing PostgreSQL Experience with the db Switched from [MySQL](https://www.capterra.com/p/11482/MySQL/) The servers that IBM allowed yo have Review Source VR Verified Reviewer Software Engineer Computer Software Used the software for: 2+ years ### "Free and Faster Database Mangement" March 8, 2021 4.0 Pros It can store a large volume of databases and faster data processing. It is cross-platform with no extra configuration for importing and exporting information. It is very comfortable to write SQL queries on the consoles. Cons I work both with Postgres and MySQL so finding syntax is a little discomforting but there is a large community for it to help me. Review Source JL John L. Data Analyst Railroad Manufacture Used the software for: 2+ years ### "Amaing SQL Dialect and Database" July 7, 2020 5.0 Having PostgresSQL has enabled me to streamline development of many data pipelines. Not having to fumble over function parameters because of PostgresSQL's intuitive operations has improved my ease of work. Pros Love this dialect. I find many of the built in function improve experience but simplifying the needs for cryptic code. For example, changing from data type to another data type, one can use the :: operator. This operator is quick and easy to understand. Cons Unfortunately, sometimes code needs to be translated to more standard SQL that would work across multiple dialect. While the built in functions of PostgresSQL has improved my easy of use and because some of these functions are not standard SQL, I find myself having to continue using more cryptic, yet standard, SQL. Review Source SA Sanchit A. software engineer Computer Software Used the software for: 2+ years ### "One of the best to manage DB connections" October 17, 2019 5.0 Pros We have been using this software for a couple of years after we faced a lot of issues and freezes in MySQL. This is comparatively much much more smooth and handles multiple DB connections and inter-switching with no lags or hangs. Cons We were more accustomed to the MySQL interface so found a few minor UX improvements that can be done here but overall it's still good. Switched from [MySQL](https://www.capterra.com/p/11482/MySQL/) MYSQL use to hang up a lot on our MacBooks all the time. It was quite frustrating while resolving production issues when time was of the essence. Review Source LN Lindokuhle N. Developer Information Technology and Services Used the software for: 2+ years ### "My Go-To RDBMS" January 4, 2024 5.0 Pros It is fast, reliable and scalable; the perfect RDBMS in my humble opinion. Cons The learning curve, but even that wasn't actually so bad. Switched from [Microsoft SQL Server](https://www.capterra.com/p/1417/SQL-Server/) We moved from Windows to Linux servers to cut costs. Review Source SB Sergio B. Responsabile sviluppo Computer Software Used the software for: 2+ years ### "Il nostro db di riferimento" April 22, 2021 5.0 È da sempre il nostro db di riferimento per tutte le applicazioni che sviluppiamo. Pros Ha funzionalità che altri db non sempre supportano, è aggiornato con puntualità, ha funzionalità di ricerca fulltext molto performanti, non richiede di essere amministrato, è scalabile, è open source e gratuito e multipiattaforma. Cons La gestione di amministrazione pgmadmin potrebbe essere migliorata graficamente, ma non è questione fondamentale. Switched from [IBM Db2](https://www.capterra.com/p/240589/IBM-Db2/) Perché il DB2 ha spesso necessità di essere amministrato mentre postgresql non richiede alcun intervento. Review Source debasis M. dba Telecommunications Used the software for: 2+ years ### "postgres review" June 9, 2019 5.0 Pros I like it is very easy to install and very light weight Cons It does not scale horizontally so it is difficult to handle large DBMS system Alternatives considered [Oracle Database](https://www.capterra.com/p/5938/Oracle-Database/) Review Source AK Aivar K. Owner Marketing and Advertising Used the software for: 2+ years ### "More powerful than MySQL - but you probably don't need it" July 17, 2022 5.0 I find Postgres to be useful in cases where you want to keep the vast majority of your application logic inside the database itself. Great for data analysis and machine learning applications - not so great for running a web service. Pros It is more feature rich than MySQL and supports very sophisticated requests. With enough experience, you can write a procedure that can merge and shape any data you could possibly derive from the tables, in any possible format, with little overhead. Cons No powerful GUI tools are available for administration. MySQL is a lot more convenient in day-to-day use thanks to PHPMyAdmin. Setting up and running the database is a bit convoluted as well - doesn't work reliably out of the box. Alternatives considered [MySQL](https://www.capterra.com/p/11482/MySQL/) Reason for choosing PostgreSQL I still mostly use MySQL, but Postgres is better for offline or one-time data analysis in my experience. Review Source Michael E. Fixed Income Operations Specialist Investment Management Used the software for: 2+ years ### "An easy way to access SQL" February 5, 2020 4.0 After switching over from Access, it has been nice to be able to have a more robust experience. Pros The easy to understand interface. It is more intuitive than MySql, and is more enjoyable to work within. Cons It is a bit more difficult to work within multiple queries. The ability to quickly maneuver between different queries could be improved. Review Source Stanislas J. Administrateur du SIGB Used the software for: 1-2 years ### "Good DBMS. Handles a lot of data without loss of performance" December 4, 2017 5.0 It is a lot more efficient than the old database manager we used before. Pros It is very fast for running queries from bash (logged in by SSH) or within PGAdmin (from a distant client) ; the ability to lauch queries from PHP permits building web-apps using the database very simply. Cons Using variables in not as simple as in MySQL. It needs to use plSQL or mixing bash and SQL. I prefer PgAdmin 3 rather than PgAdmin 4. This new version seems to priorize design rather than ease of use. Review Source Juan Carlos G. Profesor Used the software for: 2+ years ### "a powerfull DBMS, i used in businesses and provides a lots of features." May 18, 2018 5.0 Although is not Oracle Corp, y prefer use PostgreSQL to management the DB in where work. Pros Part of community software, free, adaptable and configurable. The security is very powerful, management user, tablespaces, logs... Cons Because is a free sorftware, have multiple choice for support, however many businesses has certifications... Review Source SG Shaune G. Data and Research Associate Non-Profit Organization Management Used the software for: 6-12 months ### "Postgres for a small database" June 14, 2022 5.0 Great product; easy to use with AWS RDS; lots of functionality Pros I was new to database management. Postgres is widely used and there are vast resources that help bring me up to date or help me solve problems. Cons All database software is hard to use. I also had a problem with PGAdmin after an update and had to switch to a different DBMS. Switched from [Microsoft Access](https://www.capterra.com/p/233275/Microsoft-Access/) Postgres has more features and can be used with AWS RDS. Review Source RK Rajesh K. System Administrator Computer Software Used the software for: 6-12 months ### "Review Of PostgreSQL" July 7, 2021 4.0 Overall PostgreSQL best in Market. They have better support and help their customers. Pros The PostgreSQL is best and most powerful RDBMS software in opensource platform. This PostgreSQL better in Data Storage, Data Dedupilication and Data Replication. Cons The PostgreSQL need some of security loop holes . Alternatives considered [MySQL](https://www.capterra.com/p/11482/MySQL/) Reason for choosing PostgreSQL Evaluation Purpose. Switched from [MySQL](https://www.capterra.com/p/11482/MySQL/) Testing Review Source VR Verified Reviewer Desarrollador SOA Used the software for: 2+ years ### "It is a good database manager" July 6, 2018 5.0 I really like the software Pros I like it because it is stable, widely used and that I can develop high-end databases. It also offers features that openly is very useful. Cons Against it I see that it is a very good software but they are leaving it as a use for studies and simple things when it can be developed much more. Review Source VR Verified Reviewer CTO & Co-Founder Internet Used the software for: 2+ years ### "My preferred relational sql database" March 27, 2018 5.0 Pros It's the best open source relation database engine that I've used. It's robust, fast, scalable and it gets improvements continually Cons The tools ecosystem around is rather poor. There are some different options each in with its own problems, but there is no consistent tooling ecosystem around the engine. Review Source Rafael R. Junior Developer Used the software for: 1-2 years ### "Nice DB Management Tool" March 7, 2018 4.0 Database administration, it is quick and easy to access so we can manage our data in minutes, saving time fot other activities. Also the security is very good. Pros The simplicity and access of its interface. it is quick and easy to access. It have a lot of powerfull functionalities and it is compatible with almost every platform out there. Cons Minor bugs. Some functions are not relly explained very well, like which are the hotkeys to execute queries, do rollback, etc, sometimes they dont even work. Review Source VR Verified Reviewer BDM Information Technology and Services Used the software for: 2+ years ### "Postgres - the standard for Cloud Database" May 15, 2022 5.0 Very good option for cloud migration perspective and cost wise is an excellent platform to go with any cloud Pros Postgres makes it very easy to bring in data from multiple SQL databases and data warehouses to have all in one place. This allows better data structure. Cons Nothing not to like about Postgres sql as it’s a great platform Review Source Edward R. Proyect Leader Used the software for: 2+ years ### "I had a good experience since the first time i used this in my college" June 7, 2017 4.0 it's a powerful open source database system, and it's a trendy software Pros I like the powerful security levels in this database system despite being open source, and i like work it in different operative systems. Cons I think it's not easy to understand how to do database backups and for that reason i don't like do it Review Source VR Verified Reviewer Chief Technology Officer Computer Software Used the software for: 2+ years ### "Reliable Open Source Data Solution" December 18, 2019 5.0 We use PostgreSQL to store data for several of our applications. Pros PostgreSQL is a stable, high performance data storage solution that has a history of being ahead of the curve on web trends. Cons PostgreSQL has some difficult administration tools, and while it's worth learning, the commands are somewhat obscure. Review Source Similar Products Featured