Re: Deadlock between concurrent index builds on different tables

From: Jeremy Finzel <finzelj(at)gmail(dot)com>
To: Martin Marques <martin(dot)marques(at)2ndquadrant(dot)com>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Deadlock between concurrent index builds on different tables
Date: 2017-12-23 18:13:20
Message-ID: CAMa1XUgN8eaSBba8bmOP7xXubGFCp1aECFR3029Yhfh_Y4v2yQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Melvin Davidson 2017-12-23 18:14:50 Re: Array of foreign key
Previous Message Jeremy Finzel 2017-12-23 18:11:47 Re: Deadlock between concurrent index builds on different tables