Postgres Pro
Downloads
Home   >   mailing lists

Re: [DOC] Document concurrent index builds waiting on each other - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: [DOC] Document concurrent index builds waiting on each other
Date
Msg-id 20190930012406.GC2888@paquier.xyz
Whole thread Raw
In response to Re: [DOC] Document concurrent index builds waiting on each other  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Responses Re: [DOC] Document concurrent index builds waiting on each other
Re: [DOC] Document concurrent index builds waiting on each other
List pgsql-hackers
Tree view 
On Sat, Sep 28, 2019 at 10:22:28PM -0300, Alvaro Herrera wrote:
> I always thought that create index concurrently was prevented from
> running concurrently in a table by the ShareUpdateExclusive lock that's
> held during the operation.

REINDEX CONCURRENTLY and CIC can deadlock while waiting for each other
to finish after their validation phase, see:
https://www.postgresql.org/message-id/20190507030756.GD1499@paquier.xyz
https://www.postgresql.org/message-id/20190507032543.GH1499@paquier.xyz
--
Michael
Attachment

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: pg_wal/RECOVERYHISTORY file remains after archive recovery
Next
From: Chapman Flack
Date:
Subject: documentation inconsistent re: alignment