Re: why toasted is created when domain is used ?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: why toasted is created when domain is used ?
Дата
Msg-id 11202.1565013098@sss.pgh.pa.us
обсуждение исходный текст
Ответ на why toasted is created when domain is used ?  (PegoraroF10 <marcos@f10.com.br>)
Ответы Re: why toasted is created when domain is used ?  (PegoraroF10 <marcos@f10.com.br>)
Список pgsql-general
PegoraroF10 <marcos@f10.com.br> writes:
> So, the question is, when I create a table using domains it creates a toast
> for it, why ?

For me, this doesn't happen for domains over fixed-width types, only
variable-width types ... which doesn't seem to match your example.

The reason it happens for variable-width cases is that
type_maximum_size() only knows about built-in types,
so the system can't determine the maximum row width.

            regards, tom lane



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

Предыдущее
От: Jeremy Finzel
Дата:
Сообщение: Aggregate not using BRIN index on timestamp
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Aggregate not using BRIN index on timestamp