Change search
ReferencesLink to record
Permanent link

Direct link
ACID and BASE in POSTGRESQL: Distributed database performance
KTH, School of Computer Science and Communication (CSC).
KTH, School of Computer Science and Communication (CSC).
2015 (English)Independent thesis Basic level (degree of Bachelor), 10 credits / 15 HE creditsStudent thesis
Abstract [en]

This thesis studies the performance impact of the Two Phase Commitmechanism used in order to achieve consistency in a distributed Post-greSQL system. This impact is compared to the performance gainedby removing Two Phase Commit and abandoning consistency. Thetests are run on different number of nodes in the system to find a linkbetween the performance hit and the size of the system. Performanceis measured using the unit Queries per Second.Firstly, a short introduction is given to demonstrate why and whendistributed database systems is necessary and the difficulties it poses.Thereafter follows a description of the system constructed to conductthe experiment, together with the results of this experiment. The the-sis is concluded with a discussion regarding the results and thoughtson future variations of the experiment.The conclusion of the experiment is that Two Phase Commit putsa low maximum performance on the system, especially when com-pared to the alternative of abandoning consistency. The number ofnodes did not significantly affect the performance of the system us-ing Two Phase Commit, however the alternative had a clear negativecorrelation between numbers of nodes and Queries per Second.

Place, publisher, year, edition, pages
National Category
Computer Science
URN: urn:nbn:se:kth:diva-168663OAI: diva2:817832
Available from: 2015-06-07 Created: 2015-06-07 Last updated: 2015-06-07Bibliographically approved

Open Access in DiVA

fulltext(924 kB)68 downloads
File information
File name FULLTEXT01.pdfFile size 924 kBChecksum SHA-512
Type fulltextMimetype application/pdf

By organisation
School of Computer Science and Communication (CSC)
Computer Science

Search outside of DiVA

GoogleGoogle Scholar
Total: 68 downloads
The number of downloads is the sum of all downloads of full texts. It may include eg previous versions that are now no longer available

Total: 92 hits
ReferencesLink to record
Permanent link

Direct link