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 20140801154643.GA19615@andrew-ThinkPad-X230
Whole thread Raw
In response to Re: regression, deadlock in high frequency single-row UPDATE  (Marti Raudsepp <marti@juffo.org>)
List pgsql-bugs
On Fri, Aug 01, 2014 at 06:40:51PM +0300, Marti Raudsepp wrote:
> On Fri, Aug 1, 2014 at 2:30 AM, Andrew Sackville-West <awest@janrain.com> wrote:
> > I have not been able to reproduce the deadlock by making concurrent
> > UPDATEs via what amounts to a bash fork-bomb w/ psql, but I suspect my
> > methodology might be too crude there.
>
> Another way is using pgbench. Write a script file with the SQL query
> in it (must be on a single line). Then launch it as:
>     pgbench -f scriptfile.sql -n -c 10 dbname
>

a perfect, thanks I'll see if I can reproduce this way and follow up.

A


--

pgsql-bugs by date:

Previous
From: Marti Raudsepp
Date:
Subject: Re: regression, deadlock in high frequency single-row UPDATE
Next
From: David G Johnston
Date:
Subject: Re: BUG #11107: UPDATE violates table check constraint