Part 02 · Storage Engine Fundamentals

Pages and Blocks

PageBlock8KBDisk I/O unit

A database never reads one row, it reads a whole page. What a page is, why it is 8KB in PostgreSQL and 16KB in InnoDB, and how to count pages a query touches.

⏱ 6 min · Station 6 of 123

✎

This chapter is being written.

The route is mapped; the full walkthrough arrives here soon.