← recall

page term

fixed-size unit of disk IO — typically 4KB or 8KB

DBs read/write pages, not individual rows. Postgres = 8KB. Page-level locking, page cache, and 'fits on a page' decisions all derive from this.

topics: databases, internals, operating-systems

references:

• Postgres — Database Page Layout