From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | bibach(at)infomansol(dot)com (Brandon Ibach) |
Cc: | hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] Upgrading (was: now 6.4) |
Date: | 1998-06-12 04:40:25 |
Message-ID: | 199806120440.AAA02665@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
>
> I hate to open a potential can of worms here, but here's another
> possibility. I recall someone telling me about a database (InterBase,
> I believe it was) that could have rows with different structures all
> in the same table. In other words, they could add a field to the
> table, and any new rows would have it, while the old ones would not,
> and the database would deal with it on the fly.
> Could we implement some type of "version" field in the table
> structure which would allow this type of thing? If this is
> reasonable, we could have it in 6.4 and potentially never have to
> worry too much about reloading tables after that. With version info
> in each tuple, we could convert the table "as we go" or in some other
> gradual way.
> Of course, the question of how much work it would take to have the
> backend support this needs to be considered, as well as the issue of
> how this would impact performance.
Actually, we already have that. When you add a column to a table, it
does not re-structure the old rows. However, system tables do not
always add columns. Sometimes we change them. Also there is lots
more/different rows for tables, and keeping that straight would be
terrible.
If we can keep the original data files and require initdb and a
re-index, that would be good.
--
Bruce Momjian | 830 Blythe Avenue
maillist(at)candle(dot)pha(dot)pa(dot)us | Drexel Hill, Pennsylvania 19026
+ If your life is a hard drive, | (610) 353-9879(w)
+ Christ can be your backup. | (610) 853-3000(h)
From | Date | Subject | |
---|---|---|---|
Next Message | David Gould | 1998-06-12 05:08:28 | Re: [HACKERS] inlining |
Previous Message | Brandon Ibach | 1998-06-12 03:47:34 | Upgrading (was: now 6.4) |