No, CONCURRENTLY is to improve table availability during index creation, but it degrades the performances. best regards, Marc Mamin -----Original Message----- From: Alex Hunsaker [mailto:badalex@xxxxxxxxx] Sent: Donnerstag, 11. November 2010 19:55 To: Marc Mamin Cc: pgsql-performance@xxxxxxxxxxxxxx Subject: Re: CREATE INDEX as bottleneck On Thu, Nov 11, 2010 at 06:41, Marc Mamin <M.Mamin@xxxxxxxxxxxx> wrote: > There are a few places in our data flow where we have to wait for index > creation before being able to distribute the process on multiple threads > again. Would CREATE INDEX CONCURRENTLY help here? -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
