Try our new research platform with insights from 80,000+ expert users

MariaDB vs PostgreSQL comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Oct 8, 2024
 

Categories and Ranking

MariaDB
Ranking in Open Source Databases
4th
Average Rating
8.2
Reviews Sentiment
7.1
Number of Reviews
59
Ranking in other categories
Relational Databases Tools (5th)
PostgreSQL
Ranking in Open Source Databases
2nd
Average Rating
8.4
Reviews Sentiment
7.9
Number of Reviews
125
Ranking in other categories
Vector Databases (9th)
 

Mindshare comparison

As of November 2024, in the Open Source Databases category, the mindshare of MariaDB is 11.0%, down from 16.4% compared to the previous year. The mindshare of PostgreSQL is 25.6%, up from 23.6% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Open Source Databases
 

Featured Reviews

KumarManish - PeerSpot reviewer
Easy to deploy, cost-effective, and integrates seamlessly with other products
We had planned for an RDBMS version and not NoSQL. We use MariaDB Galera Cluster. It's a good product. It is cheap, scalable, performs well, and is efficient. We use GCP’s BigQuery for machine learning. We must follow the best practices of the tool. We missed some best practices like the storage engine and InnoDB. It was very difficult to identify why we were having performance issues. Then, we realized that some of our tables were still on MyISAM, the default storage engine. When we switched it back to the InnoDB, it was very smooth. InnoDB is the recommended one. We must follow the best practices given in the documentation during the initial setup. Overall, I rate the product a nine out of ten.
AdityaSharma3 - PeerSpot reviewer
Transaction processes are fast and good replication capability
Use cases include querying data warehouses and databases to fetch data for clients already working on PostgreSQL.  We also use Postgres for building reports It's a transactional database, so we use Postgres for most of our reporting. That's where it's helping. The query speed is fast, and the…

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"One of the great features of MariaDB is its scalability. It's easy to handle even with large databases."
"MariaDB performs well as the backend database for our cloud-based telephony solution."
"It's a very easy product to set up."
"MariaDB is a fast and flexible tool."
"The solution is very easy to implement."
"Installation is straightforward."
"The performance is very good."
"I would say that for most use cases it works fine."
"The tool is user-friendly."
"The solution has many valuable features such as it easy to use and the interface is intuitive."
"Scalable, stable, and easy to manage database system, with a straightforward installation."
"What I like is that it's quite powerful in terms of performance."
"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."
"Postgres has some functions called JSONB aggregators or other aggregators, which are quite useful."
"It has completely met our needs. It works, and it is robust. We haven't had any problems with what PostgreSQL does for us and the way it does it. That's why we've been using it for so long. We understand it, and it does the job."
"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."
 

Cons

"One feedback I can quickly provide is the need for a robust IDE for MongoDB. The existing PHP admin console doesn't meet the client's requirements effectively."
"MariaDB could improve by adding support for non-relational structures and new data types."
"I am editing."
"The only potential area for improvement could be the pricing model, which might benefit from being more flexible or a bit cheaper."
"There is room for improvement in terms of security."
"The PL/SQL performance is slow if you have big batch jobs running overnight."
"A well-known issue for a lot of different users is associated with write-intensive applications."
"It does not have tools for debugging procedures and functions."
"PostgreSQL’s performance could be improved."
"I'm not really able to customize it."
"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."
"A better graphic user-interface would be nice to see."
"The price could be better."
"The pricing could be better."
"We have to set up event API, which takes a lot of events from the user."
"PostgreSQL is a stable system, but from a security point of view, it still needs improvement."
 

Pricing and Cost Advice

"We use the solution's free version."
"When it comes to MariaDB, it should have a more cost-effective license."
"The tool is open-source."
"This is an open-source product, which can be used free of charge."
"MariaDB is available for free."
"The product is not expensive."
"I rate the product's price a three on a scale of one to ten, where one is low price, and ten is high price since there are some support costs involved, even though it isn't an open-source solution."
"MariaDB is an open-source software, meaning I don't need to pay for the product."
"Our company pays for it. There are free versions available, but for advanced features, you obviously have to pay."
"It could be much cheaper. If you would like to build an application on Amazon today, PostgreSQL is the standard database with Redshift. If you want other databases, you can add them, but PostgreSQL is the basis of everything. It's a question of money, that's it."
"This solution can offer a cheaper choice for customers since it is open-source."
"It is free. There is no license on it."
"We are using the free version of PostgreSQL."
"It is also open-source so it is free."
"The need for our customers to pay for licences is contingent on their projects and budgets."
"It is free. In terms of operating costs, it basically needs the same platform on which Oracle runs."
report
Use our free recommendation engine to learn which Open Source Databases solutions are best for your needs.
816,406 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Computer Software Company
15%
Financial Services Firm
10%
Educational Organization
9%
Manufacturing Company
9%
Computer Software Company
16%
Financial Services Firm
12%
Manufacturing Company
8%
Comms Service Provider
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What do you like most about MariaDB?
The integration with other products is seamless.
What is your experience regarding pricing and costs for MariaDB?
I have found the price of commercial MariaDB to be pretty steep, although not as high as Oracle. Customers often prefer the Community Edition because it's free.
What needs improvement with MariaDB?
The only potential area for improvement could be the pricing model, which might benefit from being more flexible or a bit cheaper.
How does Firebird SQL compare with PostgreSQL?
PostgreSQL was designed in a way that provides you with not only a high degree of flexibility but also offers you a cheap and easy-to-use solution. It gives you the ability to redesign and audit yo...
What do you like most about PostgreSQL?
It's a transactional database, so we use Postgres for most of our reporting. That's where it's helping.
What is your experience regarding pricing and costs for PostgreSQL?
The tool is free of cost. For now, it's not about making money. But once we perfect it, we can offer it to customers willing to pay for support and other services. Most of my deployments are free.
 

Comparisons

 

Learn More

Video not available
Video not available
 

Overview

 

Sample Customers

Google, Wikipedia, Tencent, Verizon, DBS Bank, Deutsche Bank, Telefónica, Huatai Securities
1. Apple 2. Cisco 3. Fujitsu 4. Instagram 5. Netflix 6. Red Hat 7. Sony 8. Uber 9. Cisco Systems 10. Skype 11. LinkedIn 12. Etsy 13. Yelp 14. Reddit 15. Dropbox 16. Slack 17. Twitch 18. WhatsApp 19. Snapchat 20. Shazam 21. SoundCloud 22. The New York Times 23. Cisco WebEx 24. Atlassian 25. Cisco Meraki 26. Heroku 27. GitLab 28. Zalando 29. OpenTable 30. Trello 31. Square Enix 32. Bloomberg
Find out what your peers are saying about MariaDB vs. PostgreSQL and other solutions. Updated: October 2024.
816,406 professionals have used our research since 2012.