Re: adding new pages bulky way

From: "Victor Y(dot) Yegorov" <viy(at)mits(dot)lv>
To: Alvaro Herrera <alvherre(at)surnet(dot)cl>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Postgres Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: adding new pages bulky way
Date: 2005-06-07 21:50:28
Message-ID: 20050607215028.GC9424@mits.lv
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

* Alvaro Herrera <alvherre(at)surnet(dot)cl> [08.06.2005 00:39]:
> Huh, why? You need to grab the relation extension block
> (LockRelationForExtension in CVS tip).

Really? Didn't knew that.

Consider:
1) I add 2 pages to the newly-created relation
using P_NEW as BlockNumber;
2) then I do LockRelationForExtension; ReadBuffer(135) and
UnockRelationForExtension.

What BlockNumber will be assigned to the buffer, if I call
ReadBuffer(P_NEW) now? 136?

BTW, is it OK to say "BlockNumber is assigned to buffer"?

--

Victor Y. Yegorov

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2005-06-07 22:16:38 Re: I am up-to-date
Previous Message Tom Lane 2005-06-07 21:48:31 Proposed toast info extraction function for disaster recovery