Is there a tool that would allow to storm a Pg database with lots of concurrent requests to determine their performance, reliability and chances of getting a deadlock?
Suppose I have a set of queries with bind values, which may in turn depend on other queries' results. I also have some test cases which I believe reflect real-life load.
So I'd like to have some module that would run those test cases in random order, repeatedly, in lots of threads, and measure performance, error rates, etc. for all queries separately.
I'm interested specifically in Perl because we are a Perl shop, but I wouldn't mind something scriptable in (say) python/lua/bash/etc. provided it does what I need.