Skip to main content
Journey Uncommon Logo
JourneyUncommon
hardSQLtable bloat and VACUUMSingle-choice MCQ

A row in a PostgreSQL table has a large text value stored out-of-line in TOAST. An UPDATE changes only a small unrelated integer column in that row, never touching the large text. What happens to the TOASTed value's storage?

-- doc.body is a multi-megabyte text column, already TOASTed UPDATE doc SET views = views + 1 WHERE id = 42;