Re: Prototype: In-place upgrade v02

Bruce Momjian napsal(a):
>
> As far as the page not fitting after conversion, what about some user
> command that will convert an entire table to the new format if page
> expansion fails.

Keep in a mind that there are more kind of pages. Heap is easy, but each index
AM has own specific :(. Better approach is move tuple to the new page and
invalidate all related table indexes. Following reindex automatically convert
whole table.

>> After putting all those together, how large a patch are we talking
>> about, and what's the performance penalty then? How much of all that
>> needs to be in core, and how much can live in a pgfoundry project or an
>> extra binary in src/bin or contrib? I realize that none of us have a
>> crystal ball, and one has to start somewhere, but I feel uneasy
>> committing to an approach until we have a full plan.
>
> Yes, another very good point.
>
> I am ready to focus on these issues for 8.4; all this needs to be
> fleshed out, perhaps on a wiki. As a starting point, what would be
> really nice is to start a wiki that lists all data format changes for
> every major release.

As Greg mentioned in his mail there wiki page is already there. Unfortunately, I
did not time to put actual information there. I'm going to do soon.

Zdenek

--
Zdenek Kotala Sun Microsystems
Prague, Czech Republic http://sun.com/postgresql