Re: Fixed length data types issue

Bruce Momjian <bruce(at)momjian(dot)us> writes:

> Gregory Stark wrote:
> > But I think this is a dead-end route. What you're looking at is the number "1"
> > repeated for *every* record in the table. And what your proposing amounts to
> > noticing that the number "4" fits in a byte and doesn't need a whole word to
> > store it. Well sure, but you don't even need a byte if it's going to be the
> > same for every record in the table.
> >
> > If someone popped up on the list asking about whether Postgres compressed
> > their data efficiently if they stored a column that was identical throughout
> > the whole table you would tell them to normalize their data.
>
> I am confused. You don't want to shrink the header but instead compress
> duplicate values in the same row to a single entry?

I think we have to find a way to remove the varlena length header entirely for
fixed length data types since it's going to be the same for every single
record in the table.

It might be useful to find a way to have 1-byte or 2-byte length headers too
since I suspect most legitimately variable columns like text or array[] are
also gong to be under 256 bytes.

--
greg