Re: regression, deadlock in high frequency single-row UPDATE - Mailing list pgsql-bugs

From Andrew Sackville-West
Subject Re: regression, deadlock in high frequency single-row UPDATE
Date
Msg-id CAAdHSJk5zLJH3kPpEaN8KKcHqPbW_99Ma6PDoRpV73qpf2qLYA@mail.gmail.com
Whole thread Raw
In response to Re: regression, deadlock in high frequency single-row UPDATE  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Responses Re: regression, deadlock in high frequency single-row UPDATE
List pgsql-bugs
On Tue, Dec 9, 2014 at 6:14 AM, Alvaro Herrera <alvherre@2ndquadrant.com>
wrote:

> hubert depesz lubaczewski wrote:
> > For whatever it's worth, I was able to bisect the problem to this commi=
t:
> >
> > 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.
>
>
Thanks for your attention to this. Is there anything we're doing wrong that
could improve this in current 9.3 versions?

A


> --
> =C3=81lvaro Herrera                http://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
>
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs
>

pgsql-bugs by date:

Previous
From: Andrew Sackville-West
Date:
Subject: Re: regression, deadlock in high frequency single-row UPDATE
Next
From: Andres Freund
Date:
Subject: Re: regression, deadlock in high frequency single-row UPDATE