Re: How many fields in a table are too many - Mailing list pgsql-general

From Tom Lane
Subject Re: How many fields in a table are too many
Date
Msg-id 19148.1056822212@sss.pgh.pa.us
Whole thread Raw
In response to Re: How many fields in a table are too many  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: How many fields in a table are too many
Re: How many fields in a table are too many
List pgsql-general
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

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: How many fields in a table are too many
Next
From: Alvaro Herrera
Date:
Subject: Re: How many fields in a table are too many