On Sat, Jun 28, 2003 at 01:43:32PM -0400, Tom Lane wrote:Bruce Momjian <[EMAIL PROTECTED]> writes: > Is this a TODO? > When columns can be reordered, move varlena columns to the end?
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.
This means that when you do ALTER TABLE ... SET/DROP NOT NULL the table may have to be completely rewritten? Altering the physical order is sure to provoke a rewrite, but I think people will expect a change in constraints to be a fast operation.
I said "... table starts with ...", I said nothing about physically reordering an existing table.
All we where talking about is uncoupling the order in which attributes of a relation appear if automatically expanded from "SELECT * ...". Currently, they are tied to the order of the physical tuple layout, which in turn is the result of the original order at CREATE TABLE, plus added columns at the end and dropped ones taken out.
Jan
-- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== [EMAIL PROTECTED] #
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
