Re: [PATCH] Space reservation v02

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: [PATCH] Space reservation v02
Дата
Msg-id 1233393699.4500.6.camel@ebony.2ndQuadrant
обсуждение исходный текст
Ответ на [PATCH] Space reservation v02  (Zdenek Kotala <Zdenek.Kotala@Sun.COM>)
Ответы Re: [PATCH] Space reservation v02  (Robert Haas <robertmhaas@gmail.com>)
Re: [PATCH] Space reservation v02  (Euler Taveira de Oliveira <euler@timbira.com>)
Список 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 по дате отправления:

Предыдущее
От: Stephen Frost
Дата:
Сообщение: Re: How to get SE-PostgreSQL acceptable
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: Hot standby, recovery infra