> #! /bin/sh
> pgbench -i -s 2 test
> for i in 1 2 4 8 16 32 64 128
> do
>       t=`expr 640 / $i`
>       pgbench -t $t -c $i test
>       echo "===== sync ======"

With 7.1 you will probably want a checkpoint instead of sync here:
        psql -c "checkpoint;" template1 ; sleep 10
The sync does not help, since the pages are not yet written. 

>       sync;sync;sync;sleep 10
>       echo "===== sync done ======"
> done

Andreas

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to