Postgres Pro
Downloads
Home   >   mailing lists

Re: Deadlock between concurrent index builds on different tables - Mailing list pgsql-general

From Jeremy Finzel
Subject Re: Deadlock between concurrent index builds on different tables
Date
Msg-id CAMa1XUgN8eaSBba8bmOP7xXubGFCp1aECFR3029Yhfh_Y4v2yQ@mail.gmail.com
Whole thread Raw
In response to Re: Deadlock between concurrent index builds on different tables  (Martin Marques <martin.marques@2ndquadrant.com>)
List pgsql-general
Tree view


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 

pgsql-general by date:

Previous
From: Jeremy Finzel
Date:
Subject: Re: Deadlock between concurrent index builds on different tables
Next
From: Melvin Davidson
Date:
Subject: Re: Array of foreign key