Re: Concurrency testing

On Wed, Oct 07, 2009 at 09:17:52AM -0700, David Fetter wrote:
> Folks,
> 
> As we move forward, we run into increasingly complex situations under
> the general rubric of concurrency.
> 
> What test frameworks are already out there that we can use in our
> regression test suite?  If there aren't any, how might we build one?

Apparently, this wasn't as crystal clear as I thought.  Let's imagine
you want to test some odd combination of transactions:

T1: SET TRANSACTION ISOLATION SERIALIZABLE;
T1: SELECT...FOR UPDATE...;
T2: UPDATE...
T3: COPY...
T1: ...

At the moment, we have no way to test this, although with certain Perl
modules, it would be pretty trivial.

I seem to recall that there were some patches to get psql to help with
such things, but they didn't go in.  Time to revive them?

Cheers,
David.
-- 
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate