Re: pgbench - compute & show latency consistently

On Wed, Sep 21, 2016 at 6:53 PM, Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> wrote:
> 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.

Yes, you are right. In the documentation, the above example has not
been updated across different pg versions. Although this is just an
example, it should reflect the current performance.

--
Thanks & Regards,
Kuntal Ghosh
EnterpriseDB: http://www.enterprisedb.com