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

From: Marti Raudsepp <marti(at)juffo(dot)org>
To: Andrew Sackville-West <awest(at)janrain(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: regression, deadlock in high frequency single-row UPDATE
Date: 2014-08-01 15:40:51
Message-ID: CABRT9RCnVf+Jd3ecJSWa7fTSKF-qa2g-28QV9re9Kin=0o1VEw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Fri, Aug 1, 2014 at 2:30 AM, Andrew Sackville-West <awest(at)janrain(dot)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

Regards,
Marti

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andrew Sackville-West 2014-08-01 15:46:43 Re: regression, deadlock in high frequency single-row UPDATE
Previous Message Tom Lane 2014-08-01 15:30:07 Re: BUG #11107: UPDATE violates table check constraint