Re: WIP: pre-upgrade page reservation - Mailing list pgsql-hackers

From Zdenek Kotala
Subject Re: WIP: pre-upgrade page reservation
Date
Msg-id 4948D221.10802@sun.com
Whole thread Raw
In response to Re: WIP: pre-upgrade page reservation  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Responses Re: WIP: pre-upgrade page reservation  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
List pgsql-hackers
Heikki Linnakangas napsal(a):
> Zdenek Kotala wrote:
>> BTree space reservation is more complicated. 
> 
> Do you need to pre-reserve the space for b-tree? I think you can just 
> split it at upgrade, in the new version. The problem with doing that for 
> heaps is that to move a heap tuple you need to update the index 
> pointers, but for indexes there's no such restriction.

The problem is that I need to know parent and modify parent as well. But you 
don't know what is your parent node. You need to know root and go from root.
It is why I think that it is not doable online.

Correct me if I'm wrong.
    thanks Zdenek


pgsql-hackers by date:

Previous
From: "Pavan Deolasee"
Date:
Subject: Re: visibility maps
Next
From: Heikki Linnakangas
Date:
Subject: Re: WIP: pre-upgrade page reservation