| From: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
|---|---|
| To: | Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM> |
| Cc: | "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: [PATCH] Space reservation v02 |
| Date: | 2009-01-31 09:21:39 |
| Message-ID: | 1233393699.4500.6.camel@ebony.2ndQuadrant |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Tue, 2009-01-27 at 13:06 +0100, Zdenek Kotala wrote:
> Space reservation MUST TO be implemented if we
> want to have 8.4->8.5 upgrade.
Why not just add a few dummy columns onto each catalog table? If we need
space to expand a row we can just drop one of the dummy columns from the
new catalog definition.
That's an old DBA trick to avoid having to rewrite a table when you want
to add a column.
Seems much simpler to add columns than write special code, especially
when we might find the new code has bugs and hasn't done what we thought
it might.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2009-01-31 09:25:49 | Re: Hot standby, recovery infra |
| Previous Message | Stephen Frost | 2009-01-31 08:22:20 | Re: How to get SE-PostgreSQL acceptable |