> > #! /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.
Good point. I have been used it since 7.0 and forgot to update for
7.1.
--
Tatsuo Ishii