Re: pgbench - compute & show latency consistently

Hello Kuntal,

> <screen>
> transaction type: &lt;builtin: TPC-B (sort of)&gt;
> scaling factor: 10
> query mode: simple
> number of clients: 10
> number of threads: 1
> number of transactions per client: 1000
> number of transactions actually processed: 10000/10000
> tps = 85.184871 (including connections establishing)
> tps = 85.296346 (excluding connections establishing)
> </screen>
>
> Shouldn't we include latency average here as well and explain what it is?

Indeed, now it seems to be always printed but the documentation did not
follow, there should be a:

latency average = 117.392 ms

In front of the tps line. Well, the performance displayed could also be
improved... On my dual core SSD laptop I just got:

sh> ./pgbench -c 10 -t 1000
starting vacuum...end.
transaction type: <builtin: TPC-B (sort of)>
scaling factor: 100
query mode: simple
number of clients: 10
number of threads: 1
number of transactions per client: 1000
number of transactions actually processed: 10000/10000
latency average = 9.527 ms
tps = 1049.665115 (including connections establishing)
tps = 1049.890194 (excluding connections establishing)

Which is about 10 times better.

--
Fabien.