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

Wed, 27 Jun 2001 11:08:06 +0200
Zeugswetter Andreas SB  <ZeugswetterA@wien.spardat.at>
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. 

Good point. I have been used it since 7.0 and forgot to update for
7.1.
--
Tatsuo Ishii

Wed, 27 Jun 2001 22:08:51 +0900
Tatsuo Ishii <t-ishii@sra.co.jp>
Re: AW: Benchmarking