Page Size Selection for OLTP Databases on SSD Storage
Ilia Petrov, Robert Gottstein, Todor Ivanov, Daniel G. Bausch, Alejandro Buchmann · Cadernos de Linguística e Teoria da Literatura (Universidade Federal de Minas Gerais) · 2010
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. 1.