Re: Modifying TOAST thresholds

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Modifying TOAST thresholds
Дата
Msg-id 17489.1175574401@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Modifying TOAST thresholds  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Modifying TOAST thresholds  ("Zeugswetter Andreas ADI SD" <ZeugswetterA@spardat.at>)
Список pgsql-hackers
I wrote:
> ... should we revel
> in configurability, and allow CREATE TABLE/ALTER TABLE behavior to vary
> depending on the current threshold setting?  We'd have to fix the
> toaster routines to not try to push stuff out-of-line when there is no
> out-of-line to push to ... but I think we probably had better do that
> anyway for robustness, if we're allowing any variability at all in these
> numbers.

Actually, upon looking closely at the toast code, it already does the
right thing when there's no toast table.  Good on someone for getting
that right.  But we still need to think about whether it's sane for
CREATE/ALTER TABLE to condition the create-a-toast-table decision on
a parameter that may now be changeable.
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Modifying TOAST thresholds
Следующее
От: "Luke Lonergan"
Дата:
Сообщение: Re: Synchronized Scan benchmark results