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 |
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 |