We performed a comparison between MariaDB vs PostgreSQL based on our users’ reviews in five categories. After reading all of the collected data, you can find our conclusion below.
Comparison Results: Both solutions are easy to deploy, have good features, an open-source version, good support, and a proven ROI. Which solution you choose will depend on what suits your company’s specific needs and requirements best.
"From the user's perspective, the performance of the columnar queries is very good in terms of the database when comparing it to the Oracle, and MySQL."
"From a customer perspective, MariaDB is a good choice for cluster configuration. It's also easy to operate and cheap."
"Easy to use and available in most environments."
"It is very simple to install, and the commands are exactly the same as MySQL."
"MariaDB can solve things better than MySQL. Maria DB has better performance than MySQL."
"It's easy to set up."
"I like the global transaction IDs (GTIDs) feature. It's quite reliable for replication between a master and a replica server, and it's a feature that MySQL also has but implemented differently."
"We use MariaDB for identity provider services. Most of the things that we are doing are deployed in the container mode. All such solutions require a database, and MariaDB is easier to use for these kinds of deployments."
"PostgreSQL is very easy to use. I have experience in Oracle SQL and PostgreSQL uses the same syntax which makes it is easy for me to develop."
"The solution is scalable, it is very good."
"We use the solution to store tables. It is stable and performs well."
"The solution provides complete support in terms of the SQL dialect and behaves nicely when it comes to transactions."
"Initial setup is simple."
"It is very scalable and comes with a bonus: no licensing issues as you scale with your databases."
"The main value is that it is open source, which means it is free. Our organization has the initiative to go to open source to cut down on cost. Oracle costs us $6 million a year right now, which is killing us, and Postgres costs nothing. So, there is a big push to go to Postgres."
"It's a useful solution, that can be widely used."
"I would like to see more compatibility going forward. This would help if there is a need to change databases."
"There is room for improvement in terms of security."
"The maintenance and performance could be a bit better."
"The stability could always continue to be improved upon."
"It should work across all fields like SQLite, as it is the basis of any application, even apps for phones and the like."
"Lacks time series data and additional driving support would be helpful."
"Document caching is an area of concern in the product, where improvements are required to help MariaDB improve on the previous queries as they are retained, and you can roll back to them."
"MariaDB could improve by adding support for non-relational structures and new data types."
"A better graphic user-interface would be nice to see."
"I'm not really able to customize it."
"PostgreSQL could improve by adding data warehousing tools."
"It is possible that in the newer version this has been addressed, but I would like the deployment in microservices architecture could be improved."
"If it was free to use, it would be the perfect solution."
"I find it difficult to get connectors on the tool. For example, .NET has only one free provider in PostgreSQL. I need to pay the provider if I need something more sophisticated features. Other languages like PHP and Java have good community support. We need community support for .NET."
"PostgreSQL could improve by providing a geographical solution for tracking trucks and people in the field. They might already have features similar to this and I have not found them. I haven't done research about this topic."
"The interface climate could be better."
MariaDB is ranked 4th in Open Source Databases with 52 reviews while PostgreSQL is ranked 2nd in Open Source Databases with 123 reviews. MariaDB is rated 8.2, while PostgreSQL is rated 8.4. The top reviewer of MariaDB writes "Easy to deploy, cost-effective, and integrates seamlessly with other products". On the other hand, the top reviewer of PostgreSQL writes " Real-time data capture optimizes database performance but Views create problems". MariaDB is most compared with SQL Server, Oracle Database, Firebird SQL, MySQL and Percona Server, whereas PostgreSQL is most compared with Firebird SQL, EDB Postgres Advanced Server, MySQL, SQLite and Chroma. See our MariaDB vs. PostgreSQL report.
See our list of best Open Source Databases vendors.
We monitor all Open Source Databases reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.