Page Size Selection for OLTP Databases on SSD Storage

Authors

  • Ilia Petrov Databases and Distributed Systems Group, Technische Universität Darmstadt
  • Robert Gottstein Databases and Distributed Systems Group, Technische Universität Darmstadt
  • Todor Ivanov Databases and Distributed Systems Group, Technische Universität Darmstadt
  • Daniel Bausch Databases and Distributed Systems Group, Technische Universität Darmstadt
  • Alejandro Buchmann Databases and Distributed Systems Group, Technische Universität Darmstadt

DOI:

https://doi.org/10.5753/jidm.2011.1380

Keywords:

Database Systems, Page Size, Flash Solid State Disks

Abstract

Flash SSDs are a technology that has the potential of changing the database architecture and principles. We reevaluate present trend of growing database page sizes considering its validity for SSD-based database storage. Our major findings are: (a) on Flash storage this trend is reverted and best OLTP performance can be attained with smaller page sizes; (b) DBMS with smaller page sizes require less buffer space while providing the same performance; (c) due to the lower response times we report better CPU utilization for small page sizes.

Downloads

Download data is not yet available.

Downloads

Additional Files

Published

2011-08-12

How to Cite

Petrov, I., Gottstein, R., Ivanov, T., Bausch, D., & Buchmann, A. (2011). Page Size Selection for OLTP Databases on SSD Storage. Journal of Information and Data Management, 2(1), 11. https://doi.org/10.5753/jidm.2011.1380

Issue

Vol. 2 No. 1 (2011)

Section

SBBD 2010 Short Papers