Communications - Scientific Letters of the University of Zilina 2008, 10(4):53-57 | DOI: 10.26552/com.C.2008.4.53-57

A Performance Analysis of the Dbms - MYSQL Vs POSTGRESQL

Svetlana Andjelic1, Slobodan Obradovic2, Branislav Gacesa3
1 The Railway College of Vocational Studies, Belgrade, Serbia
2 Megatrend University, Belgrade, Serbia
3 Telekom Srpske A. D., SRJ Internet Srpske, Banja Luka, Bosna and Herzegovina

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.

Keywords: open source DBMS, MySQL, PostgreSQL, ACID

Published: December 31, 2008  Show citation

ACS AIP APA ASA Harvard Chicago Chicago Notes IEEE ISO690 MLA NLM Turabian Vancouver
Andjelic, S., Obradovic, S., & Gacesa, B. (2008). A Performance Analysis of the Dbms - MYSQL Vs POSTGRESQL. Communications - Scientific Letters of the University of Zilina, 10(4), 53-57. doi: 10.26552/com.C.2008.4.53-57
Share...
Download citation
  • BibTeX (.bib)
  • Bookends (.ris)
  • EasyBib (.ris)
  • EndNote (.enw)
  • EndNote 8 (.xml)
  • ISI WoS (.isi)
  • Medlars (.medlars)
  • Mendeley (.ris)
  • MODS (.xml)
  • Papers (.ris)
  • RefWorks (.txt)
  • RefManager (.ris)
  • RIS (.ris)
  • MS Word (.xml)
  • Zotero (.ris)
    • Open full article

    References

    1. ANDJELIC, S., OBRADOVIC, S., GACESA, B.: A Performance Analysis of the Open Sorce Database, XIII conference YUINFO 2007, Kopaonik, Serbia, ISBN 978-86-85525-02-5
    2. KLINE, K. E., KLINE, D., HUNT, B.: SQL in Nutshell, O'Reilly, 2004
    3. WORSLEY, J. C., DRAKE, J. D.: Practical PostgreSQL, O'Reilly, 2002
    4. RUSSELL, J. DYER, T.: MySQL In A Nutshell, O'Reilly, 2005
    5. HORN, J. W., GREY, M.: MySQL: Essential Skills, McGraw-Hill Professional, 2004
    6. http://support.summersault.com/why_postgresql.html
    7. http://www.postgresql.org
    8. http://www.mysql.com

    This is an open access article distributed under the terms of the Creative Commons Attribution 4.0 International License (CC BY 4.0), which permits use, distribution, and reproduction in any medium, provided the original publication is properly cited. No use, distribution or reproduction is permitted which does not comply with these terms.


    Return to the content