Databases · Senior · Question 73 of 75

What is TOAST in PostgreSQL?

1A backup tool
✓Correct answer: The mechanism that compresses large values and stores them out of line in a separate table, so main table rows stay small
3A type of transaction log

Explanation

Big text, jsonb or bytea values are TOASTed. Updating one key in a large jsonb value still writes the whole value again.

Further reading

Test yourself

Take the Databases · Senior quiz: questions and options are shuffled, and you get a review of your mistakes at the end.