Re: why toasted is created when domain is used ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: PegoraroF10 <marcos(at)f10(dot)com(dot)br>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: why toasted is created when domain is used ?
Date: 2019-08-05 13:51:38
Message-ID: 11202.1565013098@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

PegoraroF10 <marcos(at)f10(dot)com(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2019-08-05 14:20:30 Re: Aggregate not using BRIN index on timestamp
Previous Message Jeremy Finzel 2019-08-05 13:45:47 Aggregate not using BRIN index on timestamp