EUVIMEDEUVIMED entdecken
Open Access · CC BY 4.0

Comparative Read Performance Analysis of PostgreSQL and MongoDB in E-Commerce: An Empirical Study of Filtering and Analytical Queries

Jovita Urnikienė, Vaida Steponavičienė, Svetoslav Atanasov

Big Data and Cognitive Computing · 19.02.2026 · 10 (2) · 66

DOI: 10.3390/bdcc10020066 ↗

Kurz gefasst

Fachartikel in der Zeitschrift Big Data and Cognitive Computing, online erschienen am 19.02.2026. Verfasst von Jovita Urnikienė und 2 weiteren Autor:innen. Die Arbeit wurde bisher 1-mal zitiert (Crossref) und nennt 23 Literaturangaben. Der Volltext ist frei zugänglich (Open Access, CC BY 4.0).

AbstractBibliografische AngabenZitierenVerwandte Studien

Abstract (Originalsprache)

This paper presents a comparative analysis of read performance for PostgreSQL and MongoDB in e-commerce scenarios, using identical datasets in a resource-constrained single-host environment. The results demonstrate that PostgreSQL executes complex analytical queries 1.6–15.1 times faster, depending on the query type and data volume. The study employed synthetic data generation with the Faker library across three stages, processing up to 300,000 products and executing each of 6 query types 15 times. Both filtering and analytical queries were tested on non-indexed data in a controlled localhost environment with PostgreSQL 17.5 and MongoDB 7.0.14, using default configurations. PostgreSQL showed 65–80% shorter execution times for multi-criteria queries, while MongoDB required approximately 33% less disk space. These findings suggest that normalized relational schemas are advantageous for transactional e-commerce systems where analytical queries dominate the workload. The results are directly applicable to small and medium e-commerce developers operating in budget-constrained, single-host deployment environments when choosing between relational and document-oriented databases for structured transactional data with read-heavy analytical workloads. A minimal indexed validation confirms that the baseline trends remain consistent under a simple indexing configuration. Future work will examine broader indexing strategies, write-intensive workloads, and distributed deployment scenarios.

Zitieren

APA

Urnikienė, J., Steponavičienė, V., & Atanasov, S. (2026). Comparative Read Performance Analysis of PostgreSQL and MongoDB in E-Commerce: An Empirical Study of Filtering and Analytical Queries. Big Data and Cognitive Computing, 10(2), 66. https://doi.org/10.3390/bdcc10020066

Vancouver

Urnikienė J, Steponavičienė V, Atanasov S. Comparative Read Performance Analysis of PostgreSQL and MongoDB in E-Commerce: An Empirical Study of Filtering and Analytical Queries. Big Data and Cognitive Computing. 2026;10(2):66. doi:10.3390/bdcc10020066

BibTeX
@article{Urnikien2026,
  author = {Urnikienė, Jovita and Steponavičienė, Vaida and Atanasov, Svetoslav},
  title = {Comparative Read Performance Analysis of PostgreSQL and MongoDB in E-Commerce: An Empirical Study of Filtering and Analytical Queries},
  journal = {Big Data and Cognitive Computing},
  year = {2026},
  volume = {10},
  number = {2},
  pages = {66},
  doi = {10.3390/bdcc10020066}
}
Kostenlos starten →