Skip to content
Related Articles

Related Articles

Difference between MariaDB and PostgreSQL
  • Last Updated : 23 Jun, 2020

1. MariaDB :
MariaDB is an open source relational database management system (RDBMS) that is a compatible drop-in replacement for the widely used MySQL database technology. It is developed by MariaDB Foundation and initially released on 29 October 2009. MariaDB has a significantly high number of new features, which makes it better in terms of performance and user-orientation than MySQL.

2. PostgreSQL :
PostgreSQL is a powerful, open-source Object-relational database system. It provides good performance with low maintenance efforts because of its high stability. PostgreSQL was the first DBMS that implemented multi-version concurrency control (MVCC) feature.



Difference between MariaDB and PostgreSQL :

S.NO.MARIADBPOSTGRESQL
1.Developed by MariaDB Corporation Ab and MariaDB Foundation on 2009.Developed By  PostgreSQL Global Development Group on 1989.
2.It is a MySQL application compatible open source RDBMS, enhanced with high availability, security, interoperability and performance capabilities.It is widely used open source RDBMS.
3.MariaDB is written in C and C++ languages.PostgreSQL is written in C languages.
4.The primary database model for MariaDB is Relational DBMS.Also the primary database model for PostgreSQL is Relational DBMS.
5.It has two Secondary database models – Document store and Graph DBMS.It has Document store as Secondary database models.
6.Server operating systems for MariaDB are FreeBSD, Linux, Solaris and Windows.Server operating systems for PostgreSQL are FreeBSD, HP-UX, Linux, NetBSD, OpenBSD, OS X, Solaris, Unix and Windows.
7.It supports Server-side scripting.It has user defined functions for Server-side scripts
8.Supported Partitioning method are – Horizontal partitioning, sharding with Spider storage engine and Galera cluster.In PostgreSQL, partitioning can be done by range, list and hash.
9.It support two replication methods – Master-master replication and Master-slave replication.It support only one replication methods – Master-master replication
10.It supports in-memory capabilities.It does not supports in-memory capabilities.

Attention reader! Don’t stop learning now. Get hold of all the important CS Theory concepts for SDE interviews with the CS Theory Course at a student-friendly price and become industry ready.

My Personal Notes arrow_drop_up
Recommended Articles
Page :