script.sh

application/x-sh

Filename: script.sh

Type: application/x-sh

Part: 0

Message: Re: 9.2beta1, parallel queries, ReleasePredicateLocks, CheckForSerializableConflictIn in the oprofile

PSQL="/opt/pgsql/bin/psql"

echo "********PARALLEL EXECUTION**********"
for a in 0 1 2 3 4 5 6 7 ; do {
	( cat script.sql | sed "s/XX/$a/g"  | $PSQL ) & 
} ; done

wait
echo "********SEQUENTIAL EXECUTION**********"

for a in 0 1 2 3 4 5 6 7 ; do {
	( cat script.sql | sed "s/XX/$a/g"  | $PSQL ) 
} ; done