Re: AW: Benchmarking - Mailing list pgsql-hackers

From Tatsuo Ishii
Subject Re: AW: Benchmarking
Date
Msg-id 20010627220851C.t-ishii@sra.co.jp
Whole thread Raw
In response to AW: Benchmarking  (Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at>)
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. 

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


pgsql-hackers by date:

Previous
From: Alex Pilosov
Date:
Subject: Re: AW: functions returning records
Next
From: Hannu Krosing
Date:
Subject: Re: functions returning records