Database formats

SQLite overflow planner

Calculate local payload and overflow pages using SQLite’s B-tree thresholds.

Your inputs

Start with an example

Example result

Apply the format’s local-payload thresholds to usable page size U. Overflow pages hold U−4 payload bytes after their next-page pointer.

For a 4096-byte table-leaf page and 5000 payload bytes, 908 stay local and 4092 use one overflow page.

Payload arithmetic only. Page headers, cell pointers, fragmentation, free space and total database growth are separate.