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(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
>
a perfect, thanks I'll see if I can reproduce this way and follow up.
A
--