Skip site navigation (1) Skip section navigation (2)

Re: [PATCH] Space reservation v02

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 (view raw, whole thread or download thread mbox)
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 
 PostgreSQL Training, Services and Support

In response to


pgsql-hackers by date

Next:From: Simon RiggsDate: 2009-01-31 09:25:49
Subject: Re: Hot standby, recovery infra
Previous:From: Stephen FrostDate: 2009-01-31 08:22:20
Subject: Re: How to get SE-PostgreSQL acceptable

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group