Re: How many fields in a table are too many

Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Is this a TODO?
>     When columns can be reordered, move varlena columns to the end?

Yeah, if it's not in there already.  I remember seeing some Berkeley-era
comments speculating that this would be a good thing to do.  Not sure if
they're still in the code, or

I believe that really what you want is fixed-width NOT NULL columns
first, then fixed-width nullable, then var-width.  This ordering will
improve the odds of actually being able to use the fixed offset for
a particular column.

            regards, tom lane