# Page 7 | PostgreSQL Reviews 2026. Verified Reviews, Pros & Cons | Capterra > Page 7 - 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 7 - Reviews of PostgreSQL ## Showing most helpful reviews Showing 151-175 of 412 Reviews Sort by: Most Helpful Rating Company Size Reviewer's Role Length of Use Frequency of Use Alexandre B. System Analyst Information Technology and Services Used the software for: 2+ years ### "Very good" September 24, 2019 5.0 PostgreSQL helps you to store data for applications. Pros PostgreSQL it's a very good database that contains a lot of useful SQL functions and provide a tool (pgAdmin) for query existing tables in databases. Cons Some queries that are possible to do with other databases it's not possible with PostgreSQL database. Review Source Juan Carlos F. Programador Senior Used the software for: 2+ years ### "Great quality of software, very productive" November 21, 2017 4.0 All about my work Pros All support is available from developers , easy to install in many operative systems, is enough some minimium requirements from your PC. Cons Sometimes it's not compatible with some of my databases with previous versions so that is not cool, expensive if you want fully specs. Review Source Branislav V. Owner Computer Networking Used the software for: 2+ years ### "Full-featured SQL Engine" December 14, 2018 4.0 Pros We using postgresql on most of our internal and public systems. Robust, features rich and very reliable database system. Cons Even in the end of 2018, postgresql still lack reliable and built-in cluster and replication system. We have to do that with tools like repmgr and pgpool. Review Source SH Sam H. DBA Logistics and Supply Chain Used the software for: 6-12 months ### "Great production for web development" December 24, 2022 3.0 Postgresql is a perfect simple and free database for development environment. although it does not have super engine like Oracle SGA and PGA., it still handles a lot of scenarios like sample web development projects and so on and so for. it is strongly recommend Pros Postgresql is friendly to the web developer learners, small projects Cons this database is not as powerful as RDBMS like oracle and sql server Review Source DM Debarpan M. Student Marketing and Advertising Used the software for: 6-12 months ### "Open source database management tool with fast processing" April 12, 2022 5.0 We have used PostgreSQL to handle a huge amount of incoming data. The data was transformed and standardised with PostgreSQL. The data was finally stored in a data warehouse. We built a reporting layer using Qlikview on this data. PostgreSQL was used to perform a lot of aggregations and calculations. Furthermore, using this we standardised the data according to a number of pre-defined conventions. Pros High-performance relational database management system with the ability to handle huge volumes of data Free no license fees and open source community support Data security Can run on multiple operating systems environments Option to integrate with multiple data sources with optimal performances Cons Scaling must be improved Due to performances below the benchmarks sometimes PostgreSQL becomes inappropriate for large scale organisations Review Source VR Verified Reviewer 会社員 Wholesale Used the software for: 2+ years ### "無料なのに非常に高性能" April 5, 2023 5.0 ウェブアプリケーションとの連携も非常に容易で中・大規模向けでも問題なく使用できる Pros 他の有償ライセンスデータベースと同等以上の機能が無料で利用でき、レスポンスも全く問題なく使用できる Cons 複雑なクロス集計が容易にできるような関数を実装してほしい Reason for choosing PostgreSQL 当社のニーズに対して他製品よりマッチしていたため Switched from [Oracle Database](https://www.capterra.com/p/5938/Oracle-Database/) ライセンス料金の高騰 Review Source Jorge M. Ingeniero de sistemas Used the software for: 6-12 months ### " is a database that is easy to use and very practical, the benefits of working with it are many" March 8, 2018 3.0 It is free license and can be operated on different platforms, including Linux, Windows, Unix, Solaris and MacOS X. It has a multiversion concurrency control which adds an image of the state of the database to each transaction allowing the transferences to be consistent and high performance. Pros is an object-relational database which allows it to be compatible with user-defined objects, this makes postgresSQL a flexible and robust database, it supports an extensive amount of data types among them, numeric, comma types floating, array, among many more, allows to create a wide functionality through its trigger system (triggers). It has a support for distributed transactions which supports the integration in a distributed system consisting of several resources such as a PostgreSQL database, another Oracle, an IBM MQ JMS message queue and an SAP ERP managed by an application server. Cons the transactions abort completely if a fault is found during its execution, which can cause the loss of information, it is slow in the insertions and updates since it has intersection headers, the object orientation support is a simple extension that offers benefits such as inheritance, not full support. The current versions of PostgreSQL have a serious security problem that will be fixed in the next versions of the product. Review Source TA Turan A. IT Automotive Used the software for: I used a free trial ### "PostgreSQL for Everyone" November 25, 2022 5.0 We made many different types of databases comparable and reportable. It provides much more consistent and regular results. Pros It's a software I met two years ago. Since then, it has been giving successful results in many test environments. It's perfect for being compatible and open source code from every language to every platform.Prominent and self-proving features,\* Supports any OS independent environment\* Support for software languages from many different languages\* Active use in many relational or non-relational databases,\* Supports many data types and types,\* Redesignable code structure Cons It consumes a lot of additional resources: a tolerable, albeit tolerable, drawback that needs to be fixed. Review Source Kaja T. Solution Architect Oil & Energy Used the software for: 2+ years ### "My go-to database engine if no requirement towards something specific" December 14, 2018 5.0 I have used PostgreSQL in commercially available state-of-the-art monitoring system for smart devices, along with PostGIS for geodata, Timescale for timeseries data etc. Scales well to millions of devices. Pros I am amazed that something so functional and scalable is available for free. Tons of plugins for different needs. Scalable similarly to commercially available databases. Online help abundant. Easy to use through standard SQL or PGAdmin application. Cons Some concepts might get a bit to get the hang of, as PostgreSQL does them a bit differently (such as typecasting or type handling in general), but mostly nothing that one can't learn. Review Source VR Verified Reviewer CTO & co-founder Computer Software Used the software for: 2+ years ### "Postgres: A nosql kv data store" November 27, 2018 5.0 Pros Our team uses Postgres as nosql kv data store. Their jsonb field is good enough for basic kv store use. We have a few million rows in this database and quite satisfied with its performance. Cons The need to vacuum regularly makes it a little difficult to maintain in longer run. Review Source MG Marco G. Avv. Legal Services Used the software for: Less than 6 months ### "Dati archiviati su struttura solida" November 15, 2023 5.0 Si è rivelato una solida base dati permettendo l'archiviazione di dati relazionali in tabelle comode da consultare. Pros Permette di archiviare i dati in maniera professionale, condivisa e sicura mediante l'implementazione delle autorizzazioni di accesso. Dati molto corposi possono essere immagazzinati nelle tabelle. Cons A livello di installazione e configurazione è semplice o intuitivo da utilizzare per chi non è del settore. Switched from [MySQL](https://www.capterra.com/p/11482/MySQL/)[Microsoft Access](https://www.capterra.com/p/233275/Microsoft-Access/) PostgreSQL si è rivelato molto più prestante e completo a livello di funzionalità e performance di Microsoft Access (che è un prodotto basilarmente mono-utente) e di MySql (che benchè simile mi ha dato l'impressone di essere meno solido) Review Source VR Verified Reviewer Consultant Software Engineer Information Technology and Services Used the software for: 1-2 years ### "PostgreSQL Review" December 14, 2019 5.0 I use PostgresSQL for around 40% of my databases. Without it, I would struggle to provide a durable database service. Pros PostgreSQL is simple to learn, in my opinion it can be easier than other purely relational databases because syntactically it is more readable. Cons Configuring PostgreSQL can be more difficult than for it's competitors. This does, however allow for a highly customisable solution to database problems. Review Source CW Carolyn W. IT Business Analyst Higher Education Used the software for: 1-2 years ### "Low-cost alternative to Microsoft SQL Server" November 22, 2021 5.0 Pros Cost saving was the main benefit. We switched for the cost saving and also to stay in synch with our vendor Ellucian. Cons The transition period was challenging. In particular, we needed to bring on a temporary staff member to help rewrite our 1000+ reports and dashboards from the Microsoft SQL Server language to PostgreSQL. We used the free (unrelated) tool from SQLines to help with this task: https://sqlines.com/sql-server-to-postgresql. I wish the PGAdmin software had a better built-in search feature, but otherwise it seems to have all the same functionality as SQL Server Management Studio. Review Source Sanjaya K. Software Engineer Information Technology and Services Used the software for: 6-12 months ### "Powerful, scalable and flexible" December 2, 2022 5.0 Pros very useful and great database with features which can help big or small solutions. Partitions tables are powerful and can perform search on data. we can use Change Data Capture feature to track the changes on data on tables. It is a great option for semi structured objects. Cons Documentation is limited to English language.Some of the open source apps doesn't support PostgreSQL Review Source AT Andrei T. Full Stack Web Developer Computer Software Used the software for: 2+ years ### "One of the best databases to use" September 29, 2020 5.0 PostgreSQL handles all the database needs for my web application. I've experienced zero downtime or hiccups in service and highly recommend this for those looking for a SQL solution. Pros The interface is rather simple and easy to navigate through. Database backups are an important part of any database design and PostgreSQL does this splendidly. Cons For implementing it with other software, it takes some time to go through the steps to get it up and running. There is a lot of documentation on the web, so it is not too much of an issue. Review Source VR Verified Reviewer DBA Information Technology and Services Used the software for: 2+ years ### "Robust and reliable database" May 20, 2020 4.0 Parallel query, for example. MySQL doesn't have. Pros \- Reliability. - Popular. - Free. - Open Source. - Sophisticated - A lot of 3rd party tools. Cons \- Vacuum. - Poor backup tools. - A litlle complex to administer. Reason for choosing PostgreSQL Because its robust. Review Source PC Paolo C. Software Engineer Information Technology and Services Used the software for: 2+ years ### "Best Open Source RDBMS by far" March 31, 2021 5.0 I am a web developer and geospatial analyst. I am using PostgreSQL daily to store spatial datasets using PostGIS, its powerful spatial extension Pros PostgreSQL has been on my tech stack since 2006. It is an impressive open source software, really reliable. I love its PostGIS spatial module, which enables powerful geospatial functions. Cons I like everything and I can't think of something which I don't like. This is by far the best open source RDBMS Review Source VR Verified Reviewer Analyst Financial Services Used the software for: 6-12 months ### "Great database management especially on Python" August 27, 2019 4.0 Very good and standard database management system. Should use it if you don't need anything complicated. Pros It is one of the most used open source database management system so there are a lot of information out there if you ever get stuck. Also, coding the database transactions is so easy with the Python packages out there like flask and alchemy Cons Relational database structure and quite slow. Modern database management systems can just store whole objects, which is even easier to deal with compared to having to deal with the relational databases Review Source VR Verified Reviewer Full Stack Developer Computer Software Used the software for: 2+ years ### "best relation database" April 10, 2019 5.0 happy user Pros Its free to use open source tool. It gets the job done very well, much better to use than Oracle DB. Cons Its administrative tools are not best out there. For example, PgAdmin4 is worse than PgAdmin3 was. Review Source PT Paul T. CTO Computer Software Used the software for: 2+ years ### "The best database offering available" March 4, 2020 5.0 Excellent. The documentation is complete and well-written. Pros PostgreSQL is standards compliant, performant, high-quality, easy to use, well documented, innovative and feature-complete. Cons Replication still has a way to go compared to some competing offerings, but additional software can be used to fill in the missing features. Reason for choosing PostgreSQL firebird seems to be very slowly developed these days Switched from [MySQL](https://www.capterra.com/p/11482/MySQL/) Postgresql is just better Review Source KS KARTHEKEAN S. Senior Engineer Information Technology and Services Used the software for: 1-2 years ### "Perfect open source relational DB" June 10, 2021 5.0 Overall experience with PostgreSQL is great and it had very little learning curve in moving away from other proprietary DBs. Pros This is perfect replacement for any proprietary relational data bases as it provides most of the features from traditional relational DBs. It helps us in data storage and retrieval with good level of flexibility and performance. Cons Not much as this is used as free or opensource alternative the performance matches very closely to it's paid competitors. Adding in more GUI support tools could be helpful. Switched from [MySQL](https://www.capterra.com/p/11482/MySQL/) PostgreSQL provides very comparable or sometimes better performance compared to other alternatives which cost more. Review Source VR Verified Reviewer Senior Business System Analyst Computer Software Used the software for: 1-2 years ### "A good alternative to the paid databases" July 17, 2019 5.0 Pros Below are few things I liked about PostgreSQL: 1) Light weight and faster compared to other databases 2) Ease of use 3) Lots of internal functions 4) Strong community that supports the daily issues faced by the users Cons PostgreSQL needs some specific tools inbuilt for doing in depth performance analysis. Doing a performance test on PostgreSQL isn't really fun! Review Source RS Rashik S. Analyst Financial Services Used the software for: 6-12 months ### "New, faster DBMS which is free and open sourc. Updates needed to fight with the established one" March 24, 2022 4.0 Pros A faster and easier way for DB management. Free and open source. Integration with other software is easy Cons Crashes from time to time. The backup system is utterly poor Review Source Gualter A. Lead Support Information Technology and Services Used the software for: 1-2 years ### "Best SQL based system out there" November 14, 2019 5.0 It ends up being our standard de-facto database for non-extensive data. All of our Business logic relies on it Pros What I really liked was the way this SQL based database help leverage our Business. Integrating this with PGAdmin proves to be quite useful Cons It can be somewhat cumbersome to configure everything at the beginning. The learning curve for an entry-level user can be a blocker Review Source YagneshKumar P. Software Engineer Hospitality Used the software for: Less than 6 months ### "Open Source Software " June 9, 2018 4.0 The benefits i get using PostgreSQL is the ability to create tables, scehmas, store procedures and then use them to create SQL queries and expressions. Pros PostgreSQL is one of the best open source software that i like to use, it enables me to create database schema, restore databases, and also execute SQL queries. It it very easy to set-up and start using the web based application, so internet connectivity is a must unlike other SQL software, My Company recently transitioned to use PostgreSQL as a New Hire Training so people have an exposure on how to use execute SQL and more. One of functions i like about it is that, if support advanced SQL queries such as expressions and stored procedures. It also supports advanced data types such as arrays, and user-defined data types. Cons At the moment i do not have a negative feedback on PostgreSQL i feel like i like all the features about it. Review Source Similar Products Featured