Re: Thoughts on user-defined types for talk at Postgres conference? - Mailing list pgsql-general

From Peter J. Holzer
Subject Re: Thoughts on user-defined types for talk at Postgres conference?
Date
Msg-id 20240307211655.mqx2pmmyflyb2jlr@hjp.at
Whole thread Raw
In response to Re: Thoughts on user-defined types for talk at Postgres conference?  (Stephen Frost <sfrost@snowman.net>)
Responses Re: Thoughts on user-defined types for talk at Postgres conference?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On 2024-03-06 12:45:33 -0500, Stephen Frost wrote:
> =*# select pg_column_size(t2.*) from t2;
>  pg_column_size
> ----------------
>              53
> (1 row)
>
> That's an additional 21 bytes, which is really quite a lot.  What's
> included in those 21 bytes are
[...]
> the type information (typmod if there is one and the OID of the
> composite type),

Is it necessary to store this in every row? Can a column contain
different composite types?

        hp


--
   _  | Peter J. Holzer    | Story must make more sense than reality.
|_|_) |                    |
| |   | hjp@hjp.at         |    -- Charles Stross, "Creative writing
__/   | http://www.hjp.at/ |       challenge!"

Attachment

pgsql-general by date:

Previous
From: sud
Date:
Subject: Re: Is partition pruning impacted by data type
Next
From: Tom Lane
Date:
Subject: Re: Thoughts on user-defined types for talk at Postgres conference?