AW: Benchmarking

From: Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at>
To: "'Tatsuo Ishii'" <t-ishii(at)sra(dot)co(dot)jp>, romero(at)kde(dot)org
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: AW: Benchmarking
Date: 2001-06-27 09:08:06
Message-ID: 11C1E6749A55D411A9670001FA68796336834F@sdexcsrv1.f000.d0188.sd.spardat.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Zeugswetter Andreas SB 2001-06-27 09:17:57 AW: AW: functions returning records
Previous Message Zeugswetter Andreas SB 2001-06-27 09:04:38 AW: Re: Encrypting pg_shadow passwords