Data Management

Page Size Selection for OLTP Databases on SSD Storage

Date Added: Oct 2010
Format: PDF

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