Re: Composite types as columns used in production? - Mailing list pgsql-general

From Tom Lane
Subject Re: Composite types as columns used in production?
Date
Msg-id 7094.1114795433@sss.pgh.pa.us
Whole thread Raw
In response to Re: Composite types as columns used in production?  (James Robinson <jlrobins@socialserve.com>)
List pgsql-general
James Robinson <jlrobins@socialserve.com> writes:
> That said -- anyone stepping up to claiming using 'em? Are these things
> seen as against the data normalization grain?

One strike against 'em is the fairly high overhead involved --- a
composite value is stored as effectively its own tuple, so there's 28 or
so bytes of overhead for each one.

            regards, tom lane

pgsql-general by date:

Previous
From: Chris Browne
Date:
Subject: Slowness of Big Graphical Arrays
Next
From: Tom Lane
Date:
Subject: Re: Increasing statistics results in worse estimates