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 most valuable feature of MariaDB is that it is open-source and we can easily migrate from other databases, such as Oracle to MariaDB."
"MariaDB can solve things better than MySQL. Maria DB has better performance than MySQL."
"The most valuable feature of MariaDB is the replication mode."
"This solution is user-friendly."
"Installation is straightforward."
"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."
"It's a very easy product to set up."
"The stability of MariaDB is good, it has high availability."
"It is a pretty comprehensive database system. Its performance is good, and it does what it is supposed to do. It also integrates very well."
"The PostgreSQL database is similar to the SQL Server but has a slightly different technology that has similar resources as well. If the customer has the confidence using SQL Server, they will be fairly comfortable using this solution."
"It is easy to install and easy to manage. There is no license on it, so it is free. There is high compatibility with Oracle, and there are many tools for the migration of data from Oracle to Postgre."
"The product is quite flexible."
"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."
"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 community support and the open-source community for it are good."
"The most valuable features are the price, stability, it is scalable and is used by our clients in small business environments, and it is a simple product to use."
"There is room for improvement in terms of security."
"MariaDB's GUI is an area with certain shortcomings where improvements are required."
"The price could be less expensive."
"The dashboard and pricing need improvement."
"The GUI could be improved a bit. The user interface needs to be improved."
"It's not very stable. It needs improvement."
"When we have had issues with accidental computer shutdown or a power outage, our MariaDB database was corrupted."
"I'd like to see improved materialized views, like the ability to save select queries. This feature is missing in MariaDB compared to other relational databases like Oracle and SQL Server."
"I'm not really able to customize it."
"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."
"PostgreSQL could improve by adding data warehousing tools."
"There are several features I would like to improve that aren't working as expected. It's likely that the latest version is doing something that was missed in the previous versions. For example, the output parameters — the stored procedures — is something new in PostgreSQL that Firebird has already had for a long time."
"As PostgreSQL is an open-source product, you do have to do a bit more configuration and management yourself."
"There are some products out there that have a slightly different method of implementation for the SQL language. Some of those are slightly better in some areas, and PostgreSQL is slightly better in some areas. I would probably like to match all of those products together. It is just down to the functionality. For example, Oracle has a number of options within SQL that are outside of what you would class as the SQL standard. PostgreSQL misses some of those, but PostgreSQL does other things that are better than what Oracle does. I would like to merge those two products so that there is a certain amount of functionality in a single product."
"We often find the solution's datetime datatype challenging."
"A better graphic user-interface would be nice to see."
MariaDB is ranked 3rd in Open Source Databases with 51 reviews while PostgreSQL is ranked 2nd in Open Source Databases with 120 reviews. MariaDB is rated 8.2, while PostgreSQL is rated 8.6. The top reviewer of MariaDB writes "Simultaneously use active server capabilities but lacks the maturity ". On the other hand, the top reviewer of PostgreSQL writes " A scalable and stable database for transactional purposes". 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 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.