Abstract

PILICITA GARRIDO, Anabel; BORJA LOPEZ, Yolanda  and  GUTIERREZ CONSTANTE, Gonzalo. Performance MariaDB and PostgreSQL. RCTU [online]. 2020, vol.7, n.2, pp.9-16. ISSN 1390-7697.  https://doi.org/10.26423/rctu.v7i2.538.

The storage of information in databases is an important issue for every organization today. They are the Database Management Systems known as SGDB in charge of hiding the complexity that the administration of the databases entails. It is common that millions and millions of data are stored every day even more because today there are new trends and demands for the processing of large volumes of data at high speed. Therefore, it is essential that the DBMS have a correct performance to face these new demands. This work shows the results obtained when performing performance tests on the MariaDB and PostgreSQL Database Management Systems, applying the three-layer architecture for the test scenarios. Both DBMS are powerful and widely used by different systems. The results obtained are related to the number of requests per second processed by these systems. In this case, MariaDB was superior to PostgreSQL as the number of users that performed in different scenarios increased thanks to its search engines that generate better data processing speeds

Keywords : Database; SQL; DBMS; performance.

        · abstract in Spanish     · text in Spanish     · Spanish ( pdf )