Re: adding new pages bulky way

From: Alvaro Herrera <alvherre(at)surnet(dot)cl>
To: Postgres Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: adding new pages bulky way
Date: 2005-06-07 00:42:30
Message-ID: 20050607004230.GC13973@surnet.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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"

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message David Fetter 2005-06-07 00:59:12 Re: [HACKERS] regexp_replace
Previous Message a_ogawa 2005-06-07 00:35:56 Re: [HACKERS] regexp_replace