Change search
ReferencesLink to record
Permanent link

Direct link
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 Commit

mechanism used in order to achieve consistency in a distributed PostgreSQL

system. This impact is compared to the performance gained

by removing Two Phase Commit and abandoning consistency. The

tests are run on different number of nodes in the system to find a link

between the performance hit and the size of the system. Performance

is measured using the unit Queries per Second.

Firstly, a short introduction is given to demonstrate why and when

distributed database systems is necessary and the difficulties it poses.

Thereafter follows a description of the system constructed to conduct

the experiment, together with the results of this experiment. The thesis

is concluded with a discussion regarding the results and thoughts

on future variations of the experiment.

The conclusion of the experiment is that Two Phase Commit puts

a low maximum performance on the system, especially when compared

to the alternative of abandoning consistency. The number of

nodes did not significantly affect the performance of the system using

Two Phase Commit, however the alternative had a clear negative

correlation between numbers of nodes and Queries per Second.

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

Open Access in DiVA

fulltext(924 kB)37 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: 37 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: 69 hits
ReferencesLink to record
Permanent link

Direct link