Skip to content
scrambled
Software Engineering Flashcard

What is PostgreSQL TOAST?

Concepts Deckdatabase Tags
  • database

Question

What is PostgreSQL TOAST?

Answer

The Oversized-Attribute Storage Technique. When a column value exceeds ~2 KB, PostgreSQL automatically compresses and/or moves it to a separate TOAST table. Happens transparently. Limits: 1 GB per value, 4 billion (> 2 KB) entries per table.