Re: concurrent index builds unneeded lock? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: concurrent index builds unneeded lock?
Date
Msg-id 16007.1247413350@sss.pgh.pa.us
Whole thread Raw
In response to Re: concurrent index builds unneeded lock?  (Greg Stark <gsstark@mit.edu>)
Responses Re: concurrent index builds unneeded lock?
List pgsql-hackers
Greg Stark <gsstark@mit.edu> writes:
> So I think we're back to looking at a special case for concurrent
> index builds to not wait on other concurrent index builds.

I'm kind of wondering how big the use case for that really is.
AFAICT the point of a concurrent build is to (re)build an index
without incurring too much performance penalty for foreground
query processing.  So how often are you really going to want
to fire off several of them in parallel?  If you can afford to
saturate your machine with indexing work, you could use plain
index builds.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Greg Stark
Date:
Subject: Re: concurrent index builds unneeded lock?
Next
From: Tom Lane
Date:
Subject: Re: concurrent index builds unneeded lock?