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

From Alvaro Herrera
Subject Re: regression, deadlock in high frequency single-row UPDATE
Date
Msg-id 20141212215752.GF1768@alvh.no-ip.org
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
Re: regression, deadlock in high frequency single-row UPDATE
List pgsql-bugs
Alvaro Herrera wrote:
> Alvaro Herrera wrote:
>
> > I'm going to experiment with that idea and see if it leads to a
> > solution.  I tried the other idea yesterday (to keep the HW tuple lock
> > we acquire in heap_lock_tuple until heap_update is done) but aside from
> > being very complicated and bug-prone, it doesn't solve the problem
> > anyway.
>
> Here's a preliminary patch.

Here's a finished version of this patch, which I messed a bit with and
so needs some extra testing.  I want to push this shortly and backpatch
to 9.4 and 9.3.  I don't want to disrupt the 9.4.0 release next week,
but it'd be nice not to ship it with this bug.

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

Attachment

pgsql-bugs by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: regression, deadlock in high frequency single-row UPDATE
Next
From: Mark Kirkwood
Date:
Subject: Re: regression, deadlock in high frequency single-row UPDATE