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

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

Regards,
Marti