Thread: AW: Benchmarking

> #! /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

> > #! /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