Re: adding new pages bulky way - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: adding new pages bulky way
Date
Msg-id 20050607004230.GC13973@surnet.cl
Whole thread Raw
In response to adding new pages bulky way  ("Victor Y. Yegorov" <viy@mits.lv>)
List pgsql-hackers
On Mon, Jun 06, 2005 at 10:59:04PM +0300, Victor Y. Yegorov wrote:

> The question is: allocating pages this way is really ugly, I understand. Is
> there some API that would allow allocating N pages in the bulk way?
> Maybe this is a know problem, that has been already solved before?
> Any other ideas?

I don't understand your question.  What's the problem with holding the
extend lock for the index relation while you extend it?  Certainly you
want only a single process creating a new extent in the index, right?

I guess the question is when are the extents created, and what
concurrency do you expect from that operation.

-- 
Alvaro Herrera (<alvherre[a]surnet.cl>)
"La naturaleza, tan frágil, tan expuesta a la muerte... y tan viva"


pgsql-hackers by date:

Previous
From: a_ogawa
Date:
Subject: Re: [PATCHES] regexp_replace
Next
From: David Fetter
Date:
Subject: Re: [PATCHES] regexp_replace