Horton

Re: regression, deadlock in high frequency single-row UPDATE

Alvaro Herrera <alvherre@2ndquadrant.com>

View thread View on postgr.es
From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: hubert depesz lubaczewski <depesz@gmail.com>
Cc: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>, pgsql-bugs@postgresql.org, Paulo Tanimoto <paulo@janrain.com>
Date: 2014-12-09T14:14:48Z
Lists: pgsql-bugs 
hubert depesz lubaczewski wrote:
> For whatever it's worth, I was able to bisect the problem to this commit:
> 
> commit
> 0ac5ad5134f2769ccbaefec73844f8504c4d6182
> 
> Author: Alvaro Herrera <alvherre@alvh.no-ip.org>
> 
> Date:   Wed Jan 23 12:04:59 2013 -0300
> 
>     Improve concurrency of foreign key locking

I'm not surprised in the least, TBH.

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

Commits

  1. Add isolationtester spec for old heapam.c bug

  2. Improve concurrency of foreign key locking