AW: Benchmarking - Mailing list pgsql-hackers

From Zeugswetter Andreas SB
Subject AW: Benchmarking
Date
Msg-id 11C1E6749A55D411A9670001FA68796336834F@sdexcsrv1.f000.d0188.sd.spardat.at
Whole thread Raw
Responses Re: AW: Benchmarking  (Tatsuo Ishii <t-ishii@sra.co.jp>)
List pgsql-hackers
> #! /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


pgsql-hackers by date:

Previous
From: Zeugswetter Andreas SB
Date:
Subject: AW: Re: Encrypting pg_shadow passwords
Next
From: Zeugswetter Andreas SB
Date:
Subject: AW: AW: functions returning records