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 条

[21] Relative Performance of Various Types of Repositories for MySQL Archive Backup and Restore Operations
Petrov, Pavel
Kuyumdzhiev, Ivan
Dimitrov, Georgi
Kremenska, Adelina
INTERNATIONAL JOURNAL OF ONLINE AND BIOMEDICAL ENGINEERING, 2022, 18 (13) : 152 - 159
[22] Architecture and Performance Characteristics of a PostgreSQL Implementation of the TPC-E and TPC-V Workloads
Bond, Andrew
Johnson, Douglas
Kopczynski, Greg
Taheri, H. Reza
PERFORMANCE CHARACTERIZATION AND BENCHMARKING, 2014, 8391 : 77 - 92
[23] A Comparative Study Between the Capabilities of MySQl Vs. MongoDB as a Back-End for an Online Platform
Gyorodi, Cornelia
Gyorodi, Robert
Olah, Ioana Andrada
Bandici, Livia
INTERNATIONAL JOURNAL OF ADVANCED COMPUTER SCIENCE AND APPLICATIONS, 2016, 7 (11) : 73 - 78
[24] Performance Comparison for Data Storage-Db4o and MySQL Databases
Kulshrestha, Sudhanshu
Sachdeva, Shelly
2014 SEVENTH INTERNATIONAL CONFERENCE ON CONTEMPORARY COMPUTING (IC3), 2014, : 166 - 170
[25] Research and Design of the High-performance Cluster Architecture Based on the MySQL and NoSQL
Zhang, YongQiang
Li, WenMing
ADVANCED MATERIALS AND ITS APPLICATION, 2012, 460 : 313 - 316
[26] An Empirical Performance Comparison between MySQL and MongoDB on Analytical Queries in the COMEX Database
Gomes, Augusto
Lopes, Vitor
Ribeiro, Edward
Lima, Jorge
Costa, Wagner
Garcia, Luis
Holanda, Maristela
PROCEEDINGS OF 2021 16TH IBERIAN CONFERENCE ON INFORMATION SYSTEMS AND TECHNOLOGIES (CISTI'2021), 2021,
[27] Analysis of Electric Current by Using MySQL Database on Web Server for Machine Performance Evaluation: A Case Study of Air Conditioning System
Sriratana, Witsarut
Khagwian, Vittaya
Satthamsakul, Sutham
2020 20TH INTERNATIONAL CONFERENCE ON CONTROL, AUTOMATION AND SYSTEMS (ICCAS), 2020, : 437 - 442
[28] A comparative study between the capabilities of MySQL and ClickHouse in low-performance Linux environment
Wickramasekara, Akila
Liyanage, M. P. P.
Kumarasinghe, Udayagee
2020 20TH INTERNATIONAL CONFERENCE ON ADVANCES IN ICT FOR EMERGING REGIONS (ICTER-2020), 2020, : 276 - 277
[29] PERFORMANCE EVALUATION OF NOSQL-CASSANDRA OVER RELATIONAL DATA STORE-MYSQL FOR BIGDATA
Gupta, Sangeeta
Narsimha
INTERNATIONAL JOURNAL OF TECHNOLOGY, 2015, 6 (04) : 640 - 649
[30] Performance Evaluation of IoT Data Management Using MongoDB Versus MySQL Databases in Different Cloud Environments
Eyada, Mahmoud
Saber, Walaa
El Genidy, Mohammed M.
Amer, Fathy
IEEE ACCESS, 2020, 8 : 110656 - 110668

← 1 2 3 4 5 →