Re: [PATCH] Space reservation v02 - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: [PATCH] Space reservation v02
Date
Msg-id 1233393699.4500.6.camel@ebony.2ndQuadrant
Whole thread Raw
In response to [PATCH] Space reservation v02  (Zdenek Kotala <Zdenek.Kotala@Sun.COM>)
Responses Re: [PATCH] Space reservation v02  (Robert Haas <robertmhaas@gmail.com>)
Re: [PATCH] Space reservation v02  (Euler Taveira de Oliveira <euler@timbira.com>)
List 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.comPostgreSQL Training, Services and Support



pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: How to get SE-PostgreSQL acceptable
Next
From: Simon Riggs
Date:
Subject: Re: Hot standby, recovery infra