Re: pg_upgrade (was: 8.2 features status)

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
Cc: Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-hackers(at)postgresql(dot)org, David Fetter <david(at)fetter(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Bruce Momjian <bruce(at)momjian(dot)us>, Gavin Sherry <swm(at)linuxworld(dot)com(dot)au>
Subject: Re: pg_upgrade (was: 8.2 features status)
Date: 2006-08-04 18:12:16
Message-ID: 20060804181216.GI20016@kenobi.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

* Jim C. Nasby (jnasby(at)pervasive(dot)com) wrote:
> On Thu, Aug 03, 2006 at 11:20:48PM -0700, Josh Berkus wrote:
> > > * In-place upgrades (pg_upgrade)
> >
> > BTW, I may get Sun to contribute an engineer for this; will get you posted.
>
> How would such a thing handle changes to page formats?

Couldn't this be done by converting a table/partial-table at a time?
It wouldn't be something which could run while the system is live, but
it'd probably take less time than dump/restore and wouldn't require
double the disk space of the whole database... no?

Thanks,

Stephen

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2006-08-04 18:40:30 "Constraint exclusion" is not general enough
Previous Message mdean 2006-08-04 17:56:51 Re: 8.2 features status