--- title: "PostgreSQL Reviews, Pros and Cons - 2026 Software Advice" description: "Reviews of PostgreSQL. Learn how real users rate this software's ease-of-use, functionality, overall quality and customer support. Talk to our advisors to see if PostgreSQL is a good fit for you!" source_url: "https://www.softwareadvice.com/rdbms/postgresql-profile/reviews/" page_type: "reviews" language: "en" --- 1 million+ businesses helped. Get advice Get Free Advice [Home](https://www.softwareadvice.com/) / [Database Software](https://www.softwareadvice.com/database-management-systems/) / [PostgreSQL](https://www.softwareadvice.com/rdbms/postgresql-profile/) / PostgreSQL Reviews Software Advice offers objective insights based on verified user reviews and independent product and market research. When our advisors match you to a software provider, we may earn a referral fee. [Overview](https://www.softwareadvice.com/rdbms/postgresql-profile/) Reviews [Alternatives](https://www.softwareadvice.com/rdbms/postgresql-profile/alternatives/) # PostgreSQL User Reviews ## Reviews summary - Overall rating: 4.6/5 - Total reviews: 412 ### Secondary ratings - Ease of use: 4.3/5 - Customer support: 4.1/5 - Value for money: 4.6/5 - Functionality: 4.6/5 ### Rating distribution - 5 stars: 275 reviews (67%) - 4 stars: 126 reviews (31%) - 3 stars: 10 reviews (2%) - 2 stars: 1 reviews (0%) - 1 star: 0 reviews (0%) ### Most mentioned pros - Azure managed flexible Postgres instance performance is also very good. - 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. - 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. ### Most mentioned cons - One of the drawback of the PostgreSQL is CPU usage is rather high. - It was difficult for me to install (the process took about an hour), and if you can't remember your master password you have to delete the application and start over. - Its performance can also be affected by poor query design and a lack of proper indexing. ## PostgreSQL customer reviews Showing reviews 1-25 of 412 (page 1). ### Very complete and stable database - Overall rating: 4/5 - Reviewer: Adolfo M. - Verified reviewer: Yes - Industry: Government Administration - Company size: 10000+ employees - Product usage: Used daily for more than 2 years - Reviewed: June 2020 - Review source details: This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you. 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 #### Ratings breakdown - Ease of use: 4/5 - Value for money: 5/5 - Customer support: 3/5 - Functionality: 5/5 #### 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 #### Reasons for choosing PostgreSQL For its flexibility for all types of projects, its price, and its stability. #### Reasons for switching to PostgreSQL To handle more data and guarantee its integrity. --- ### The right database for 95% of use cases - Overall rating: 5/5 - Reviewer: Verified Reviewer - Verified reviewer: Yes - Industry: Computer Software - Company size: 201-500 employees - Product usage: Used daily for more than 2 years - Reviewed: May 2020 - Review source details: This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you. 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. #### Ratings breakdown - Ease of use: 4/5 - Value for money: 4/5 - Customer support: 3/5 - Functionality: 4/5 #### 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. #### Reasons 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. --- ### Postgres: A nosql kv data store - Overall rating: 5/5 - Reviewer: Verified Reviewer - Verified reviewer: Yes - Industry: Computer Software - Company size: 2-10 employees - Product usage: Used daily for more than 2 years - Reviewed: November 2018 - Review source details: This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you. #### Ratings breakdown - Ease of use: 5/5 - Functionality: 5/5 #### 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. --- ### Best open-source RDBMS out there - Overall rating: 5/5 - Reviewer: Verified Reviewer - Verified reviewer: Yes - Industry: Logistics and Supply Chain - Company size: 201-500 employees - Product usage: Used daily for more than 2 years - Reviewed: June 2022 - Review source details: This review was submitted organically. No incentive was offered 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. #### Ratings breakdown - Ease of use: 5/5 - Value for money: 5/5 - Functionality: 5/5 #### 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. #### Reasons 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. #### Reasons for switching to PostgreSQL For some tools we deployed, we naturally needed to scale up and handle more complex workloads. So we changed our backend database. --- ### Java developer on PostgreSQL. A look back after several years. - Overall rating: 5/5 - Reviewer: Verified Reviewer - Verified reviewer: Yes - Industry: Computer Software - Company size: 501-1000 employees - Product usage: Used daily for more than 2 years - Reviewed: July 2022 - Review source details: This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you. I have been using PostgreSQL for 6 years in most of the applications I write. It is my default choice for a relational database. #### Ratings breakdown - Ease of use: 5/5 - Value for money: 5/5 - Customer support: 4/5 - Functionality: 4/5 #### 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. #### Reasons for choosing PostgreSQL PostgreSQL was easier to learn for most team members. #### Reasons for switching to PostgreSQL I changed jobs and the new job used PostgreSQL. --- ### The best user tailored db experience. - Overall rating: 5/5 - Reviewer: Abdelhakim Z. - Verified reviewer: Yes - Industry: Education Management - Company size: 2-10 employees - Product usage: Used weekly for more than 2 years - Reviewed: April 2020 - Review source details: This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you. 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. #### Ratings breakdown - Ease of use: 5/5 - Value for money: 5/5 - Customer support: 4/5 - Functionality: 5/5 #### 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. #### Reasons for switching to PostgreSQL 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. --- ### Powerful database - Overall rating: 5/5 - Reviewer: Fernando R. - Verified reviewer: Yes - Industry: Computer Software - Company size: 11-50 employees - Product usage: Used daily for more than 2 years - Reviewed: April 2022 - Review source details: This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you. We use PostgreSQL as database tool for all our healthcare software products #### Ratings breakdown - Ease of use: 5/5 - Value for money: 5/5 - Customer support: 4/5 - Functionality: 5/5 #### 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 #### Reasons for switching to PostgreSQL PostgreSQL is more simple and cheaper than ORACLE --- ### A robust database engine for your web projects and platforms - Overall rating: 4/5 - Reviewer: Jonathan Alexander C. - Verified reviewer: Yes - Industry: Hospital & Health Care - Company size: 1001-5000 employees - Product usage: Used weekly for more than 2 years - Reviewed: May 2022 - Review source details: This review was submitted organically. No incentive was offered I have used this database to carry out web projects in the health sector and it has been of great help to manage processes and data in a very efficient way and with the best performance that I have seen. #### Ratings breakdown - Ease of use: 4/5 - Value for money: 5/5 - Customer support: 4/5 - Functionality: 5/5 #### Pros What I like most about this database engine is its security, scalability and high performance for the development of platforms and web applications, easy to maintain and manage #### Cons That I did not like the product, its difficult or complex syntax, sometimes the very tedious query error #### Reasons for switching to PostgreSQL Because of the security, the performance and how efficient this database engine can be for more complex projects that require a higher level of transaction and data handling. --- ### Best database ever! - Overall rating: 5/5 - Reviewer: Danilo N. - Verified reviewer: Yes - Industry: Internet - Company size: 51-200 employees - Product usage: Used daily for more than 2 years - Reviewed: February 2020 - Review source details: This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you. Best database management system: plenty of plugins (data visualization, backup, performance, etc), easily expandable, incredibly powerful configuration options. #### Ratings breakdown - Ease of use: 5/5 - Functionality: 5/5 #### Pros PostgreSQL is the most flexible database management system out there. It has a lot of plugins (data visualization, backup, performance, etc), which make it very expandable too, incredibly powerful configuration options, etc. It has almost any type of column that your system will ever need. #### Cons I really don't found any PostgreSQL problem until now, so I would recommend that you use it without any fear. #### Reasons for choosing PostgreSQL Price and flexibility, besides the experience working with it. --- ### Object Relational Database Management - Overall rating: 4/5 - Reviewer: Nifal N. - Verified reviewer: Yes - Industry: Information Technology and Services - Company size: 11-50 employees - Product usage: Used weekly for less than 6 months - Reviewed: January 2022 - Review source details: This review was submitted organically. No incentive was offered #### Ratings breakdown - Ease of use: 3/5 - Value for money: 4/5 - Customer support: 3/5 - Functionality: 4/5 #### Pros The way it shows schema wise objects and it compliant with SQL standard. #### Cons When it compared with other similar products its really difficult to find documents and videos to get help. #### Reasons for switching to PostgreSQL Actually my company decided this switch for there new software product. --- ### PostgreSQL Review - Overall rating: 5/5 - Reviewer: Verified Reviewer - Verified reviewer: Yes - Industry: Renewables & Environment - Company size: 11-50 employees - Product usage: Used daily for less than 12 months - Reviewed: September 2023 - Review source details: This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you. I highly recommend PostgreSQL, i have been using it at work and at the university #### Ratings breakdown - Ease of use: 5/5 - Value for money: 5/5 - Customer support: 3/5 - Functionality: 4/5 #### Pros First, it is open source and wildly used database, it is customizable and scalable #### Cons It does not contain a customer service because it is open source but of course you can find ur answers on the internet and platforms --- ### "PostgreSQL: A Robust and Reliable Database Solution" - Overall rating: 5/5 - Reviewer: Rishikumar P. - Verified reviewer: Yes - Industry: Computer Software - Company size: Self-Employed - Product usage: Used daily for less than 2 years - Reviewed: January 2023 - Review source details: This review was submitted organically. No incentive was offered Overall, my experience with PostgreSQL has been positive. It is a robust and reliable database system with advanced features for data management and analysis. The active community and comprehensive documentation make it easy to get started and the software is well-suited for a wide range of applications. #### Ratings breakdown - Ease of use: 5/5 - Value for money: 5/5 - Customer support: 4/5 - Functionality: 5/5 #### Pros PostgreSQL is a powerful and flexible open-source relational database management system. It offers high performance, rich SQL support, and advanced data types, such as arrays, hstore, and JSON. It can be used for a wide range of use cases, from small web applications to large enterprise systems. The active community provides a wealth of resources, tutorials, and support, which helps to easily create custom functions and operators. It also allows scalability, which makes it suitable for handling an increasing amount of data and users. Additionally, it supports ACID properties, which ensures data consistency and integrity in the database. Overall, PostgreSQL is an excellent choice for businesses looking for a powerful and flexible relational database management system, it offers great features that make it a great tool for most of use cases. #### Cons PostgreSQL is a powerful and versatile open-source database system that offers many advanced features for data management and analysis. Its robust SQL engine and built-in support for advanced data types make it a great choice for a wide range of applications. While the software can be a bit complex to set up and manage for beginners, the comprehensive documentation and active community make it easy to get started. Overall, I highly recommend PostgreSQL for anyone looking for a reliable and feature-rich database solution. --- ### "PostgreSQL: Ease and Efficiency in Application Development - Overall rating: 5/5 - Reviewer: daniel c. - Verified reviewer: Yes - Industry: Computer & Network Security - Company size: 51-200 employees - Product usage: Used weekly for less than 12 months - Reviewed: October 2023 - Review source details: This review was submitted organically. No incentive was offered From the first time I tried this software, I knew it stood out. All my databases now reside in it, not just for its efficiency, but for the sense of security and trust it gives me. Even when running it on less powerful machines, and experiencing some slowdowns, it has always delivered on its promises. I've been with it for nearly 7 months and have no regrets; it's been a solid choice for my projects #### Ratings breakdown - Ease of use: 5/5 - Value for money: 5/5 - Customer support: 5/5 - Functionality: 5/5 #### Pros I started using it because of my university and I was instantly charmed by how user-friendly the software is with its tools. I have two databases and it has never let me down. Its security is good and the information doesn't get lost. #### Cons Throughout my journey with PostgreSQL, I've had moments of love and frustration. While I adore its sturdiness and the features it offers, I've stumbled a couple of times with its performance in specific scenarios. Sometimes, it feels like that reliable old car you know inside out, but occasionally takes a bit longer to start. Despite the minor hiccups, it remains my go-to companion when I want my data to be safe and well looked after #### Reasons for switching to PostgreSQL more tools and easier use --- ### A very reliable, steady and no cost RDBMS - Overall rating: 4/5 - Reviewer: Usman A. - Verified reviewer: Yes - Industry: Retail - Company size: 11-50 employees - Product usage: Used daily for more than 2 years - Reviewed: September 2022 - Review source details: This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you. Overall experience on PostgreSQL has been good. A very low maintenance is require which is definitely a plus point. Also, see many medium to big size organization using this RDBMS for their mission critical application. #### Ratings breakdown - Ease of use: 4/5 - Value for money: 5/5 - Customer support: 4/5 - Functionality: 4/5 #### Pros Steady and reliable. Open source and doesn't require licensing Very less performance tuning is required #### Cons Don't find native ETL Tool Yet to see functionality of data marts and data warehousing #### Reasons for choosing PostgreSQL Open source, low maintenance --- ### PostgreSQL for Database - Overall rating: 5/5 - Reviewer: Verified Reviewer - Verified reviewer: Yes - Industry: Information Technology and Services - Company size: 1001-5000 employees - Product usage: Used daily for less than 12 months - Reviewed: December 2023 - Review source details: This review was submitted organically. No incentive was offered #### Ratings breakdown - Ease of use: 5/5 - Functionality: 5/5 #### Pros PostgreSQL is one of the most popular choice for Database now and it becomes more popular as many people and companies starting to use it. PostgreSQL has great features and performances, so I'd like to recommend PostgreSQL to those who needs a reliable RDBMS. #### Cons One thing that i dislike from PostgreSQL is it's hard to setup and install PostgreSQL at the beginning. Especially the syntax and command that PostgreSQL use. --- ### Excellent alternative to MySQL when you need more flexibility - Overall rating: 5/5 - Reviewer: Alfredo J. - Verified reviewer: Yes - Industry: Information Technology and Services - Company size: 2-10 employees - Product usage: Used daily for more than 2 years - Reviewed: June 2022 - Review source details: This review was submitted organically. No incentive was offered I needed a very efficient database that could handle a huge amount of records, views and access for a data-scraping and analysis project. I was able to very easily do this with a combination of python for data processing, tableau for visualization and postgre-sql for the database. It has been running for a few years without any hiccups and with great efficiency. #### Ratings breakdown - Ease of use: 4/5 - Value for money: 5/5 - Functionality: 5/5 #### Pros User management is very flexible and the query language support many things that MySQL does not out-of-the-box, more inline with oracle database. #### Cons Not as ubiquitous as MySQL so initial setup and admin is slightly more complicated. --- ### Best RDBMS for microservice structure - Overall rating: 4/5 - Reviewer: Pinki K. - Verified reviewer: Yes - Industry: Computer Software - Company size: 51-200 employees - Product usage: Used daily for more than 2 years - Reviewed: February 2023 - Review source details: This review was submitted organically. No incentive was offered Its been very good experience to use postgres. Very easy and very effective to manage data. As we have microservice architecture so need lots of database of individual services and with postgres we reduces cost of licensing. #### Ratings breakdown - Ease of use: 4/5 - Value for money: 5/5 - Customer support: 2/5 - Functionality: 4/5 #### Pros This is very easy to use and manages. Easy to handle JSON data type and having lots of data type available. Table partitions available for increasing performance. #### Cons Creating store procedure are still very complex and not good as compare to sql server. --- ### PostgreSQL - Overall rating: 5/5 - Reviewer: Malik W. - Verified reviewer: Yes - Industry: Research - Company size: 10000+ employees - Product usage: Used daily for less than 2 years - Reviewed: May 2022 - Review source details: This review was submitted organically. No incentive was offered #### Ratings breakdown - Ease of use: 5/5 - Functionality: 5/5 #### Pros It is a good Software for those who need SQL. #### Cons It can sometimes take a while to compile and have errors like all programming softwares. --- ### World class DB management and Open Source tool - Overall rating: 4/5 - Reviewer: Parul G. - Verified reviewer: Yes - Industry: Pharmaceuticals - Company size: 10000+ employees - Product usage: Used daily for more than 2 years - Reviewed: January 2023 - Review source details: This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you. Flexible, robust with advanced features. Complex DB dashboard. #### Ratings breakdown - Ease of use: 5/5 - Value for money: 4/5 - Customer support: 4/5 - Functionality: 5/5 #### Pros The ease of use sets it apart from other tools #### Cons The DB performance , lack of in depth documentation and lack of dedicated customer support to get quick help on critical production loads. --- ### Best Relational Database and it's Open Source - Overall rating: 4/5 - Reviewer: Samuel A. - Verified reviewer: Yes - Industry: Telecommunications - Company size: 2-10 employees - Product usage: Used daily for less than 2 years - Reviewed: May 2023 - Review source details: This review was submitted organically. No incentive was offered I've found PostgreSQL to be a powerfully efficient and secure tool for managing relational databases #### Ratings breakdown - Ease of use: 4/5 - Value for money: 3/5 - Customer support: 5/5 - Functionality: 5/5 #### Pros PostgreSQL excels in its strong documentation, large data handling, and exceptional security. #### Cons Challenges with screen navigation, JSON handling, and data comparison can make it less user-friendly --- ### The most advanced open-source database management system - Overall rating: 5/5 - Reviewer: George S. - Verified reviewer: Yes - Industry: Computer Software - Company size: 2-10 employees - Product usage: Used daily for more than 2 years - Reviewed: August 2019 - Review source details: This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you. We use PostgreSQL in most of our projects as a primary backend and our experience has been positive. #### Ratings breakdown - Ease of use: 4/5 - Functionality: 5/5 #### Pros PostgreSQL is one of the most feature-rich, powerful and advanced open-source database management systems. Though this power comes at a cost. Using PostgreSQL in the best possible way takes some time. PostgreSQL is a real beast and it takes time before one becomes fully familiar with it. #### Cons Even with all the power that PostgreSQL gives, there are certain things that are missing. For example, until the latest versions there was no support for partitioning. Lack of a great graphic admin tool is a con in my opinion. Yes, it's possible to use (and we do) third party tools like DBeaver but a great database system must simply have its own admin GUI. --- ### PostgreSQL as application database - Overall rating: 5/5 - Reviewer: Arik B. - Verified reviewer: Yes - Industry: Computer Software - Company size: 2-10 employees - Product usage: Used daily for more than 2 years - Reviewed: December 2019 - Review source details: This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you. We use PostgreSQL as our system database for the software we develop, we find it reliable, robust and with great performance, we use both PHP and C++ to access the dataabse. #### Ratings breakdown - Ease of use: 4/5 - Functionality: 5/5 #### Pros PostgreSQL is a full featured SQL server solution. it is free and open-source, PostgreSQL can be installed on many different platform like Linux, Windows, macOS and other. being open-source if has lots of contribute tools from the open-source community providing wide range solutions, PostgreSQL is also available in the cloud from all the major providers. #### Cons Management is less comfortable and some settings needs to be done in PostgreSQL configuration files, also database schema management tool is not so comfortable, but you can use 3rd party tools for that also #### Reasons for choosing PostgreSQL Being free and open-source give us better control over platform selection, it also allow us to give our customers solution at lower costs, as the customer looks at the overall cost of the solution and the need to buy database server license cause the solution to cost much more. scaling is also simpler from license perspective. --- ### Open source object-relational database management system for Web Developers - Overall rating: 5/5 - Reviewer: Ashish A. - Verified reviewer: Yes - Product usage: Used daily for less than 2 years - Reviewed: January 2018 - Review source details: This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you. #### Ratings breakdown - Ease of use: 4/5 - Value for money: 5/5 - Customer support: 4/5 - Functionality: 4/5 #### Pros PostgreSQL or simply Postgres implements the SQL and advanced SQL standard very well. It can handle workloads ranging from small web applications to large data warehousing with many parallel users. Postgres provides a easy to use tool called pgAdmin to interact with and manipulate database. It provides support for complex data types like (multi-dimensional) Array, Json, user-defined types. PostgreSQL provides higher number of connections at cheap price. It support all types of indexing for faster retrieval of data. In my company we replaced our database server from MySQL to PostgreSQL because of PostgreSQL higher db connections connections in cheaper price as compared to MYSQL. It is also available free of cost till 10,000 rows on Heroku. #### Cons PostgreSQL query syntax for some complex queries like array, json, string functions and case operator are bit complicated to write . Installation and configuration of PostgreSQL is not as easy as MySQL. Documentation is not as good as compared to MySQL and it is bit harder to search for help regarding some complex queries and database functions on google. Replication is not yet as well implemented as in MySQL. --- ### The best SQL and open source database. - Overall rating: 4/5 - Reviewer: Samantha N. - Verified reviewer: Yes - Product usage: Used weekly for more than 2 years - Reviewed: June 2018 - Review source details: This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you. Because range queries are integrated, it is much less effort to query compared to MySQL. #### Ratings breakdown - Ease of use: 4/5 - Value for money: 4/5 - Customer support: 5/5 - Functionality: 4/5 #### Pros It is fast and reliable, manages inserts and updates of tens of thousands of lines impeccably. PostgreSQL implements SQL standards very well and supports advanced SQL stuff, the PostSQL database works very well with hibernation HPA and we have been using it extensively together with the Spring framework, the consistency is also very good, you will never lose data or lose data. JSON support in the latest version has made things easier for us now, since we do not need to migrate the schema as always before. Finally, the backup methods through pg_dump are easy to use and ensure that you can always back up before any major changes. #### Cons It is not very intuitive, in my opinion, and I think those problems must be solved before I can get the kind of traction that MySQL has, also more open sources admit mysql but not postgres. These are some of the problems with postgres. --- ### Best database for RoR apps - Overall rating: 5/5 - Reviewer: Alvaro I. - Verified reviewer: Yes - Industry: Internet - Company size: 51-200 employees - Product usage: Used daily for more than 2 years - Reviewed: June 2018 - Review source details: This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you. #### Ratings breakdown - Ease of use: 5/5 - Value for money: 5/5 - Customer support: 5/5 - Functionality: 5/5 #### Pros - Scalability is a key factor in a database and PosgreSQL handle this large amounts of data without breaking a sweat. - Rich text queries runs smoothly as well. - The integration with ActiveRector is awesome!! - I think is the most famous free database in the market right now, so that means that when an error happen you will have a good community that will have your back. #### Cons - There isn't many thing to say about PosgreSQL, I will say that the most traumatic part is the installation but once you have it up and running this should be a walk in the park for a developer to use. ## More reviews [Next reviews](https://www.softwareadvice.com/rdbms/postgresql-profile/reviews/?page=2) --- PostgreSQL Reviews, Pros and Cons - 2026 Software Advice