Hello Kuntal,
> <screen>
> transaction type: <builtin: TPC-B (sort of)>
> 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
querymode: simple number of clients: 10 number of threads: 1 number of transactions per client: 1000 number of
transactionsactually 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.