Re: Testing with concurrent sessions

Alvaro Herrera <alvherre@commandprompt.com>

From: Alvaro Herrera <alvherre@commandprompt.com>

To: Marko Tiikkaja <marko.tiikkaja@cs.helsinki.fi>

Cc: Peter Eisentraut <peter_e@gmx.net>, Kevin Grittner <Kevin.Grittner@wicourts.gov>, "David E. Wheeler" <david@kineticode.com>, pgsql-hackers@postgresql.org

Date: 2010-01-06T23:04:32Z

Lists: pgsql-hackers

Marko Tiikkaja wrote:
> On 2010-01-07 00:08 +0200, Peter Eisentraut wrote:

> >Then I don't see much of a point in using Perl.  You might as well fire
> >up a few psqls from a shell script.
> 
> I don't see how that would work, but I might have misunderstood what
> we're reaching for here.  What I think would be most useful would be
> to interleave statements between transactions, not just randomly
> fire psql sessions and hope for race conditions.

Open a few psql with -f pointing to a pipe, and from the shell write
into the pipe?  I don't think it's straightforward, but it should be
possible.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support