Skip site navigation (1) Skip section navigation (2)

Re: Wrong result with pgbench -C option?

From: Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>
To: y-asaba(at)sraoss(dot)co(dot)jp
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: Wrong result with pgbench -C option?
Date: 2008-03-19 00:29:56
Message-ID: 20080319.092956.119869332.t-ishii@sraoss.co.jp (view raw or flat)
Thread:
Lists: pgsql-patches
Patch applied. Thanks.
--
Tatsuo Ishii
SRA OSS, Inc. Japan

> Hi,
> 
> I ran pgbench with -C option. Here is an output.
> 
> % pgbench -C  -c 10 -t 100  bench
> starting vacuum...end.
> transaction type: TPC-B (sort of)
> scaling factor: 1
> number of clients: 10
> number of transactions per client: 100
> number of transactions actually processed: 1000/1000
> tps = 83.209663 (including connections establishing)
> tps = 83.209663 (excluding connections establishing)
> 
> The first tps was equal to the second tps. I think it is wrong because
> pgbench with -C option connects per transaction.
> 
> The attached patch calculates total connection time. Here is an output
> with revised pgbench.
> 
> % ./pgbench -C  -c 10 -t 100  bench
> starting vacuum...end.
> transaction type: TPC-B (sort of)
> scaling factor: 1
> number of clients: 10
> number of transactions per client: 100
> number of transactions actually processed: 1000/1000
> tps = 108.410991 (including connections establishing)
> tps = 228.657561 (excluding connections establishing)
> 
> Regards,
> --
> Yoshiyuki Asaba
> y-asaba(at)sraoss(dot)co(dot)jp

In response to

pgsql-patches by date

Next:From: Tatsuo IshiiDate: 2008-03-19 00:31:04
Subject: Re: Patch for testing query modes on pgbench
Previous:From: Tom LaneDate: 2008-03-18 22:05:29
Subject: Re: Patch to inline stable SQL set returning UDFs

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group