Re: Useless toast - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Useless toast
Date
Msg-id 1080784.1721763935@sss.pgh.pa.us
Whole thread Raw
In response to Re: Useless toast  (Peter Eisentraut <peter@eisentraut.org>)
List 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 by date:

Previous
From: Joe Conway
Date:
Subject: Re: [18] Policy on IMMUTABLE functions and Unicode updates
Next
From: Nathan Bossart
Date:
Subject: Re: pg_upgrade and logical replication