From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
Cc: | Russell Smith <mr-russ(at)pws(dot)com(dot)au>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Stephen Frost <sfrost(at)snowman(dot)net>, Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>, pgsql-hackers(at)postgresql(dot)org, Martijn van Oosterhout <kleptog(at)svana(dot)org>, Gregory Stark <stark(at)enterprisedb(dot)com> |
Subject: | Re: column ordering, was Re: [PATCHES] Enums patch |
Date: | 2006-12-20 16:20:16 |
Message-ID: | 200612201620.kBKGKGW17573@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
Andrew Dunstan wrote:
> > Now, we are rewriting the table from scratch anyway, the on disk
> > format is changing. What is stopping us from switching the column
> > order at the same time. The only thing I can think is that the
> > catalogs will need more work to update them. It's a middle sized
> > price to pay for being able to reorder the columns in the table. One
> > of the problems I have is wanting to add a column in the middle of the
> > table, but FK constraints stop me dropping the table to do the
> > reorder. If ALTER TABLE would let me stick it in the middle and
> > rewrite the table on disk, I wouldn't care. It's likely that I would
> > be rewriting the table anyway. And by specifying AT POSITION, or
> > BEFORE/AFTER you know for big tables it's going to take a while.
> >
>
> This isn't really a compromise. Remember that this discussion started
> with consideration of optimal record layout (minimising space use by
> reducing or eliminating alignment padding). The above proposal really
> does nothing for that.
I assume space waste will be mostly fixed when we have 0/1 byte headers
for varlena data types.
--
Bruce Momjian bruce(at)momjian(dot)us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-12-20 16:24:02 | Re: column ordering, was Re: [PATCHES] Enums patch v2 |
Previous Message | Bruce Momjian | 2006-12-20 16:13:23 | Re: Companies Contributing to Open Source |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-12-20 16:24:02 | Re: column ordering, was Re: [PATCHES] Enums patch v2 |
Previous Message | Bruce Momjian | 2006-12-20 16:06:46 | Re: [PATCHES] Load distributed checkpoint patch |