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:[email protected]] Sent: Donnerstag, 11. November 2010 19:55 To: Marc Mamin Cc: [email protected] Subject: Re: [PERFORM] CREATE INDEX as bottleneck On Thu, Nov 11, 2010 at 06:41, Marc Mamin <[email protected]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
