Wrong result with pgbench -C option?

From: Yoshiyuki Asaba <y-asaba(at)sraoss(dot)co(dot)jp>
To: pgsql-patches(at)postgresql(dot)org
Subject: Wrong result with pgbench -C option?
Date: 2007-12-06 03:25:00
Message-ID: 20071206.122500.123985406.y-asaba@sraoss.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

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

Attachment Content-Type Size
unknown_filename text/plain 5.0 KB

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2007-12-06 16:58:51 Re: PQParam version 0.5
Previous Message Gregory Stark 2007-12-06 00:00:30 Re: Better default_statistics_target