Re: Useless toast

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Useless toast
Дата
Msg-id 1080784.1721763935@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Useless toast  (Peter Eisentraut <peter@eisentraut.org>)
Список pgsql-hackers
Peter Eisentraut <peter@eisentraut.org> writes:
> On 23.07.24 20:35, Marcos Pegoraro wrote:
>> I think none of these tables should have a toast, right ?

> The mechanism that determines whether a toast table is needed only 
> considers the data type, not the "typmod" (arguments of the data type). 
> So this is perhaps suboptimal, but this logic just doesn't exist.

Not true, see type_maximum_size() in format_type.c.  But I'm
uninterested in making that drill down into domains, or at least
that would not be my first concern if we were trying to improve it.
(The first concern would be to let extension types in on the fun.)

            regards, tom lane



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

Предыдущее
От: Joe Conway
Дата:
Сообщение: Re: [18] Policy on IMMUTABLE functions and Unicode updates
Следующее
От: Nathan Bossart
Дата:
Сообщение: Re: pg_upgrade and logical replication