Back to search

Institutional Repository of Vilnius University

Duomenų skaidymo efektyvumo palyginimas „PostgreSQL Citus” ir „Apache Cassandra” duomenų bazių valdymo sistemose /

Abstract

dc:description

This work analyzes the data sharding efficiency in PostgreSQL Citus and Apache Cassandra database management systems. The theoretical analysis uncovers architectural differences between relational and widecolumn models, distributed system architectures, data structures utilised by DBMS, as well as their respective sharding methods. The practical evaluation was conducted using a customdesigned experimental orchestration framework combining the Yahoo! Cloud Serving Benchmark (YCSB) and DigitalOcean cloud technologies. The empirical research revealed that Cassandra achieved on average about 2.5–3 times higher throughput (up to 19 times higher for range queries) and 2 to 4 times lower latency compared to PostgreSQL Citus, handled write operations more effectively (data loading was about 13 times faster), and maintained better availability during network topology changes. Conversely, while both systems showed degraded performance during range queries, PostgreSQL Citus demonstrated significantly faster (about 6 times) data rebalancing when adding new nodes to the cluster, though with a more noticeable throughput drop during the process.

Degree

thesis:*
Grantor dc:publisher
Institutional Repository of Vilnius University
Year dc:date
2026

Author and committee

dc:creator, dc:contributor.*
Author dc:creator
  • Arelis, Konstantinas,

Rights

dc:rights
Statement dc:rights
  • info:eu-repo/semantics/openAccess
Language dc:language
lit

Identifiers

dc:identifier.*

Chain of custody

source
Harvested from
Vilnius University
Base URL
epublications.vu.lt/oai
Last updated
2026-11-19
Source record
OAI-PMH GetRecord
related terms
citation

Arelis, Konstantinas,. Duomenų skaidymo efektyvumo palyginimas „PostgreSQL Citus” ir „Apache Cassandra” duomenų bazių valdymo sistemose /. Institutional Repository of Vilnius University, 2026. https://repository.vu.lt/VU:ELABAETD308335960&prefLang=en_US