Horton

Re: Deadlock between concurrent index builds on different tables

Jeremy Finzel <finzelj@gmail.com>

View thread View on postgr.es
From: Jeremy Finzel <finzelj@gmail.com>
To: Martin Marques <martin.marques@2ndquadrant.com>
Cc: Postgres General <pgsql-general@postgresql.org>
Date: 2017-12-23T18:13:20Z
Lists: pgsql-general 
>
> The only thing I can think of is that there's a foreign key from foo to
> bar(id), but the create index on bar shouldn't prevent a share lock on
> foo, even if such a restriction exists.
>
> --
> Martín Marqués                http://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Training & Services
>
No, there are no foreign keys at all in this db. It is a logical replica.

Thanks,
Jeremy

Commits

  1. Fix deadlock hazard in CREATE INDEX CONCURRENTLY