Re: Useless toast

2024-07-23 Thread Tom Lane
Peter Eisentraut 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 s

Re: Useless toast

2024-07-23 Thread Tom Lane
Marcos Pegoraro writes: > Using version 16, seems strange when toast needs to be created. Tested with > domain being numeric or varchar(10) with the same results. Domains are fairly opaque when it comes to maximum length. I cannot get excited about adding code to make them less so.

Re: Useless toast

2024-07-23 Thread Peter Eisentraut
On 23.07.24 20:35, Marcos Pegoraro wrote: Using version 16, seems strange when toast needs to be created. Tested with domain being numeric or varchar(10) with the same results. And If that domain is integer then no toast is created. I think none of these tables should have a toast, right ? T

Useless toast

2024-07-23 Thread Marcos Pegoraro
Using version 16, seems strange when toast needs to be created. Tested with domain being numeric or varchar(10) with the same results. And If that domain is integer then no toast is created. I think none of these tables should have a toast, right ? postgres=# create domain mynum as numeric(15,2)