Large value

Most DBMS don't allow a tuple to exceed the size of a single page

To store values that are larger than a page, the DBMS use separate overflow storage pages.

  • Postgres: TOAST (>2KB)

  • MySql: Overflow (> 1/2 size of page)

  • SQL server: Overflow (>size of page)

Last updated