Page Size Selection for OLTP Databases on SSD Storage

  • 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
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.
Published
2011-08-10