Re: Modifying TOAST_TUPLE_THRESHOLD and TOAST_TUPLE_TARGET?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Modifying TOAST_TUPLE_THRESHOLD and TOAST_TUPLE_TARGET?
Дата
Msg-id 24379.1244735533@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Modifying TOAST_TUPLE_THRESHOLD and TOAST_TUPLE_TARGET?  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Ответы Re: Modifying TOAST_TUPLE_THRESHOLD and TOAST_TUPLE_TARGET?  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-hackers
"Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
> Greg Stark <stark@enterprisedb.com> wrote: 
>> tuptoaster.c only has one definition of "small enough" which is
>> whether the record is smaller than TOAST_TUPLE_THRESHOLD.
> So what *is* the difference between EXTENDED and MAIN?

EXTENDED columns get pushed out first.  So if you have some EXTENDED
columns and some MAIN columns, it'll give preference to keeping the
MAIN columns in-line.  In the OP's case there's only one wide column
so this is of no help.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: "David E. Wheeler"
Дата:
Сообщение: Re: [PATCH][v8.5] SE-PostgreSQL Patch Updates (r2016)
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Modifying TOAST_TUPLE_THRESHOLD and TOAST_TUPLE_TARGET?