Re: BUG #8434: Why does dead lock occur many times ?

Hi,

Sorry I hadn't noticed this thread.

Tomonari Katsumata escribió:

> It seems to be related to some changes in
> the [Improve concurrency of foreign key locking] commit(*).
> (*) commitid : 0ac5ad5134f2769ccbaefec73844f8504c4d6182
> Because I could not reproduce "dead lock" before the commit.

Yes, sounds pretty likely.

> And I'm thinking that also this commit is related to BUG#8470.

Yes, I replied to that thread because I suspect the same.

> If so, I hope Alvaro will find the solution for this problem.

I will take a look at this problem next week.

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services