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.
"The product has good documentation and you can find many examples online."
"MariaDB is a user-friendly solution. Performance wise, it's better than SQL. With SQL, I would need to write a number of queries. In contrast, MariaDB is light."
"What I like best about MariaDB is that it is open-source and reliable."
"I haven't faced any technical issues with the product, and it works fine."
"I would say that for most use cases it works fine."
"The most valuable feature of MariaDB is that it is open-source and we can easily migrate from other databases, such as Oracle to MariaDB."
"From a customer perspective, MariaDB is a good choice for cluster configuration. It's also easy to operate and cheap."
"The solution is very stable. It was originally built under MySQL. It has a similar level of stability."
"The initial setup is quick and easy."
"Scalable, stable, and easy to manage database system, with a straightforward installation."
"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."
"The performance is good."
"Postgres is rock solid when deployed according to best practices as documented by the PostgreSQL community. When it's installed correctly, PostgreSQL is an enterprise-grade solution."
"It's a useful solution, that can be widely used."
"I like that you can move any relational database from Oracle to PostgreSQL. I also like that it's pretty stable."
"The product is easy to use and works fast for relational databases."
"The PL/SQL performance is slow if you have big batch jobs running overnight."
"With respect to clustering and the master-slave configuration, sometimes the slave goes out of synch."
"Maria DB has to improve from a management perspective."
"Replication could be better, and it's not so simple. It would be better if they had a replication server. It would make things a lot easier. You need to have that replication server, but not in the same server farm. Then there will be a bit of latency between both because you should have one in one city and another one in a different city. That kind of solution should be more baked into every single database today. Mirroring the database in a live environment where any record written on the production server replicates instantly across the fiber on the other server wasn't easy. Many people don't even bother with that, and they just run one server."
"It would be good if they can maybe improve the mass import in the database. Currently, for importing a large number of data, we create a CSV file and upload all the things in the system. The system does not activate them by default. We have to do this manually. This may be due to the version we are using, but this is something we would like to see improved."
"Lacks time series data and additional driving support would be helpful."
"The maintenance and performance could be a bit better."
"The difficult part related to the product stems not from the tool itself but is related to learning how to implement the product in the right way without creating any wrong configuration that could cause security issues or performance issues."
"It would be good to have machine learning functionality in this solution, similar to Microsoft SQL Server and other solutions. Machine learning capability for a basic level or a common user would be useful. It can also have good reporting capabilities."
"PostgreSQL uses high memory compared to its counterparts when a highly demanding load is involved, especially one that makes many concurrent connections to the database."
"The user interface could be a bit better."
"I'm not really able to customize it."
"It could be improved by using parallelization. You want basically, distributed computing."
"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."
"Integration with other platforms could be improved."
"I'd like to see better memory management. I think that that's one of the few areas that Postgres does not handle as well as MySQL does or did."
MariaDB is ranked 3rd in Open Source Databases with 30 reviews while PostgreSQL is ranked 2nd in Open Source Databases with 6 reviews. MariaDB is rated 8.0, while PostgreSQL is rated 8.6. The top reviewer of MariaDB writes "Allows for fetching data from multiple correlated or related databases in a single query, user-friendly and easy to handle". On the other hand, the top reviewer of PostgreSQL writes "Easy to manage, good integration, powerful plugins, improves performance, and saves on storage space". MariaDB is most compared with SQL Server, Oracle Database, MySQL, Firebird SQL and Percona Server, whereas PostgreSQL is most compared with Firebird SQL, EDB Postgres Advanced Server, MySQL, SQLite and YugabyteDB. 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.