Re: WIP: pre-upgrade page reservation

From: Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM>
To: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: WIP: pre-upgrade page reservation
Date: 2008-12-17 10:19:13
Message-ID: 4948D221.10802@sun.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2008-12-17 10:33:11 Re: WIP: pre-upgrade page reservation
Previous Message Pavan Deolasee 2008-12-17 10:14:04 Re: visibility maps