Re: pgbench - compute & show latency consistently
От | Fabien COELHO |
---|---|
Тема | Re: pgbench - compute & show latency consistently |
Дата | |
Msg-id | alpine.DEB.2.20.1609211510240.1634@lancre обсуждение исходный текст |
Ответ на | Re: pgbench - compute & show latency consistently (Kuntal Ghosh <kuntalghosh.2007@gmail.com>) |
Ответы |
Re: pgbench - compute & show latency consistently
|
Список | pgsql-hackers |
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.
В списке pgsql-hackers по дате отправления: