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.
"It's a very easy product to set up."
"Great monitoring and performance stability."
"It is a scalable solution. It easily scales up and scales down."
"One of the great features of MariaDB is its scalability. It's easy to handle even with large databases."
"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."
"The solution is very easy to implement."
"It's easy to set up."
"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."
"Scalable, stable, and easy to manage database system, with a straightforward installation."
"PostgreSQL is very powerful, easy to manage, and has many features."
"The solution is quite stable."
"We use the solution to store tables. It is stable and performs well."
"Clustering will be the number 1 feature. It is also open-source so it is free. It can also be clustered, to allow fault tolerance."
"The solution is scalable, it is very good."
"It is easy to use."
"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."
"Could have more integration with user platforms."
"MariaDB should provide HA and archive logging... I haven't had the opportunity to use the features provided by the solution since I don't know how to see them."
"There is room for improvement in terms of security."
"The maintenance and performance could be a bit better."
"The dashboard and pricing need improvement."
"Master-master replication is something that needs to be simplified."
"There is not much support available."
"Lacks time series data and additional driving support would be helpful."
"It needs more integration."
"It still needs to be more mature and have some backup feature. We are normally dealing with Oracle's data, and we have very strong online tools to back up the data and do other things. PostgreSQL still needs to do more in this area as well as in the high availability area. There are many external tools that you can use for PostgreSQL's high availability, but there is no embedded tool within PostgreSQL for high availability. It could have a feature similar to Oracle for working on a distributed system. It can have some scripts to improve the monitoring and some tools to do performance analysis. We have a workaround for most of such requirements except for the support for a distributed system, which is very difficult to have. This area should be included in the core of the database itself."
"PostgreSQL doesn't have a feature for temporal SQL, which is useful for gathering versions of data. This feature should be included in PostgreSQL. This feature is available in MariaDB, SQL Server, Oracle Database, and DB2."
"If it was free to use, it would be the perfect solution."
"We often find the solution's datetime datatype challenging."
"The solution needs to improve the query, documentation, and JSON data functionality."
"As PostgreSQL is an open-source product, you do have to do a bit more configuration and management yourself."
"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."
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.