Electrotechnical and Computer Engineering
Vol. 35 No. 09 (2020): Proceedings of the Faculty of Technical Sciences
COMPARISON OF DATA SPEED READING STORAGE BY ROWS AND COLUMNS IN A PostgreSQL DATABASE
Abstract
Two groups of tests were performed in the paper, comparing the read speed of data stored by rows and columns in PostgreSQL. Based on the results obtained, it is shown that organizing data by columns is more suitable for aggregation (collection, summarization or grouping) of data.
References
[1] Metcalfe A. V., Statistics in Management Sciences, Oxford University Press, New York, 2000.
[2] Rabija Somun-Kapetanović, Statistika u ekonomiji i menadžmentu, Ekonomski fakultet u Sarajevu, Sarajevo, 2008
[3] Raghu Ramakrishnan, Johannes Gehrke, Database Management Systems. 2nd Ed, McGraw-Hill Publishing Company, New York , 2000
[4] Daniel J. Abadi, Samuel R. Madden, Nabil Hachem, Column-Stores vs RowStores : How Different Are They Really?, Vancouver, BC, Canada, June, 2008
[5] Aditi D. Andurkar, Column-Oriented Database Implementation in PostgreSql for Improving Performance of Read-Only Queries, Pune, June, 2012.
[6] G. Graefe, Efficient columnar storage in b-trees, SIGMOD Rec., 2007.
[7] Patrick ONeil and Dallan Quass, Improved query performance with variant indexes, 1997.
[8] D. J. Abadi, Query execution in column-oriented database systems, MIT PHD Dissertation, PhD Thesis, 2008.