A performance analysis of the DBMS - MySQL vs PostgreSQL

被引：0
|
作者：
Andjelic, Svetlana [1 ]
Obradovic, Slobodan [2 ]
Gacesa, Branislav [3 ]
机构：
[1] Railway College of Vocational Studies, Belgrade
[2] Megatrend University, Belgrade
[3] Telekom. Srpske A. D., SRJ Internet Srpske, Banja Luka
来源：
Communications - Scientific Letters of the University of Žilina | 2008年 / 10卷 / 04期
关键词：
ACID; MySQL; Open source DBMS; PostgreSQL;
D O I：
10.26552/com.c.2008.4.53-57
中图分类号：
学科分类号：
摘要：
Modern communications among business subjects imply an exchange of a lot of data and information. To enhance that process in all its aspects, electronic data storing and processing is mandatory and enabled by an application of a DBMS (Date Base Managment System). This paper shows the performances analysis of the two most popular open source DBMSs ?MySQL and PostgreSQL- First, some characteristics of these DBMSs are shortly described. Then the applied procedure of the performed testing is described. That is, the query (select, insert, delete and order by) execution times were measured for the both DBMSs mentioned, and the results shown in tabular and graphical forms. The goal of this paper is to make the choice of an adequate DBMS easier for future users.
引用
收藏
页码：53 / 57
页数：4
相关论文
共 50 条
  • [1] A Performance Benchmark for the PostgreSQL and MySQL Databases
    Salunke, Sanket Vilas
    Ouda, Abdelkader
    FUTURE INTERNET, 2024, 16 (10)
  • [2] Facebook MySQL Performance vs MySQL Performance
    Dawodi, Mursal
    Hedayati, Muhammad Hadi
    Baktash, Jawid Ahmad
    Erfan, Abdul Latif
    2019 IEEE 10TH ANNUAL INFORMATION TECHNOLOGY, ELECTRONICS AND MOBILE COMMUNICATION CONFERENCE (IEMCON), 2019, : 103 - 108
  • [3] Asynchronous Replication in Microsoft SQL Server, PostgreSQL and MySQL
    Truica, Ciprian-Octavian
    Boicea, Alexandru
    Radulescu, Florin
    2013 INTERNATIONAL CONFERENCE ON CYBER SCIENCE AND ENGINEERING (CYBERSE 2013), 2013, : 50 - 55
  • [4] Algorithm for volumetric projection in PostgreSQL and Oracle DBMS
    Sepulveda-Cordon, Omar A.
    Vega-Martinez, Jhon A.
    Gonzalez-Sanabria, Juan S.
    2019 IEEE CHILEAN CONFERENCE ON ELECTRICAL, ELECTRONICS ENGINEERING, INFORMATION AND COMMUNICATION TECHNOLOGIES (CHILECON), 2019,
  • [5] Decision Tree Algorithm Moderately Coupled to PostgreSQL DBMS
    Timaran-Pereira, Ricardo
    Chaves-Torres, Anivar
    Ordonez-Erazo, Hugo
    REVISTA FACULTAD DE INGENIERIA, UNIVERSIDAD PEDAGOGICA Y TECNOLOGICA DE COLOMBIA, 2023, 32 (66):
  • [6] Performance analysis of NoSQL and relational databases with MongoDB and MySQL
    Jose, Benymol
    Abraham, Sajimon
    MATERIALS TODAY-PROCEEDINGS, 2020, 24 : 2036 - 2043
  • [7] 120Development of a parallel Database Management System on the Basis of Open-Source POSTGRESQL DBMS
    Pan, C. S.
    Zymbler, M. L.
    BULLETIN OF THE SOUTH URAL STATE UNIVERSITY SERIES-MATHEMATICAL MODELLING PROGRAMMING & COMPUTER SOFTWARE, 2012, (12): : 112 - 120
  • [8] Evaluation and Selection of Tools for Data Migration from Non-Spatial to Spatially Referenced Software - A Case Study Migration from MySQL to PostgreSQL
    Chandramali, E. A. G.
    Wijesekera, N. T. S.
    ENGINEER-JOURNAL OF THE INSTITUTION OF ENGINEERS SRI LANKA, 2012, 45 (02): : 41 - 48
  • [9] A Comparative Study: MongoDB vs. MySQL
    Gyorodi, Cornelia
    Gyorodi, Robert
    Pecherle, George
    Olah, Andrada
    2015 13TH INTERNATIONAL CONFERENCE ON ENGINEERING OF MODERN ELECTRIC SYSTEMS (EMES), 2015,
  • [10] Database Encryption Performance Impact on PostgreSQL and MongoDB
    Costa, Marcelo
    Rodrigues, Margarida
    Baptista, Pedro
    Wanzeller, Cristina
    Martins, Pedro
    Abbasi, Maryam
    MARKETING AND SMART TECHNOLOGIES, VOL 1, 2022, 279 : 121 - 127
12345