Re: CREATE INDEX as bottleneck - Mailing list pgsql-performance

From Marc Mamin
Subject Re: CREATE INDEX as bottleneck
Date
Msg-id C4DAC901169B624F933534A26ED7DF31034BB8D7@JENMAIL01.ad.intershop.net
Whole thread Raw
In response to Re: CREATE INDEX as bottleneck  (Alex Hunsaker <badalex@gmail.com>)
List pgsql-performance
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@gmail.com] 
Sent: Donnerstag, 11. November 2010 19:55
To: Marc Mamin
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] CREATE INDEX as bottleneck

On Thu, Nov 11, 2010 at 06:41, Marc Mamin <M.Mamin@intershop.de> 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?

pgsql-performance by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: anti-join chosen even when slower than old plan
Next
From: Andres Freund
Date:
Subject: Re: anti-join chosen even when slower than old plan