Avoid creating a TOAST table if we can prove that the maximum tuple
Tom Lane <tgl@sss.pgh.pa.us>
Avoid creating a TOAST table if we can prove that the maximum tuple length is < TOAST_TUPLE_THRESHOLD, even with toastable column types present. For example, CREATE TABLE foo (f1 int, f2 varchar(100)) does not require a toast table, even though varchar is a toastable type.
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/commands/command.c | modified | +98 −84 |
| src/backend/utils/adt/format_type.c | modified | +49 −1 |
| src/include/utils/builtins.h | modified | +2 −1 |